HP A.06.11 User Manual

Page 119

Advertising
background image

Prerequisites

The following requirements must be met before you start a restore of an Oracle
database:

If you use the recovery catalog database, make sure that the recovery catalog
database is open. If the recovery catalog database cannot be brought online,
you will probably need to restore the recovery catalog database. See

Restore

” on page 94 for details on how to restore the recovery catalog 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

Integration guide for Oracle and SAP

119

Advertising