Restore SP file from Auto backup ( oracle )

[mahmoud_rady]

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

[Yasuhisa_Ishika]

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.

[gr1ff]

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