风哥教程

培训 . 交流 . 分享
Make progress together!

Oracle DataGuard容灾出现FAL Message In Alert.log When No Gap In Standby

[复制链接]
内容发布:paulyi| 发布时间:2014-2-23 18:41:06
Oracle DataGuard容灾出现FAL Message In Alert.log When No Gap In Standby

Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3 - Release: 10.1 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 25-MAR-2011***
SymptomsWhen using ARCH transport, gaps could be flagged in the alert log even though the single log gap was for a log that had not been written at the primary yet.

alert.log on primary shows:

FAL[server]: Fail to queue the whole FAL gap
GAP - thread 1 sequence 63962-63962
DBID 1243807152 branch 631898097

or alert.log on standby shows:

v$archive_gap re
Fetching gap sequence in thread 1, gap sequence 63962-63962
Thu Jan 24 14:36:30 2008
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 63962-63962
DBID 2004523329 branch 594300676
FAL[client]: All defined FAL servers have been attempted.

turns no rows


SQL> select * from v$archive_gap;
no rows selected


CauseBug 5526409 - FAL gaps reported at standby for log not yet written at primary
SolutionThis is a known Bug 5526409 which is fixed in 10.2.0.4 and 11.1.

To solve the issue, please upgrade to the newest patchset since Bug 5526409 is fixed in 10.2.0.4.
Their is no impact of these messages on the database. You can safely ignore these messages.

Furthermore there are One-off Patch for Bug 5526409 on top of 10.2.0.3 available for some platforms. Please check Patches & Updates within My Oracle Support MOS.

ReferencesBUG:5526409 - FAL[CLIENT]: FAILED TO REQUEST GAP SEQUENCE BUT NO GAPS FOUND
PATCH:5526409 - FAL[CLIENT]: FAILED TO REQUEST GAP SEQUENCE BUT NO GAPS FOUND



上一篇:oracle rac其中第一个节点监听偶尔中断处理案例
下一篇:Oracle出现ORA-00600 [2662] 后, 如何计算 adjust SCN level
回复

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

热门文章教程

  • 实战PHP与MySQL权威指南PDF电子书下载
  • 大数据技术与应用入门培训教程(电子版下载
  • Oracle 12cR2 九大新功能全面曝光_详解云数
  • Oracle OCP认证考试IZ0-053题库共712题数据
  • MySQL5权威指南(第3版)PDF电子版下载
  • 风哥Oracle数据库巡检工具V1.0(附2.6网页
快速回复 返回顶部 返回列表