Oracle Database 12c: Advanced Administration — Question 171

One of your databases is in ARCHIVELOG mode and take nightly RMAN backups.
The USERS and IDX tablespaces are missing due to storage array errors.
Which four actions would recover the tablespaces and their contents while the database remains open? (Choose four.)

Answer options

• A. Bring both tablespaces ONLINE.
• B. Recover both tablespaces.
• C. Take both tablespaces OFFLINE NORMAL.
• D. Take both tablespaces OFFLINE IMMEDIATE.
• E. Restore both tablespaces from the most recent backup.
• F. Bring both tablespaces ONLINE and rebuild all the instances in the IDX tablespace.

Correct answer: A, B, D, E

Explanation

The correct actions involve bringing the tablespaces online, recovering them, and taking them offline immediately if necessary to manage the recovery process. Options C and F are not suitable as taking tablespaces offline normal or rebuilding instances does not address the immediate recovery of the missing tablespaces.