Oracle Database 12c: Installation and Administration — Question 138

A database instance is started by using an SPFILE. The database is configured in ARCHIVELOG mode and the control file autobackup is configured. Daily full database backups are performed by using RMAN.
You lost all control files due to media failure.
Given the steps to recover from the error in random order:
1. Shut down the instance, if it is not already down.
2. Restore the control file from autobackup to a new location.
3. Start the database instance to NOMOUNT state.
4. Recover the database to the point of failure of the control file.
5. Open the database with the RESETLOGS option.
6. Mount the database.
7. Update the SPFILE with the new location of the control file by using the ALTER SYSTEM command.
Identify the correct sequence of the required steps.

Answer options

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

Correct answer: A

Explanation

The correct order begins with shutting down the instance if it's running, then starting it in NOMOUNT state to allow for control file restoration. After restoring the control file and mounting the database, the SPFILE is updated with the new control file location, followed by recovering the database and finally opening it with the RESETLOGS option. Other sequences fail to place the steps in the necessary logical order for a successful recovery.