oracle数据库集群日志,Oracle集群数据库中恢复归档日志

恢复归档日志：select * from v$log_history t where t.THREAD#=

恢复归档日志：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;}

，

本文原创发布php中文网，转载请注明出处，感谢您的尊重！