HP OpenView Storage B6960-96008 manual Start the point-in-time restore run

Integrating Oracle and Data Protector

Restoring an Oracle Database

•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, 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 point-in-time restore: run{

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

set until time 'Mar 14 2004 11:40:00'; restore database;

recover database;

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

}

3.After you have performed a point-in-time restore, reset the database in the Recovery Catalog.

You can also save the script into a file and perform a point-in-time restore using the saved files:

1.Create a file restore_PIT in the /var/opt/omni/tmp or

<Data_Protector_home>\tmp directory.

2.Start the point-in-time restore:

If you use the recovery catalog database, run:

Oracle 9i/10g:

Chapter 1 99