From which two failure scenarios can a database be restored and recovered with the REPAIR DATABASE command? (Choose two.)

The correct answer is D. loss of all copies of the control file E. loss of a critical data file such as SYSTEM, SYSAUX or UNDO. Explanation/Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta033.htm#RCMRF199

New Features for High Availability

Question

Options

Aloss of ARCHIVELOGS
Bloss of a redo log member
Closs of a noncritical data file
Dloss of all copies of the control file
Eloss of a critical data file such as SYSTEM, SYSAUX or UNDO
Floss of SPFILE

How the community answered

(25 responses)

B
12% (3)
C
4% (1)
D
76% (19)
F
8% (2)

Explanation

Explanation/Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta033.htm#RCMRF199

Topics

#REPAIR DATABASE#control file loss#critical data file recovery#RMAN

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice