Sunday, April 10, 2011

Problem:Restoring the Server Parameter File (SPFILE) from Backup

Impact:When an Oracle Instance is started, the characteristics of the Instance are established by parameters specified within the initialization parameter file.so if spfile is missing instance cannot be started.
Solution:
If you have configured control file autobackups, the SPFILE is backed up with the control file whenever an autobackup is taken.
If you want to restore the SPFILE from the autobackup, you must first set the DBID for your database, and then use the RESTORE SPFILE FROM AUTOBACKUP command. The procedure is similar to restoring the control file from autobackup. You must first set the DBID for your database, and then use the RESTORE CONTROLFILE FROM AUTOBACKUP command:
RMAN> SET DBID 320066378;
RMAN> RUN {
    SET CONTROLFILE AUTOBACKUP FORMAT 
          FOR DEVICE TYPE DISK TO 'autobackup_format';
    RESTORE SPFILE FROM AUTOBACKUP;
    }

No comments:

Post a Comment