HP OpenView Storage Data Protector B6960-96008 Manuel D’Utilisation
Integrating Oracle and Data Protector
Restoring an Oracle Database
Chapter 1
105
• 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