Upgrade Oracle DBA 11g to Oracle Database 12c — Question 28

You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

Answer options

• A. Corrupted blocks, if any, are repaired in the backup created.
• B. Only those data files that have corrupted blocks are backed up.
• C. Corrupted blocks in the data files are checked and repaired before performing the database backup.
• D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.

Correct answer: C

Explanation

The correct answer is C because the command 'BACKUP VALIDATE DATABASE' checks for corrupted blocks, and 'RECOVER CORRUPTION LIST' handles the repair of those blocks prior to the backup process. Options A, B, and D are incorrect as they either misinterpret the actions taken or incorrectly suggest that the backup process itself includes repairs or is limited to specific data files.