Oracle Database 12c: Advanced Administration — Question 148

Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1.Restore the control files by using the RMAN restore controlfile command.
2.Mount the database.
3.Restore the data files by using the RMAN restore database command.
4.Open the database with the resetlogs option.
5.Recover the data files by using the RMAN recover using backup controlfile command.
6.Start the database instance in nomount state.
7.Connect to the target database by using a recovery catalog.
8.Open the database.
9.Restore the data file.
10.Recover the data file.
Identify the required steps in the correct order.

Answer options

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

Correct answer: D

Explanation

The correct sequence begins with connecting to the target database through the recovery catalog and starting the instance in nomount state. Then, you restore the control files, mount the database, and restore the specific data file. Finally, you recover the data file and open the database with the resetlogs option. The other options are incorrect as they either miss steps or present them in the wrong order.