Restore archived logs: select * fromv $ log_historytwheret.THREAD #
Restore archived logs: select * from v $ log_history t where t. THREAD # =
Restore archived logs: select * from v $ log_history t where t. THREAD # = '1'
Order by t. FIRST_TIME desc
Instance 1: Restore an archived log:
Run {
Allocate channel 'dev _ 0' type 'sbt _ tape'
Parms 'sbt _ LIBRARY =/opt/omni/lib/libob2Oracle8_64bit.so,
ENV = (OB2BARTYPE = Oracle8, OB2APPNAME = test, OB2BARLIST = db01 )';
Restore archivelog sequence 2102;
Release channel dev1 ;}
Restore multiple archived logs:
Run {
Allocate channel 'dev _ 0' type 'sbt _ tape'
Parms 'sbt _ LIBRARY =/opt/omni/lib/libob2oracle8_64bit.so,
ENV = (OB2BARTYPE = Oracle8, OB2APPNAME = test, OB2BARLIST = db01 )';
Restore archivelog sequence between 2104 and 2135;
Release channel dev1 ;}
Instance 2: Restore an archived log: select * from v $ log_history t where t. THREAD # = '2'
Order by t. FIRST_TIME desc
Run {
Allocate channel 'dev _ 0' type 'sbt _ tape'
Parms 'sbt _ LIBRARY =/opt/omni/lib/libob2oracle8_64bit.so,
ENV = (OB2BARTYPE = Oracle8, OB2APPNAME = test, OB2BARLIST = db01 )';
Restore archivelog sequence 2230 thread 2;
Release channel dev1 ;}
Restore multiple archived logs:
Run {
Allocate channel 'dev _ 0' type 'sbt _ tape'
Parms 'sbt _ LIBRARY =/opt/omni/lib/libob2oracle8_64bit.so,
ENV = (OB2BARTYPE = Oracle8, OB2APPNAME = test, OB2BARLIST = db01 )';
Restore archivelog sequence between 2231 and 2281 thread 2;
Release channel dev1 ;}
,