Which two statements are true about the RMAN validate database command?

Question

Options

• AIt checks the database for intrablock corruptions.
• BIt can detect corrupt pfiles.
• CIt can detect corrupt spfiles.
• DIt checks the database for interblock corruptions.
• EIt can detect corrupt block change tracking files.

• A
  94% (61)
• B
  2% (1)
• D
  2% (1)
• E
  3% (2)

Explanation

Block corruptions can be divided Into Interblock corruption and intrablock corruption. In intra- block corruption. the corruption occurs within the block itself and can be either physical or logi- cal corruption. In interblock corruption, the corruption occurs between blocks and can only be logical (key word) * The VALIDATE command checks for intrablock corruptions only. Only DBVER- IFY and the ANALYZE statement detect Interblock corruption. VALIDATE Command Output ··> List of Control File and SPFILE. File TYPE >»» SPFILE or Control File. Status >»» OK if no corruption, or FAILED If block corruption is found. Blocks Failing »»» The number of blocks that fail the corruption check. These blocks are newly corrupt. Blocks Examined »»» Total number of blocks in the file.

No community discussion yet for this question.