Rumah  >  Artikel  >  pangkalan data  >  Oracle集群数据库中恢复归档日志

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

WBOY
WBOYasal
2016-06-07 17:07:351110semak imbas

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

linux

Kenyataan:
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn