Integrating Oracle and Data Protector

Restoring an Oracle Database

•On Windows: <ORACLE_HOME>/bin/rman target sys/manager@PROD catalog rman/rman@CATAL cmdfile=/var/opt/omni/tmp/restore_dbf

•On UNIX: <ORACLE_HOME>\bin\rman target sys/manager@PROD catalog rman/rman@CATAL cmdfile=<Data_Protector_home>\tmp\restore_dbf

Oracle 8i:

Use rcvcat instead of catalog in the above syntax.

If you do not use the recovery catalog database, run:

•On Windows: <ORACLE_HOME>\bin\rman target sys/manager@PROD nocatalog cmdfile=<Data_Protector_home>\tmp\restore_dbf

•On UNIX: <ORACLE_HOME>/bin/rman target sys/manager@PROD nocatalog cmdfile=/var/opt/omni/tmp/restore_dbf

Example of Archive Log Restore

To restore an archive log:

1.Login to the Oracle RMAN:

If you use the recovery catalog database, run:

Oracle 9i/10g:

•On Windows: <ORACLE_HOME>\bin\rman target sys/manager@PROD catalog rman/rman@CATAL

•On UNIX: <ORACLE_HOME>/bin/rman target sys/manager@PROD catalog rman/rman@CATAL

•On OpenVMS: rman target sys/manager@PROD sys/manager@PROD catalog rman/rman@CAT

Oracle 8i:

Use rcvcat instead of catalog in the above syntax.

If you do not use the recovery catalog database, run:

•On Windows: <ORACLE_HOME>\bin\rman target sys/manager@PROD nocatalog

Chapter 1

105