Integrating Oracle and Data Protector

Restoring an Oracle Database

Example of Full Database Restore and Recovery

To perform a full database restore and recovery, you also need to restore and apply all the archive logs. To perform a full database restore and recovery:

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:

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

•On UNIX: <ORACLE_HOME>/bin/rman target sys/manager@PROD nocatalog

•On OpenVMS: rman target sys/manager@PROD nocatalog

2.Start the full database restore and recovery: run{

allocate channel 'dev1' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';

restore database; recover database;

sql 'alter database open'; release channel 'dev1';

}

Chapter 1

97