OCP CBT Question 697

Please solve the following question.

You have lost your SPFILE due to a disk failure, and your database instance is down. You have RMAN backups available, and `CONTROLFILE AUTOBACKUP` was enabled. Which sequence of RMAN commands would you use to restore the SPFILE and bring the database back online?

Scenario

The database instance is down, and the SPFILE is corrupted or lost. The control file autobackup contains the necessary SPFILE information.

RMAN> STARTUP MOUNT; 2. RMAN> RESTORE SPFILE FROM AUTOBACKUP; 3. RMAN> ALTER DATABASE OPEN;

RMAN> SET DBID = <dbid>; 2. RMAN> STARTUP NOMOUNT; 3. RMAN> RESTORE SPFILE; 4. RMAN> STARTUP FORCE;

RMAN> CONNECT TARGET /; 2. RMAN> RESTORE SPFILE FROM AUTOBACKUP; 3. RMAN> SHUTDOWN IMMEDIATE; 4. RMAN> STARTUP;

RMAN> STARTUP NOMOUNT; 2. RMAN> RESTORE SPFILE FROM <location>; 3. RMAN> ALTER DATABASE MOUNT; 4. RMAN> ALTER DATABASE OPEN;