Integrating Oracle and Data Protector

Restoring an Oracle Database

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

OpenVMSORACLE_HOME=DKA400:[ORACLE9I]

Example

ORACLE_TERM=hp

DB_NAME=PROD

•Check that the /etc/oratab file has the following line: Windows: PROD:<Oracle_home>\product\10.1.0:N

UNIX: PROD:/opt/oracle/product/10.1.0:N

OpenVMS:

—Oracle 9i:

<oracle_home>/oratab

TEST:/DKA400/ORACLE9I:N

CAT:/DKA400/ORACLE9I:N

—Oracle 8i:

<oracle_home>/rdbms/ORA_RDBMS_SIDS.DAT

VMS1 TEST TEST

VMS1 CAT CAT

The last letter determines whether the database will automatically start upon bootup (Y) or not (N).

Connection Strings Used in the Examples

In the examples below, the following connection strings are used:

•Target connection string for target database: sys/manager@PROD

where sys is the username, manager is the password and PROD is a net service name.

•Recovery catalog connection string for recovery catalog database: rman/rman@CATAL

where rman is the username and password and CATAL is a net service name.

96

Chapter 1