You have discovered that one of three control files has been lost. What steps would you
follow to recover that control file?
A.
Shut down the database.
a, b, f, g
B.
Restore a control-file copy from backup media.
c, f, g
C.
Use the create control file command to create a new control file.
a, d, f, g
D.
Copy the backup control file into place.
a, f, g
E.
Create a new copy of the control file from one of the surviving control files.
a, e, g
F.
Recover the database using the recover database using BACKUP CONTROLFILE
command.
G.
Start up the database.
A.
Shut down the database.
a, b, f, g
B.
Restore a control-file copy from backup media.
c, f, g
C.
Use the create control file command to create a new control file.
a, d, f, g
D.
Copy the backup control file into place.
a, f, g
E.
Create a new copy of the control file from one of the surviving control files.
a, e, g
A.Shut down the database.
B. Restore a control-file copy from backup media.
C. Use the create control file command to create a new control file.
D. Copy the backup control file into place.
E. Create a new copy of the control file from one of the surviving control files.
F. Recover the database using the recover database using BACKUP CONTROLFILE
command.
G. Start up the database.
A. a, b, f, g
B. c, f, g
C. a, d, f, g
D. a, f, g
E. a, e, g
Assuming the question is that posted by @noe
@noe, thanks for posting it by the way.
The correct answer is E
However it is possible that a “Shut down the database” is not required because normally if you lose a controlfile the database crashed. See
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV90039