Integrating Oracle and Data Protector

Restoring an Oracle Database

Set the other restore options. See “Restore, Recovery, and Duplicate

Options” on page 88 for information.

6.Click Restore.

Proceed with restoring the Oracle database objects.

Restoring Oracle Database Objects

Before you restore Oracle database objects, ensure that you have an up-to-date version of the recovery catalog database and the control file. They contain the database structure information. If you do not have up-to-date versions of these files, restore them as described in“Restoring the Recovery Catalog Database” on page 74 and “Restoring the Control File” on page 76.

To restore Oracle database objects:

1.Oracle Data Guard: If you restore a standby database, stop the managed recovery process (log apply services):

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

2.Put the database in the mount state. See “Changing The Database State” on page 73.

3.In the Data Protector GUI, switch to the Restore context.

4.Under Restore Objects, expand Oracle Server, expand the client on which the database, for which you restore the database objects, resides, and then click the database.

5.In the Restore action drop-down list, select the type of restore you wish to perform. For information on the options, see “Restore, Recovery, and Duplicate Options” on page 88.

IMPORTANTIf you do not select Perform Restore and Recovery or Perform Recovery Only, you will have to recover the database objects manually using RMAN. For information, see “Restoring Oracle Using RMAN” on page 93.

78

Chapter 1