HP Data Protector A.06.11 - Resetting current SLA status; Viewing alerts

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