Oracle Database 12c: Advanced Administration — Question 89

Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incrementally every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost.
You want to recover the data file as quickly as possible while maximizing availability for the database.
Examine the possible steps involved in the recovery process:
1. Mount the database.
2. Take the data file offline.
3. Bring the tablespace online.
4. Use the RMAN SWITCH command to switch to the image copy.
5. Recover the tablespace.
6. Open the database.
7. Use the RMAN RESTORE command to switch to the image copy.
Identify the correct sequence of the required steps.

Answer options

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

Correct answer: C

Explanation

The correct sequence starts with mounting the database, taking the data file offline, and then using the RMAN SWITCH command to switch to the image copy before bringing the tablespace online. This ensures that the missing data file is properly handled before making the tablespace available. Other options either skip necessary steps or do not maintain the required sequence for a successful recovery.