You execute the following Recovery Manager (RMAN) commands in (he following order:
BACKUP VALIDATE DATABAE
RECOVER CORRUPTION LIST;
Which (two tasks are performed by these commands? (Choose two.)
A.
Repair the corrupted blocks. If any. In the backup created.
B.
Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks-C. Back up the database after checking whether array of the files have corrupted blocks.
D.
Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION
view.
E.
Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_
CORRUPTION
D and E are correct.
Sorry … B and E are correct.
The aswer is D and E
RMAN will automatically detect corruption in blocks whenever a backup or backup
validate command is issued. These blocks are reported as corrupt in the alert.log file and the V$DATABASE_BLOCK_CORRUPTION view. You can instruct RMAN to recover the
blocks listed as corrupt in that view as follows:
RMAN> recover corruption list;
Here are the various locations that Oracle will record block-level corruption:
• RMAN backup populates V$DATABASE_BLOCK_CORRUPTION.
• Trace files.
• Alert.log file.
• Output of dbverify utility.
• Output of SQL analyze … validate structure command.
• V$BACKUP_CORRUPTION and V$COPY_CORRUPTION will list corrupt blocks in
backup piece files.
RMAN Recipes for Oracle Database 11g A Problem-Solution Approach
D E