To Next Page

To Previous Page

2. Start the point-in-time restore:

For a non-ZDB or ZDB backup set session:

run{

allocate channel 'dev1' type 'sbt_tape' parms

'SBT_LIBRARY=/opt/omni/lib/libob2oracle8.so,

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';

}

For a ZDB proxy-copy session, allocate one channel for restoring proxy-copy

sessions and one channel for database recovery. Release the proxy-copy channel

before the recovery:

run{

allocate channel 'dev1' type 'sbt_tape' parms

'SBT_LIBRARY=/opt/omni/lib/libob2oracle8.so,

ENV=(OB2BARTYPE=Oracle8,OB2PROXYCOPY=1, OB2APPNAME=DB_NAME)';

allocate channel 'dev2' type 'sbt_tape' parms

'SBT_LIBRARY=/opt/omni/lib/libob2oracle8.so,

ENV=(OB2BARTYPE=Oracle8, OB2APPNAME=DB_NAME)';

set until time 'Mar 14 2006 11:40:00';

restore database;

release channel 'dev1';

recover database;

sql 'alter database open';

release channel 'dev2';

}

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.

Data Protector Oracle ZDB integration128

HP Data Protector A.06.11 Integration Guide

Other manuals for HP Data Protector A.06.11