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

The correct answer is C. All the control files are missing. D. The database backup is older than the control file backup. https://docs.oracle.com/cd/B10501_01/server.920/a96572/performingreco.htm

New Features for Availability

Question

Examine the command:

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

Options

AThe current online redo log file is missing.
BA data file belonging to a noncritical tablespace is missing.
CAll the control files are missing.
DThe database backup is older than the control file backup.
EAll the data files are missing.

How the community answered

(19 responses)

A
11% (2)
B
16% (3)
C
68% (13)
E
5% (1)

Explanation

https://docs.oracle.com/cd/B10501_01/server.920/a96572/performingreco.htm

Topics

#backup controlfile#incomplete recovery#control file loss#UNTIL CANCEL

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice