OCP 1Z0 053 190

190.You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive 
the following error message: 
SQL> startup ORA-01078: failure in processing system parameters LRM-00109: 
could not open parameter file ,, 
C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORA Using RMAN, 
how would you respond to this error? 
A. Issue the startup nomount command and then issue the restore parameter file command from the 
RMAN prompt. 
B. Issue the startup nomount command and then issue the restore spfile command from the RMAN 
prompt. 
C. Issue the startup nomount command and then issue the restore spfile from autobackup command from 
the RMAN prompt. 
D. Issue the startup nomount command and then issue the restore spfile from backup command from the 
RMAN prompt. 
E. Issue the restore spfile from autobackup command from the RMAN prompt. 
Answer: C 

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#BRADV89829

Restoring the Server Parameter File from a Control File Autobackup

If you have configured control file autobackups, then the server parameter file is backed up with the control file whenever an autobackup is taken.

To restore the server parameter file from the control file autobackup, you must first set the DBID for your database and then use the RESTORE SPFILE FROM AUTOBACKUP command. If the autobackup is in a nondefault format, then first use the SET CONTROLFILE AUTOBACKUP FORMAT command to specify the format.

Example 20-1 sets the DBID and restores the server parameter file from a control file autobackup in a nondefault location.

Example 20-1 Restoring the Server Parameter File from a Control File Autobackup

SET DBID 320066378;RUN {  SET CONTROLFILE AUTOBACKUP FORMAT     FOR DEVICE TYPE DISK TO 'autobackup_format';  RESTORE SPFILE FROM AUTOBACKUP;}