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.