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

Show Hint

Leave a Reply 1

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

9 + seven =

Cương Thi Tiên Sinh

Cương Thi Tiên Sinh

Control file (1 fail – 2 good): Best practice is rman> restore control file from good_control_file_path.
Lost control file, DB is usually crash or running => shutdown Abort (mandatory) => startup nomount (using parameter file only) => rman restore control_file from good copy => alter database mount => alter database open (no resetlogs).

Reply