Integrating Oracle and Data Protector

Restoring an Oracle Database

•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

106

Chapter 1