OCP CBT Question 574

Please solve the following question.

The SPFILE for your Oracle database instance has become corrupted or lost, preventing the database from starting. You have a recent RMAN backup that includes the SPFILE. Which RMAN command sequence would you use to restore the SPFILE and start the database?

sql-- SPFILE is lost or corrupted.-- Database instance is currently down.-- RMAN backups include the SPFILE.

sqlRMAN> STARTUP NOMOUNT;RMAN> RESTORE SPFILE FROM AUTOBACKUP;RMAN> STARTUP;

sqlRMAN> STARTUP NOMOUNT;RMAN> RESTORE SPFILE;RMAN> STARTUP;

sqlRMAN> RESTORE SPFILE FROM AUTOBACKUP;RMAN> STARTUP;

sqlRMAN> CREATE PFILE FROM SPFILE;RMAN> STARTUP;