Filter
Top Products
Integrating Oracle and Data Protector
Restoring an Oracle Database
Chapter 1102
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: