Fail to queue the whole FAL gap in dataguard一例

本文涉及的产品
日志服务 SLS,月写入数据量 50GB 1个月
简介:
近日告警日志中出现以下记录: 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(问题)对于主备库不会有任何影响,我们也可以将之忽略。


本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1277497
相关实践学习
日志服务之使用Nginx模式采集日志
本文介绍如何通过日志服务控制台创建Nginx模式的Logtail配置快速采集Nginx日志并进行多维度分析。
相关文章
|
数据库管理 Ruby
Transaction recovery: lock conflict caught and ignored
Transaction recovery: lock conflict caught and ignored环境:RAC 4节点、oracle 11.2.0.4、redhat 5.9 64bit 问题描述: 1.
1850 0
|
SQL 关系型数据库 MySQL
利用v$enqueue_lock解决ORA-14450的错误
【背景】一个TEMP表的字段设置短了,开发要进行修改, alter table SALE_TEMP modify CODE VARCHAR2(2000); 就报了一个错误ORA-14450:试图访问已经在使用的事务处理临时表; ...
1464 0
|
关系型数据库 MySQL
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction Mysql 报错
Mysql 报错: [Err] 1205 - Lock wait timeout exceeded; try restarting transaction
490 0
|
SQL Oracle 关系型数据库
ORACLE等待事件:enq: TX - row lock contention
enq: TX - row lock contention等待事件,这个是数据库里面一个比较常见的等待事件。enq是enqueue的缩写,它是一种保护共享资源的锁定机制,一个排队机制,先进先出(FIFO)。
1721 0