Oracle Database 12c: Advanced Administration — Question 96

Your database is on ARCHIVELOG mode and an incremental backup exists.
A media failure in the loss of a data file and an online redo log.
Examine these commands:
1. STARTUP NOMOUNT
2. STARTUP MOUNT
3. RESTORE DATABASE
4. RECOVER DATABASE
5. RECOVER DATABASE UNTIL CANCEL
6. ALTER DATABASE OPEN
7. ALTER DATABASE OPEN RESETLOGS
Which commands are required to recover your database?

Answer options

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

Correct answer: E

Explanation

To recover the database in ARCHIVELOG mode after a media failure, you must first start the instance in NOMOUNT mode, then mount the database, restore it from the backup, and finally recover it using the available logs before opening it. Options A, B, C, and D do not include the necessary 'ALTER DATABASE OPEN' command after recovery, which is crucial for accessing the database.