在知识库中专注阅读，并随时返回相关工具与课程
有一套 Oracle 11GR2 DataGuard 单机环境，巡检发现 alert 日志报错如下： bash Wed Aug 27 09:53:02 2025 Errors in file /u01/app/oracle/diag/rdbms/orcldg/orcldg/trace/orcldgarc23637.trc: ORA-00314: log 5 of thread 1, expecte
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
有一套 Oracle 11GR2 DataGuard 单机环境，巡检发现 alert 日志报错如下：
1Wed Aug 27 09:53:02 20252Errors in file /u01/app/oracle/diag/rdbms/orcldg/orcldg/trace/orcldg_arc2_3637.trc:3ORA-00314: log 5 of thread 1, expected sequence# 119864 doesn't match 1198624ORA-00312: online log 5 thread 1: '/u01/app/oracle/oradata/redostd05.log'查看错误定义：
1[oracle@lucifer:/home/oracle]$ oerr ora 314200314, 00000, "log %s of thread %s, expected sequence# %s doesn't match %s"3// *Cause: The online log is corrupted or is an old version.4// *Action: Find and install correct version of log or reset logs.看报错是说在线日志损坏或者版本过旧，需要 reset 日志。
检查备库当前在线重做日志：
1SQL> set line2222 pages10002SQL> select * from v$standby_log;34 GROUP# DBID THREAD# SEQUENCE# BYTES BLOCKSIZE USED ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME LAST_CHANGE# LAST_TIME5---------- ---------------------------------------- ---------- ---------- ---------- ---------- ---------- --- ---------- ------------- --------- ------------ --------- ------------ ---------6 5 UNASSIGNED 1 0 209715200 512 0 NO UNASSIGNED7 6 1584260213 1 120011 209715200 512 17433088 YES ACTIVE 7.7784E+10 01-SEP-25 7.7784E+10 01-SEP-258 7 1584260213 2 119841 209715200 512 144156672 YES ACTIVE 7.7784E+10 01-SEP-25 7.7784E+10 01-SEP-259 8 UNASSIGNED 2 0 209715200 512 0 NO UNASSIGNED10 9 UNASSIGNED 1 0 209715200 512 0 NO UNASSIGNED11 10 UNASSIGNED 2 0 209715200 512 0 NO UNASSIGNED1213SQL> col member for a10014SQL> select group#,member from v$logfile;1516 GROUP# MEMBER17---------- ----------------------------------------------------------------------------------------------------18 1 /u01/app/oracle/oradata/redo01.log19 2 /u01/app/oracle/oradata/redo02.log20 3 /u01/app/oracle/oradata/redo03.log21 4 /u01/app/oracle/oradata/redo04.log22 5 /u01/app/oracle/oradata/redostd05.log23 6 /u01/app/oracle/oradata/redostd06.log24 7 /u01/app/oracle/oradata/redostd07.log25 8 /u01/app/oracle/oradata/redostd08.log26 9 /u01/app/oracle/oradata/redostd09.log27 10 /u01/app/oracle/oradata/redostd10.log可以看到 alert 中报错的日志文件对应的是 5 号日志。
执行 clear 日志：
1SQL> Alter database recover managed standby database cancel;23Database altered.45SQL> alter database clear logfile group 5;67Database altered.89SQL> recover managed standby database using current logfile disconnect;10Media recovery complete.1112-- 检查在线日志使用情况13SQL> set line2222 pages100014SQL> select * from v$standby_log;15 GROUP# DBID THREAD# SEQUENCE# BYTES BLOCKSIZE USED ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME LAST_CHANGE# LAST_TIME16---------- ---------------------------------------- ---------- ---------- ---------- ---------- ---------- --- ---------- ------------- --------- ------------ --------- ------------ ---------17 5 1584260213 1 120012 209715200 512 64310272 YES ACTIVE 7.7786E+10 01-SEP-25 7.7786E+10 01-SEP-2518 6 UNASSIGNED 1 0 209715200 512 0 NO UNASSIGNED19 7 1584260213 2 119843 209715200 512 103357952 YES ACTIVE 7.7786E+10 01-SEP-25 7.7786E+10 01-SEP-2520 8 UNASSIGNED 2 0 209715200 512 0 NO UNASSIGNED21 9 UNASSIGNED 1 0 209715200 512 0 NO UNASSIGNED22 10 UNASSIGNED 2 0 209715200 512 0 NO UNASSIGNED目前 alert 没有再报错，后续持续观察，确定问题是否完全解决！
参考 MOS 文章：ORA-00314: LOG 404 OF THREAD 4, EXPECTED SEQUENCE# 33808 DOESN'T MATCH 33543 (Doc ID 1077564.1)