Oracle Database 12c: Installation and Administration — Question 80

One of your databases has archive logging enabled and RMAN backups are taken at regular intervals.
The data file for the USERS tablespace is corrupt.
Which command must you execute before starting the recovery of this tablespace?

Answer options

• A. STARTUP FORCE
• B. ALTER TABLESPACE users OFFLINE IMMEDIATE;
• C. SWITCH DATAFILE ALL;
• D. ALTER TABLESPACE users OFFLINE NORMAL;
• E. ALTER TABLESPACE users OFFLINE TEMPORARY;

Correct answer: E

Explanation

The correct command is E because it allows the tablespace to be taken offline in a temporary state, which is necessary for recovery. Options A, B, C, and D do not appropriately prepare the tablespace for recovery, as they either force startup, take it offline immediately, or do not address the temporary requirement for recovery.