Oracle Database 12c: Advanced Administration — Question 122

You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1.Restore an autobackup of the server parameter file.
2.Restore the control file.
3.Start up the database instance in nomount state.
4.Mount the database.
5.Restore the data files.
6.Open the database with the resetlogs option.
7.Recover the data files.
8.Set D3ID for the database.
Identify the required steps in the correct order.

Answer options

• A. 1, 8, 3, 2, 4, 5, 7, 6
• B. 8, 1, 3, 2, 4, 5, 7, 6
• C. 1, 3, 2, 4, 8, 5, 6, 7
• D. 8, 3, 2, 4, 5, 7, 6
• E. 8, 1, 3, 2, 4, 5, 6

Correct answer: D

Explanation

The correct answer is D because it follows the proper sequence for database recovery after a complete loss. First, the database is started in nomount state and the control file is restored, followed by mounting the database, restoring the data files, and recovering them before opening the database with the resetlogs option. The other options do not maintain the necessary sequence for a successful recovery process.