FS
Documentation

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

From Documentation

(Difference between revisions)
Jump to: navigation, search
Revision as of 07:25, 23 February 2007
Moff (Talk | contribs)

← Previous diff
Revision as of 07:43, 23 February 2007
Moff (Talk | contribs)
(Searching Oracle/RMAN Backups)
Next diff →
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>

Revision as of 07:43, 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

  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 files to an online database. Only restore files to an offline database to ensure that database integrity will be maintained.


Target Host and Directory

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.


To Restore from an Oracle Backup

  1. From the Recovery module, select the media set containing the backup to be restored.
  2. 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.
  3. 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
  4. Select Recover > Background.
  5. If you have any recovery restrictions, backup3G will list which directories and hosts you can restore to. Choose a destination.
    If you have no restrictions, this step is skipped.
  6. 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.



Copyright © 2007 Functional Software. All rights reserved.

Previous Section            Next Section