Oracle Database Administration II — Question 45

A database is configured in ARCHIVELOG mode.
A full RMAN backup exists but no control file backup to trace has been taken.
A media failure has occurred.
In which two scenarios is incomplete recovery required? (Choose two.)

Answer options

• A. after losing a SYSAUX tablespace data file
• B. after losing all members of an INACTIVE online redo log group
• C. after losing all members of the CURRENT online redo log group
• D. after losing all copies of the control file
• E. after losing an UNDO tablespace that is in use

Correct answer: C, D

Explanation

Incomplete recovery is required when the CURRENT online redo log group is lost (option C) since the database cannot apply any further changes without it. Additionally, if all copies of the control file are lost (option D), the database cannot operate or access its previous state, necessitating incomplete recovery. The other options either do not affect the ability to perform recovery or relate to components that can be recreated or restored without requiring incomplete recovery.