Oracle Database 12c: Installation and Administration — Question 184

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup.
In which three scenarios do you need media recovery? (Choose three.)

Answer options

• A. loss of all the copies of the control file
• B. loss of all the inactive online redo log group members
• C. loss of a data file that belongs to the active undo tablespace
• D. loss of data files that belong to the SYSTEM tablespace
• E. logical corruption of data that is caused by a wrong transaction
• F. abnormal termination of the database instance

Correct answer: A, C, D

Explanation

Media recovery is required in scenarios A, C, and D because they involve the loss of critical components that affect the database's ability to function correctly. Losing all copies of the control file (A) prevents the database from recovering its structure, while the loss of data files in the active undo tablespace (C) and the SYSTEM tablespace (D) directly impacts the database's integrity and availability. The other options do not necessitate media recovery in the same way.