Integrating Oracle and Data Protector

Restoring an Oracle Database

Control files must be available. If the control files are not available, you must restore them. See the Oracle Recovery Manager User’s Guide and References for more details.

If you have to perform a restore of the recovery catalog databaseor control files, you must perform this restore first. Only then can you perform a restore of other parts of the Oracle database.

When you are sure that the recovery catalog databaseor control files are in place, start the recovery catalog database.

Make sure that the following environment variables are set:

ORACLE_BASE

ORACLE_HOME

ORACLE_TERM

DB NAME

PATH

NLS_LANG

NLS_DATE_FORMAT

Windows Example

ORACLE_BASE=<Oracle_home>

 

ORACLE_HOME=<Oracle_home>\product\10.1.0

 

ORACLE_TERM=hp

 

DB_NAME=PROD

 

PATH=$PATH:<Oracle_home>\product\10.1.0\bin

 

NLS_LANG=american

 

NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'

UNIX Example

ORACLE_BASE=/opt/oracle

 

ORACLE_HOME=/opt/oracle/product/10.1.0

 

ORACLE_TERM=hp

 

DB_NAME=PROD

 

PATH=$PATH:/opt/oracle/product/10.1.0/bin

 

NLS_LANG=american

Chapter 1

95

Page 117
Image 117
HP OpenView Storage B6960-96008 manual Windows Example, Unix Example