Backup3G/DA-RMAN/User Guide/Searching and Restoring Oracle RMAN Backups
This page was last modified 07:15, 20 January 2012.From Documentation
| Revision as of 07:25, 23 February 2007 Moff (Talk | contribs) ← Previous diff |
Current revision Mike (Talk | contribs) (→Searching Oracle/RMAN Backups) |
||
| Line 3: | Line 3: | ||
| == Searching Oracle/RMAN Backups == | == Searching Oracle/RMAN Backups == | ||
| - | You use the backup3G Recovery module to search for and restore from Oracle backups. You can open a media set to view its contents and restore all or selected files. | + | 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 Recovery module''' | + | '''To launch the Oracle Recovery Manager''' |
| - | ''From the backup3G button bar (GUI)'' | + | #From the command line, login as the Oracle user. |
| - | *Select the Recover button. | + | #Run RMAN with the appropriate connect strings: |
| - | ''From the backup3G main menu (CUI)'' | + | #:<tt>rman target /</tt> |
| - | *Select Recovery from backups from the backup3G main menu. | + | #:<tt>rman target <user>/<password></tt> |
| + | #:<tt>rman target <user>/<password>@<service></tt> | ||
| + | #:<tt>rman target <user>/<password>@<service> catalog <user>/<password>@<service></tt> | ||
| <br> | <br> | ||
| + | <p>Once you are in RMAN, you can list the "backupsets" that RMAN knows about using the '''LIST''' command. An RMAN backupset | ||
| + | is stored as a single tape-file by backup3G. The name of the backup-piece in RMAN contains the backup3G '''Set_ID''' of the | ||
| + | media set used for the original backup. For example, the backup-piece '''12345/SYSTEM_2_1_772805994''' is a backup (or part of a backup) of the SYSTEM tablespace on media set 12345. Note that if you duplicate the media set in backup3G, you can restore from either the original or the copy. Backup3G will choose which ever copy is most appropriate to use, based on its location and media type.</p> | ||
| == Selecting Oracle Backups to Restore == | == Selecting Oracle Backups to Restore == | ||
| Line 19: | Line 24: | ||
| ---- | ---- | ||
| - | ;Caution: Don’t restore files to an online database. Only restore files to an offline database to ensure that database integrity will be maintained. | + | ;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. |
| ---- | ---- | ||
| + | |||
| <br> | <br> | ||
| - | === Target Host and Directory === | + | ''' Specifying the Tape Drive ''' |
| - | Some backup3G users have restrictions on which hosts and directories they can restore to (see Restricting Recovery Destinations by Role in the [[backup3G]] User Guide for more details). For example users with the Operator role may be restricted to restoring | + | <br> |
| - | files to the /tmp directory on any host, and to any directory on host ‘playpen’. | + | <p>To specify that the backup3G tape drive or pool to use for the recovery, you must allocate an RMAN channel, and set the '''DRIVE''' environment variable as follows:</p> |
| + | <br> | ||
| + | allocate channel 'backup3G' device type sbt parms="ENV=(DRIVE=XXXX)"; | ||
| + | <br> | ||
| + | where XXXX is the name of the drive or drive-pool to use. Note that drive-pool names always end in "@". | ||
| + | <p> You should always ensure that the tape(s) from which you want to restore are in the correct location for the tape drive. For example if the tape drive is in a tape library, then the tapes must also be in the library so that they can be loaded automatically. You may have to "move" the tape(s) to the correct location using the backup3G '''media''' window.</p> | ||
| - | If you have any such restrictions, backup3G will ask to choose a target host and directory from the list of permitted destinations. If you have no restrictions you can choose any host and directory in the ‘Recovery Details’ prompt form. | ||
| + | ---- | ||
| <br> | <br> | ||
| - | === To Restore from an Oracle Backup === | + | ''' To Restore from an RMAN Backup ''' |
| - | #From the Recovery module, select the media set containing the backup to be restored. | + | <br> |
| - | #Select Contents > Open to list the contents of the media set. Each file in the media set corresponds to an item in the backup job. | + | <p>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.</p> |
| - | #Select the files to restore: | + | <p>Each RMAN restore will create one or more backup3G recovery jobs. These jobs will be visible in the backup3G '''monitor''' window. They can also be controlled (cancelled, tape(s) loaded etc) from backup3G in the usual way, and each job also creates a logfile under backup3G. We recommend that you have a '''monitor''' window running while doing a restore via RMAN. If the tape is loaded manually, you will be requested to so from the '''monitor''' window.</p> |
| - | #:To select a file - click on it. | + | |
| - | #:To select several files - click and drag from the first file down to the last. | + | |
| - | #:To add a file to the selection - Control-click on it. | + | |
| - | #:To extend the selection - Shift-click on another file. | + | |
| - | #:To select all files - press Control-Shift-Button1 | + | |
| - | #Select Recover > Background. | + | |
| - | #If you have any recovery restrictions, backup3G will list which directories and hosts you can restore to. Choose a destination.<br>If you have no restrictions, this step is skipped. | + | |
| - | #Fill in these fields in the ‘Recovery Details’ prompt form. | + | |
| - | #;Recover to host: Select the name of the host to which the files should be restored. The default is the original host. | + | |
| - | #;Into directory: Specify where the restored files should go. The target directory will be created if it doesn’t already exist. | + | |
| - | #;:When you restore the backup files, any existing files of the same name in the target directory will be overwritten. Therefore, it is best to restore to a temporary directory first. | + | |
| - | #;Drive/Pool:Press Choose to see the list of valid drives and drive pools. | + | |
| - | #;:Choose a drive and press Accept. | + | |
| - | #;Auto unload: Select ‘yes’ to unload the backup tape from the drive after the recovery has finished. | + | |
| + | <br> | ||
| ---- | ---- | ||
| Line 55: | Line 53: | ||
| {| cellpadding="10" cellspacing="5" | {| cellpadding="10" cellspacing="5" | ||
| |- | |- | ||
| - | |[[Defining Oracle/RMAN Backups|Previous Section]] | + | |[[Defining Oracle RMAN Backups|Previous Section]] |
| | | | | ||
| |[[DA-RMAN Command Reference|Next Section]] | |[[DA-RMAN Command Reference|Next Section]] | ||
| |} | |} | ||
Current revision
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
- From the command line, login as the Oracle user.
- 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>
Once you are in RMAN, you can list the "backupsets" that RMAN knows about using the LIST command. An RMAN backupset is stored as a single tape-file by backup3G. The name of the backup-piece in RMAN contains the backup3G Set_ID of the media set used for the original backup. For example, the backup-piece 12345/SYSTEM_2_1_772805994 is a backup (or part of a backup) of the SYSTEM tablespace on media set 12345. Note that if you duplicate the media set in backup3G, you can restore from either the original or the copy. Backup3G will choose which ever copy is most appropriate to use, based on its location and media type.
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 that the backup3G 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) from which you want to restore are in the correct location for the tape drive. For example if the tape drive is in a tape library, then the tapes must also be in the library so that they can be loaded automatically. You may have to "move" the tape(s) to the correct location using the backup3G media window.
To Restore from an RMAN 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.
Each RMAN restore will create one or more backup3G recovery jobs. These jobs will be visible in the backup3G monitor window. They can also be controlled (cancelled, tape(s) loaded etc) from backup3G in the usual way, and each job also creates a logfile under backup3G. We recommend that you have a monitor window running while doing a restore via RMAN. If the tape is loaded manually, you will be requested to so from the monitor window.
Copyright © 2007 Functional Software. All rights reserved.
| Previous Section | Next Section |