RMAN Example: Restoring an Oracle Full Database for Disaster Recovery

You can restore an Oracle database to the same or a different client in the event of a disaster.

Procedure

1. Put the database in MOUNT mode.

2. You cannot start the database from sqlplus because the pfile and the spfile files were deleted. Connect to RMAN and type the following commands, which start the Oracle instance with a dummy parameter file.

    
   RMAN> connect target $[sys]/$[sys]@$[dbname]
   RMAN> startup force nomount;

3. On the RMAN command line, run the following sample script, substituting any required or optional Oracle SBT parameters.

   For information on required and optional SBT parameters, see SBT Parameters.

   run { 
   SET DBID $[208759155];
   allocate channel $[ch1] type 'sbt_tape' PARMS="SBT_LIBRARY=$[/opt/commvault/Base/libobk.so],ENV=(CvInstanceName=$[Instance001])";
   allocate channel $[ch2] type 'sbt_tape' PARMS="SBT_LIBRARY=$[/opt/commvault/Base/libobk.so],ENV=(CvInstanceName=$[Instance001])";
   allocate channel $[ch3] type 'sbt_tape' PARMS="SBT_LIBRARY=$[/opt/commvault/Base/libobk.so],ENV=(CvInstanceName=$[Instance001])";
   allocate channel $[ch4] type 'sbt_tape' PARMS="SBT_LIBRARY=$[/opt/commvault/Base/libobk.so],ENV=(CvInstanceName=$[Instance001])";
   restore $[spfile]  from $[autobackup] ;
   startup force nomount;
   restore $[controlfile]  from $[autobackup] ;
   sql '$[alter database mount]';
   restore database ;
   recover database until time = "TO_DATE('$[JAN 07 2021 20:50:13]', '$[MON DD YYYY HH24:MI:SS]')";
   alter database open resetlogs;
   }