What methods are available to recover lost control files?

What methods are available to recover lost control files? (Choose all that apply.)

What methods are available to recover lost control files? (Choose all that apply.)

A.
Backup control file.

B.
Emergency control file.

C.
The create controlfile command.

D.
The restore controlfile SQL*Plus command.

E.
No backup is required. The database will re-create the control file when it is discovered to be
lost.



Leave a Reply 5

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


Helcio

Helcio

D is wrong… the restore controlfile is a RMAN command.

Helcio

Helcio

Sorry… C and D are OK.

lei

lei

I think the correct answer is AC.
If the control files are lost, you can use either the backup controlfile or create controlfile command to recover them.
The restore controlfile command just restores the backup control file from a backup. If there is no backup available, the restore controlfile command can not nothing.

vasya_pupkin

vasya_pupkin

>>I think the correct answer is AC.
A? why do you need to backup controlfile after its lost?

lei

lei

Option A means the backup of controlfile.
The backup of controlfile is created by, e.g. the controlfile autobackup feature of RMAN.