Integrating Oracle and Data Protector

Restoring an Oracle Database

2.Start the tablespace restore.

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 cmdfile=<Data_Protector_home>\tmp\restore_TAB

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

Oracle 8i:

Use rcvcat instead of catalog in the above syntax.

If you do not use the recovery catalog, run:

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

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

Example of Datafile Restore and Recovery

To restore and recover a datafile, you may take only a part of the database offline.

To restore and recover a datafile:

1.Log in 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:

102

Chapter 1