Oracle Database 12c: Advanced Administration — Question 159

You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation?

Answer options

• A. You must configure a block change tracking file.
• B. You must use an incremental level-1 backup to restore blocks.
• C. You must ensure that the database is mounted or open.
• D. You must have full or level-0 backups to restore blocks.
• E. You must take the tools01.dbf data file offline.

Correct answer: C, D

Explanation

The correct answers, C and D, indicate that the database must be in a mounted or open state and that full or level-0 backups are necessary for restoring blocks. Options A, B, and E are not prerequisites for block media recovery; A deals with change tracking, B relates to incremental backups which are not required, and E is not necessary as the data file does not need to be offline.