Upgrade to Oracle Database 12c — Question 15

Your database runs in NOARCHIVELOG mode.
Whole database backups are taken daily.
A media failure damages data files belonging to the USERS tablespace and the online redo log files.
The hardware that is causing this damage is not repairable.
You issue the SHUTDOWN ABORT command.
Examine these steps:
1. Restore only the damaged files from the whole database backup to a new location.
2. Restore the whole database backup to a new location.
3. Edit the restored initialization parameter file to indicate the new location of the control files.
4. Issue the STARTUP MOUNT command.
5. Issue the STARTUP NOMOUNT command.
6. Issue the RECOVER DATABASE command.
7. Update the control file to reflect the new data file locations by using the ALTER DATABASE RENAME FILE command.
8. Specify a new location for each affected online log by issuing the command:

RECOVER DATABASE UNTIL CANCEL -
9. Open the database in RESETLOGS mode.
Identify the minimum steps required in the correct sequence to recover your database.

Answer options

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

Correct answer: B

Explanation

The correct answer is B because it includes restoring the damaged files, starting the database in the appropriate state, and updating the control file before recovering the database. Option A is incorrect as it lacks the necessary recovery steps, C misses the required commands to open the database, and D starts with restoring the whole database instead of just the damaged files.