Fail to queue the whole FAL gap in dataguard一例-优快云博客

本文详细解析了在Oracle DataGuard环境下，使用ARCH传输模式时出现的日志传输gap问题，并提供了相关解决方案及注意事项。问题描述了单个在primary库中尚未写出的日志在告警日志中被标识的情况，而该bug已在10.2.0.4和11.1版本中得到修复。对于10.2.0.3版本的部分平台，存在一个针对此bug的一次性补丁可供使用。文章强调了该问题对主备库无影响，建议忽略此类告警。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

近日告警日志中出现以下记录： FAL[server]: Fail to queue the whole FAL gap GAP - thread 1 sequence 180-180 DBID 3731271451 branch 689955035 这是一个10.2.0.3的dataguard环境，采用物理备库，归档传输模式；查询metalink发现相关note:

Symptoms
When 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: 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. v$archive_gap returns no rows SQL> select * from v$archive_gap; no rows selected Cause Bug 5526409 - FAL gaps reported at standby for log not yet written at primary Solution Bug 5526409 is fixed in 10.2.0.4 and 11.1. Upgrade to 10.2.0.4 as 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. One-off Patch for Bug 5526409 on top of 10.2.0.3 is available for some platforms. Please check Patch 5526409 for your platform.

该note描述在10.1.0.2-10.2.0.3版本中，在ARCH传输的DataGuard环境中可能出现日志传输gap为单个在primary库中尚未写出的日志，该gap可能会在告警日志中以以上形式标示。

该bug(问题)在版本10.2.0.4和11.1中得到了修复，在10.2.0.3版本中部分平台上有one-off补丁。但实际上该bug(问题)对于主备库不会有任何影响，我们也可以将之忽略。

转载于:https://www.cnblogs.com/macleanoracle/archive/2010/07/20/2967464.html