恢复归档日志:select * from v$log_history t where t.thread#='1'
order by t.first_time desc
实例1:恢复一个归档日志:
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;}
恢复多个归档日志:
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;}
实例2:恢复一个归档日志: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;}
恢复多个归档日志:
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;}
,
