HP A.06.11 - Manual (Page 123)

1. Log in to the Oracle RMAN:
If you use the recovery catalog database, run:
• 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
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
'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';
}
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.
Integration guide for Oracle and SAP 123