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.
Fail to queue the whole FAL gap in dataguard一例
原创
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
近日告警日志中出现以下记录:
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:
该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(问题)对于主备库不会有任何影响,我们也可以将之忽略。
下一篇:索引使用空间异常增长一例
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Dataguard Gap处理
方法一:手工注册日志 方法二:RMAN 增量恢复
GAP DG 主从不同步 -
DataGuard GAP 修复1-- 模拟产生GAP
Oracle Dataguard GAP修复
oracle dataguard -
dataguard之归档gap管理
当备库不能接受到一个或多个主库的归档日志文件
dataguard gap 归档日志 hive sql -
FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 29-29
步到备库:
hive oracle sql 归档日志 自动启动 -
Protobuf一例客户端 ide 数据同步 perl 微信