Upgrade Oracle DBA 11g to Oracle Database 12c — Question 49

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: A, C

Explanation

The command is needed when the current online redo log file is missing (A) because recovery requires access to redo logs to apply changes. It is also essential when all control files are missing (C), as the command instructs Oracle to use a backup control file for recovery. The other options do not necessitate this command for recovery.