Oracle Database 12c: Installation and Administration — Question 232

In your database, archive logging and control file autobackup are enabled.
The data files and redo log files are intact but control files are impacted due to media failure.
In which two recovery scenarios must you use the RESETLOGS option? (Choose two.)

Answer options

• A. One control file copy is intact so the spfile is changed to refer to only one copy.
• B. One control file copy is intact and damaged control file copies have to be restored to the default location.
• C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually.
• D. All copies of the control file are damaged and the auto backed up control file is used for recovery.
• E. One control file copy is intact and damaged control file copies have to be restored to a non-default location.

Correct answer: C, D

Explanation

The RESETLOGS option is needed in scenarios where all control file copies are damaged and a new control file is being created (option C) or when recovering from an auto-backed up control file (option D) after a complete loss of all copies. The other options do not require RESETLOGS as they involve scenarios where at least one control file is still intact or being restored to default locations.