OCP CBT Question 643

Please solve the following question.

Your database instance fails to start because the SPFILE has been accidentally deleted from its default location. You have `CONTROLFILE AUTOBACKUP` configured and available in your Flash Recovery Area. What is the correct sequence of steps to restore the SPFILE and restart the database?

The default SPFILE location ($ORACLE_HOME/dbs/spfile<SID>.ora) is empty. Your init.ora file is also missing or doesn't contain a pointer to the SPFILE.

STARTUP NOMOUNT; RESTORE SPFILE FROM AUTOBACKUP; STARTUP FORCE;

STARTUP FORCE; RESTORE SPFILE FROM AUTOBACKUP; ALTER DATABASE OPEN;

SQL> CREATE PFILE FROM SPFILE; STARTUP; RESTORE SPFILE FROM AUTOBACKUP;

STARTUP; RESTORE SPFILE;