Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Restore SP file from Auto backup ( oracle )

Created: 07 Apr 2013 | 2 comments
mahmoud rady's picture

Hi all

   we need to know how to restore SP file in oracle over ( linux RH ) the master is over win 2008 and the client is standalone ORACLE server over linux

Thank You

Operating Systems:

Comments 2 CommentsJump to latest comment

Yasuhisa Ishikawa's picture

I usually determine backup handle(Oracle's term) which include SPFILE backup by logs or output of bplist. Then run as blow in RMAN prompt.

SET DBID=<DBID of target DB>
STARTUP FORCE NOMOUNT:
RUN {
ALLOCATE CHANNEL t1 TYPE sbt;
RESTORE CONTROLFILE FROM 'backup_handle_which_has_SPFILE_backup';
RELEASE CHANNEL t1;
}

If you have configured Oracle backup with template, last backup in backup session which backed up "/bk_..." includes SPFILE. Omit first slash and use "bk_..." as backup handle.

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

gr1ff's picture

Just curious what happens if you have a duplicate backup handle name for that database you are restoring?