Filter
Top Products
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