HP OpenView Storage Data Protector B6960-96008 User Manual
Integrating Oracle and Data Protector
Restoring an Oracle Database
Chapter 1
100
• 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:
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: