Recovering SPFILE

6.8 Recovering SPFILE
6.8.1 Recovering SPFILE using FRA – AUTOBACKUP ON
Create a simple init.ora pointing to the FRA
*.db_name=’DB1DUP’#Reset to original value by RMAN
*.db_recovery_file_dest=’+FRA’
*.db_recovery_file_dest_size=17179869184
SQL> startup nomount pfile=’?/dbs/initDB1DUP_tmp.ora’
RMAN> restore spfile from autobackup;
RMAN> startup force

6.8.2 Recovering SPFILE not using FRA – AUTOBACKUP ON
Create a simple init.ora
*.db_name=’DB2DUP’#Reset to original value by RMAN
SQL> startup force nomount  pfile=’?/dbs/initDB2DUP_tmp.ora’
%  rman target=sys/sys@DB2DUP
RMAN> set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/zpool_tmp/DB_BACKUP/autobackup_%F’;
RMAN> set dbid 3523769914
RMAN> restore spfile from autobackup;
RMAN> startup force

6.8.3 Lessons learned in this session

  • Always use AUTOBACKUP ON option and AUTOBACKUP FORMAT option %F as this
    will make recovery for SPFILE quite simple

 

One thought on “Recovering SPFILE”

Leave a Reply

Your email address will not be published. Required fields are marked *