ogg在oracle database 11.2.0.3上还是谨慎使用集成捕捉模式

最新推荐文章于 2024-08-02 00:38:21 发布

原创最新推荐文章于 2024-08-02 00:38:21 发布 · 5.7k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ogg #integrated extract #11.2.0.3

Oracle DB 同时被 3 个专栏收录

772 篇文章

订阅专栏

Oracle GoldenGate

101 篇文章

订阅专栏

Oracle GoldenGate

28 篇文章

订阅专栏

本文解决Oracle GoldenGate在11.2.0.3版本升级后遇到的OGG-02077错误，即集成抽取进程因LogMiner内存不足而异常终止的问题。该问题由数据库缺陷16747736引起，通过增加max_sga_size设置只能暂时缓解，根本解决方案在于应用11.2.0.4补丁集或获取定制修复。

原因：
OGG Integrated Extract abend with ORA-01341: LogMiner out-of-memory (文档 ID 1640076.1)

APPLIES TO:

Oracle GoldenGate - Version 11.2.1.0.0 and later
Information in this document applies to any platform.

SYMPTOMS

The integrated extract abend with the following error
ERROR OGG-02077 Extract encountered a read error in the asyncronous reader thread and is abending: Error code 1341, error message: ORA-01341: LogMiner out-of-memory.

CAUSE

The problem is often encountered after the database was upgraded to 11.2.0.3.

The issue is due to database bug 16747736

SOLUTION

No workarounds available
Increasing the max_sga_size to a high value will delay the time of getting hit with the issue but won't totally fix it.

The database bug fix is included in the 11.2.0.4 database patch set.
Please reach RDBMS team in case if you want to get a one off for 11.2.0.3 db version.