OCP CBT Question 568

Please solve the following question.

A critical disk failure results in the loss of all control files for your Oracle database. The database is in ARCHIVELOG mode, and you have a valid RMAN full backup, including control file autobackups. The database instance is currently down. Which sequence of RMAN commands should you use to recover the control files and open the database?

sql-- All control files are lost.-- Database name: ORCL-- RMAN control file autobackup is configured and enabled.

sqlRMAN> STARTUP NOMOUNT;RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP;RMAN> ALTER DATABASE MOUNT;RMAN> RECOVER DATABASE;RMAN> ALTER DATABASE OPEN RESETLOGS;

sqlRMAN> RESTORE CONTROLFILE FROM AUTOBACKUP;RMAN> RECOVER DATABASE;RMAN> ALTER DATABASE OPEN;

sqlRMAN> STARTUP FORCE;RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP;RMAN> RECOVER DATABASE;RMAN> ALTER DATABASE OPEN;

sqlRMAN> STARTUP;RMAN> RESTORE CONTROLFILE;RMAN> RECOVER DATABASE;RMAN> ALTER DATABASE OPEN RESETLOGS;