Oracle Database 12c: Advanced Administration — Question 118

In which three scenarios is media recovery required?

Answer options

• A. when a tablespace is accidentally dropped from a database
• B. when archived redo log files are lost
• C. when data files are lost
• D. when one of the online redo log members is corrupted
• E. when all control files are lost

Correct answer: A, C, E

Explanation

Media recovery is needed when critical components of the database are missing or corrupted. Option A involves the accidental dropping of a tablespace, which requires restoration. Option C deals with lost data files, also necessitating recovery, while option E refers to the loss of all control files, which is critical for database operations. Options B and D do not require media recovery as they pertain to redo logs, which can often be recovered from other sources.