Oracle Database 12c: Advanced Administration — Question 185

Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?

Answer options

• A. The current online redo log file is missing.
• B. A data file belonging to a noncritical tablespace is missing.
• C. All the control files are missing.
• D. The database backup is older than the control file backup.
• E. All the data files are missing.

Correct answer: C, D

Explanation

The command is required when all control files are missing (option C) because it allows recovery using a backup control file. Additionally, if the database backup is older than the control file backup (option D), this command is necessary to ensure the database can be recovered to a consistent state. The other options do not necessitate this specific command for recovery.