Your database is up and running and one of your three control files is accidentally erased.
You start RMAN and run the following command:
RESTORE CONTROLFILE FROM AUTOBACKUP;
Which of the following statements is true? (Choose all that apply.)
A.
The command restores only the missing control file.
B.
The command restores all the control files.
C.
The command fails because the database is running.
D.
This is the correct way to address this problem.
E.
This is not the correct way to address this problem.
Explanation:
During the database running, the control files are locked by the database instance, you must
shutdown the database and startup at NOMOUNT status to restore a missing control file.
And you have to open database with RESETLOGS option, due to control file change.
The question is not clear: db is running then one control file is lost => then DB can crash or run.=> So C can right or wrong.
With a good copy of control file: rman> restore control file from pathname. => E correct.