Upgrade to Oracle Database 12c — Question 2

Your database is running in ARCHIVELOG mode. You back up the control file by executing ALTER DATABASE BACKUP CONTROL TO TRACE
NORESETLOGS, whenever you make structural changes to the database. A media failure has damaged all the control files, but the online redo log files are intact.
You issue a SHUTDOWN ABORT.
How should you recover the control file to its default location?

Answer options

• A. Restore the backup control file to all the locations specified in the CONTROL_FILES parameter file, start a new instance and mount the database, recover the database, and then open the database with the RESETLOGS option.
• B. Issue the STARTUP NOMOUNT command, restore the backup control file only to the default location, issue RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL, and open the database with the RESETLOGS option.
• C. Issue the STARTUP MOUNT command, restore the backup control file to all the locations specified in the CONTROL_FILES parameter file, and then issue RECOVER DATABASE USING BACKUP CONTROLFILE.
• D. Issue the STARTUP NOMOUNT command, re-create the control file manually by using the CREATE CONTROLFILE command, issue the RECOVER DATABASE command, and then issue the ALTER DATABASE OPEN command.

Correct answer: B

Explanation

The correct answer is B because it correctly describes the steps needed to recover the control file using the backup control file at the default location. Option A is incorrect as it involves unnecessary actions of restoring to multiple locations and additional steps. Option C fails to specify the restoration to the default location only, and D incorrectly suggests re-creating the control file manually, which is not needed when a backup exists.