Backup3G/DA-RMAN/User Guide/Searching and Restoring Oracle RMAN Backups
From Documentation
(Difference between revisions)
| Revision as of 07:43, 23 February 2007 Moff (Talk | contribs) (→Searching Oracle/RMAN Backups) ← Previous diff |
Revision as of 07:52, 23 February 2007 Moff (Talk | contribs) (→Selecting Oracle Backups to Restore) Next diff → |
||
| Line 21: | Line 21: | ||
| ---- | ---- | ||
| - | ;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 === | + | ==== Target 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 | + | |
| - | files to the /tmp directory on any host, and to any directory on host ‘playpen’. | + | |
| - | 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 Oracle Backup ==== |
| - | #From the Recovery module, select the media set containing the backup to be restored. | + | |
| - | #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. | + | |
| - | #Select the files to restore: | + | |
| - | #: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. | + | |
Revision as of 07:52, 23 February 2007
Backup3G’s Recovery module lists all the current backups in the media database, including Oracle/RMAN backups.
Contents |
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>
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.
Target Drive
To Restore from an Oracle Backup
Copyright © 2007 Functional Software. All rights reserved.
| Previous Section | Next Section |