What steps would you follow to recover that control file?

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.
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.

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.
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



Leave a Reply 0

Your email address will not be published. Required fields are marked *