RMAN Restore SPFILE

Not using recovery catalog.

RMAN autobackup not in default location.

You will need to know your DBID before you can proceed.

You can determine the DBID for your database in one of the following ways:

Derive from autobackup

Retrieve from RMAN output

Write to alert log file

COL dbid NEW_VALUE hold_dbid 

                  SELECT dbid FROM v$database 

                  exec dbms_system.ksdwrt(2,'DBID: '|| TO_CHAR(&hold_dbid));

Derive from file dump


             SQL> connect / as sysdba; 

             SQL> startup mount;  

             SQL> alter system dump datafile '/"path:/system01.dbf' block min 1 block max 10;

Use this syntax to take a dump of an archived redo log file or online redo log file:


             SQL> alter system dump logfile '"log file name"' ;

The trace file with your DBID will be in your dump destination.


         RMAN> connect target / 

         RMAN> shutdown immediate; 

         RMAN> set dbid 9999; 

         RMAN> startup force nomout; 

         RMAN> restore spfile from '/rman/"dbaname"/"controlfile_name"';

HOME