Integrating Oracle and Data Protector

Restoring an Oracle Database

Restoring Oracle Using CLIRestoring the Recovery Catalog

Data Protector can restore the binary file which contains the logical backups of the Oracle recovery catalog. This file is made using the Oracle Export utility, which creates it by reading the Oracle database and writing the output to the binary file, which is then backed up by Data Protector.

This file can be restored back to the disk and then imported to the Oracle database by the Oracle Import utility.

To restore the Oracle recovery catalog, proceed as follows:

1.Login to the Oracle Recovery Catalog Database. Ensure that the recovery catalog database exists and that the recovery catalog is not present. If necessary, remove the recovery catalog using the RMAN command DROP CATALOG.

Identify the Oracle recovery catalog owner. If necessary, create the Oracle user.

On UNIX, Data Protector determines the Oracle login information for the recovery catalog from the Data Protector Oracle configuration files.

2.Set the OB2APPNAME environment variable. Its value must be set to the name of the target database (DB_NAME), not of the Oracle recovery catalog:

Windows: set OB2APPNAME=<DB_NAME>

UNIX:

•if you are using an sh - like shell, run:

OB2APPNAME="<DB_NAME>" export OB2APPNAME

•if you are using a csh - like shell, run: setenv OB2APPNAME "<DB_NAME>"

OpenVMS: $DEFINE/log/process ob2appname <DB_NAME>

Chapter 1

107