HP OpenView Storage B6960-96008 manual Restoring Oracle Using the Data Protector GUI

Integrating Oracle and Data Protector

Restoring an Oracle Database

allocate channel dev1 type 'sbt_tape' parms'ENV=(OB2BARHOSTNAME=virtual.domain.com)';

restore datafile '/opt/ora9i/oradata/MAKI/example02.dbf';

release channel dev1;

}

Prerequisites

•An instance of Oracle must be created on the system to which you want to restore or duplicate the database.

•The database must be in Mount state if the whole database is being restored, or in NoMount state if the control file is being restored or a database duplication is performed.

Restoring Oracle Using the Data Protector GUI

For restore, RMAN scripts are generated with necessary commands, depending on selections made in the GUI. If you want to perform additional actions, you cannot edit the RMAN restore script, but you can perform them manually from RMAN itself.

Restoring Database Items in a Disaster Recovery

In a disaster recovery situation, database objects must be restored in a certain order. The following list shows you in which order database items must be restored. Under normal conditions it is possible to restore database items in any order.

If the recovery catalog was used:

1.Restore the recovery catalog database (if it was lost)

2.Restore the control file

3.Restore the entire database or data items

If the recovery catalog was not used:

•Oracle 8i:

See problem “The Recovery Catalog was lost and the control file cannot be restored from Data Protector managed backup” on page 139.

72 Chapter 1