Oracle Database 12c: Advanced Administration — Question 46

You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on
Sundays and level 1 incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery?

Answer options

• A. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.
• B. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.
• C. Restore all the data files, recover them by using the recover database command, and open the database.
• D. Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Correct answer: B

Explanation

The correct action is to restore the control file and all data files, then perform recovery using the recover database noredo command, followed by opening the database with the resetlogs option. This is necessary because, in noarchivelog mode without a current redo log, the database cannot be recovered in a standard way, and the control file needs to be restored to ensure consistency. The other options either do not address the need for restoring the control file or suggest incorrect recovery methods.