HP OpenView Storage B6960-96008 manual Example of Tablespace Restore and Recovery, 100

Integrating Oracle and Data Protector

Restoring an Oracle Database

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

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

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_PIT

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

Example of Tablespace Restore and Recovery

If a table is missing or corrupted, you need to perform a restore and recovery of the entire tablespace. To restore a tablespace, you may take only a part of the database offline, so that the database does not have to be in the mount mode. You can use either a recovery catalog database or control files to perform a tablespace restore and recovery. Follow the steps below:

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:

Use rcvcat instead of catalog in the above syntax.

If you do not use the recovery catalog, run:

100 Chapter 1