RMAN Example: Restoring Oracle Full Databases

You can restore an entire database when the database is corrupted or lost.

Before You Begin

• If you run the RMAN script on a UNIX environment, relink the SBT library or use PARMS in the Allocate Channel Command.

• Verify that the control file is intact, or perform a control file restore.

• Put the database in MOUNT mode.

• Optional: To have the CommCell Console authenticate the job, configure the parameters for CommCell Console third-party job authentication.

• Optional: When the backup pieces are unknown to the RMAN repository, catalog the backup pieces. For more information, see Cataloging RMAN Backup Pieces.

Procedure

• 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 { 
  allocate channel ch1 type 'sbt_tape'; 
  allocate channel ch2 type 'sbt_tape'; 
  restore database;
  recover database;
  sql "alter database open";
  }