HP P6000 Replication Solutions Manager Administrator Guide (T3680-96069, June 2012)

E2: DeleteStorageVolumes ( $Rep1 ) onerror pauseat E2:
Exit ( SUCCESS )
E1: Exit ( FAILURE )
Testing the process
If used correctly, the replication manager can greatly improve the efficiency of your Oracle backup,
restore, and migration operations. As with any change to your database configuration or backup
plan, it is important that you understand all aspects of your backup and restore operations and
test them thoroughly before implementing them in a production environment.
Restoring an Oracle tablespace that was backed up using the replication
manager
NOTE: This section describes a possible sequence of steps to restore an Oracle database from
an online backup, not a step-by-step recovery plan. There are many variables to consider when
determining how a database should be recovered. The Oracle administrator must ensure the
suitability of the method being used before applying them.
Restoring a database that has been backed up using the replication manager methods typically
involves the following basic steps:
1. Identifying and preparing resources
2. Preparing the database for recovery
3. Replacing the required files
4. Recovering the database and applying redo logs
Identifying and preparing resources
Before recovery can begin, you must consider:
• Is the data a replica or is it on tape?
• If the data is on tape, what is the name of the backup application’s restore job that must be
run?
• Have the appropriate steps been taken to ensure that the restored data will be written to the
correct location?
• Are the necessary tapes on hand and loaded?
• If the data to be restored is a replica, where is the replica currently located?
• Will a reboot be required to make the replica visible to the database server?
Preparing the database for recovery
Shut down the database in NORMAL, IMMEDIATE, or ABORT mode.
NOTE: On Windows systems, you cannot use ABORT alone because it does not clear the
operating system file locks, and you cannot overwrite the datafiles with your backup copies. If you
must use ABORT, shut down and restart the operating system, or use a file system utility to clear
the file locks.
Replacing the required files
You can replace the required files using one of several methods. The method you choose depends
on the situation and the types of backups available. Choosing the wrong method can prevent
archived redo logs from being applied for recovery, and could prevent you from restoring to the
latest log backup.
There are two basic recovery methods that can be used with point-in-time backups: volume
replacement and selective file replacement.
72 Using the replication manager with Oracle tools