Backup3G/DA-RMAN/User Guide/Searching and Restoring Oracle RMAN Backups

From Documentation

Revision as of 06:41, 5 March 2007

Backup3G’s Recovery module lists all the current backups in the media database, including Oracle/RMAN backups.

Searching Oracle/RMAN Backups

You use the backup3G Recovery module to search for Oracle/RMAN backups. You can open a media set to view its contents. However, you must restore the data using Oracle RMAN on the Oracle host.

To launch the Oracle Recovery Manager

1. From the command line, login as the Oracle user.
2. Run RMAN with the appropriate connect strings:

   rman target /

   rman target <user>/<password>

   rman target <user>/<password>@<service>

   rman target <user>/<password>@<service> catalog <user>/<password>@<service>

Selecting Oracle Backups to Restore

Caution

Don’t restore backups to an online database. Only restore backups to a mounted database otherwise you will get an error and the restore will fail.

Specifying the Tape Drive
To specify the tape drive or pool to use for the recovery, you must allocate an RMAN channel, and set the DRIVE environment variable as follows:

allocate channel 'backup3G' device type sbt parms="ENV=(DRIVE=XXXX)";

where XXXX is the name of the drive or drive-pool to use. Note that drive-pool names always end in "@".

You should always ensure that the tape(s) you want to restore from are in the correct position for the tape drive. For example if the tape drive is in a stacker or tape library, then the tapes should also be in the library. You may have to "move" the tape(s) to the correct location using the backup3G media window.

To Restore from an Oracle Backup
Once an sbt channel is allocated, specifying the DRIVE, you can perform the recovery using the normal RMAN RESTORE and RECOVER commands. Please refer to the RMAN manual on how to use these commands.

Copyright © 2007 Functional Software. All rights reserved.