oracle ogg教程,【翻译自mos文章】在OGG (Oracle GoldenGate) 中使用SCHEMATRAND

最新推荐文章于 2023-02-26 16:46:17 发布

weixin_39608526

最新推荐文章于 2023-02-26 16:46:17 发布

阅读量172

点赞数

文章标签： oracle ogg教程

Oracle GoldenGate在11.2.0.2.0及更高版本中，使用SCHEMATRANDATA时可能会遇到错误，如无法验证表函数。这通常由于缺少特定的dbpatch导致。解决方案是应用bug13794550的修复，该修复增强了对SCHEMATRANDATA的支持。确保已安装相关补丁以确保SCHEMATRANDATA正常工作。

摘要由CSDN通过智能技术生成

在OGG (Oracle GoldenGate) 中使用SCHEMATRANDATA的话，需要额外的db patch 参考原文： Patches needed to support SCHEMATRANDATA in OGG (Oracle GoldenGate) (Doc ID 1426440.1) 适用于： Oracle GoldenGate - Version 11.1.1.1.1 and later Information

在OGG (Oracle GoldenGate) 中使用SCHEMATRANDATA的话，需要额外的db patch

参考原文：

Patches needed to support SCHEMATRANDATA in OGG (Oracle GoldenGate) (Doc ID 1426440.1)

适用于：

Oracle GoldenGate - Version 11.1.1.1.1 and later

Information in this document applies to any platform.

症状1：

DB Version is 11.2.0.2.0 and ADD SCHEMATRANDATA fails with following error：

GGSCI (host) 13> DBLOGIN USERID ggat password abcd

Successfully logged into database.

GGSCI (host) 14> ADD SCHEMATRANDATA scott

2012-02-17 15:11:42 ERROR OGG-01783 Cannot verify existence of table function that is required to enable schema level supplemental logging, failed to find function.

症状2：

DB Version is 11.2.0.3, using SCHEMATRANDATA. ADD SCHEMATRANDATA works fine. Table has multiple unique indexes, no primary key.

Extract captures NULL for the unique index columns that aren't supposed to have NULL value.

--抽取进程捕捉到唯一索引列的NULL值，而这些唯一索引中没有null值。

原因：

为了让SCHEMATRANDATA 正常工作， rdbms 需要相关的patch。

解决方案：

- bug 10271153 added support for ALLKEYS_ON specifically to support Golden Gate.

- a code bug was identified on the change in 10271153 and was fixed in bug 10271153

- fix in bug 10271153 was later enhanced and superseded by bug 13794550

To use SCHEMATRANDATA, please apply the fix in bug 13794550

本文原创发布php中文网，转载请注明出处，感谢您的尊重！