HP OpenView Storage B6960-96008 manual

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