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

最新推荐文章于 2024-04-18 14:24:07 发布

转载最新推荐文章于 2024-04-18 14:24:07 发布 · 195 阅读

文章标签：

本文详细介绍了如何使用Oracle的归档日志恢复功能，包括恢复单个和多个归档日志的具体步骤和语法。实例展示了从日志历史中筛选特定线程的日志，并通过命令行进行恢复操作。

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