Filter
Top Products
Integrating Oracle and Data Protector
Restoring an Oracle Database
Chapter 1106
• On UNIX: <ORACLE_HOME>/bin/rman target sys/manager@PROD
nocatalog
•On OpenVMS: rman target sys/manager@PROD nocatalog
2. Start the archive log restore:
run{
allocate channel dev1 type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
restore archivelog all;
release channel dev1;
}
You can also save the script into a file and perform an archive log restore
using the saved files:
1. Create a file restore_arch in the /var/opt/omni/tmp (UNIX
systems) or <Data_Protector_home>\tmp (Windows systems)
directory.
2. Start the archive log 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_arch
• On UNIX: <ORACLE_HOME>/bin/rman target sys/manager@PROD
catalog rman/rman@CATAL
cmdfile=/var/opt/omni/tmp/restore_arch
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_arch
• On UNIX: <ORACLE_HOME>/bin/rman target sys/manager@PROD
nocatalog cmdfile=/var/opt/omni/tmp/restore_arch