Oracle Database Administration II — Question 34

A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken daily and no backup to trace has been taken of the control file.
A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)

Answer options

• A. when any archived log from, before, or after the most recent backup is corrupt.
• B. after losing all copies of the control file
• C. after losing an archived log from after the most recent backup
• D. after losing an archived log from before the most recent backup
• E. after losing the SYSTEM tablespace

Correct answer: D, E

Explanation

Complete recovery is possible in scenarios D and E. In scenario D, losing an archived log from before the most recent backup does not impede recovery because the logs before the last backup are still available. In scenario E, even if the SYSTEM tablespace is lost, recovery can still proceed as long as the critical backups are intact; the database can be restored from the last backup and the necessary archived logs.