【翻译自mos文章】Main Note - ogg的 Supplemental Logging and TRANDATA

最新推荐文章于 2024-04-22 07:53:35 发布

翻译最新推荐文章于 2024-04-22 07:53:35 发布 · 2.4k 阅读

文章标签：

#ogg #add trandata

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文介绍Oracle GoldenGate (OGG) 中如何通过addtrandata命令配置补充日志，确保在进行更新操作时主键列也被记录，这对于跨库同步至关重要。

Main Note - ogg的 Supplemental Logging and TRANDATA

参加原文：
Main Note - Supplemental Logging and TRANDATA for OGG (Doc ID 1537838.1)

适用于
Oracle GoldenGate - Version 9.5_EA and later
Information in this document applies to any platform.

目的
从oracle redo log 抽取数据之前，需要从ggsci命令提示符下先使用 dbloin命令，再使用add trandata命令。
默认情况下，对update操作，oracle 只会记录变化的列。正常情况下，这意味着主键列在update操作时不会被记录。
但是，为了在目的库上应用源端ogg进程传输过来update变化，ogg的replicat 进程需要主键列。
add trandata命令别用来让oracle 对所有update操作都记录主键列。
为了添加补充日志（supplemental log data）,在unix下执行下面的命令。table名可以用*代替。所有被捕捉的表必须被添加补充日志。

$ cd /ggs $ ggsci
GGSCI (unixserver) > DBLOGIN USERID userid --->额外注意：敲回车后，ggsci会提示你输入密码，只是此处没列出来而已。
GGSCI (unixserver) > ADD TRANDATA schema.<table-name>

细节：--暂时不翻译。
Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database[Document 1276058.1]
OGG GGSCI Add Trandata Fails with OGG-00706 Failed to Add Supplemental Log Group on Table[Document 1357001.1]
Why is ADD TRANDATA, Supplemental Logging Not OGG replicated [Document 1444946.1]
OGG Unable To ADD TRANDATA Because Of Insufficient Permission [Document 969574.1]
Adding Supplemental Logging With No PK And > 33 Columns (Oracle) add trandata[Document 965993.1]
In Bi-Directional Replication, Supplemental logging via DDL Is NOT Replicated To The Target unless[Document 1472420.1]
OGG: How To Log All Columns With Add Schematrandata To Get NOCOMPRESSUPDATES[Document 1413142.1]
It is recommended to perform a del/add trandata cycle on all tables when upgrading[Document 1299567.1]
Why OGG Warns me "No unique key is defined" When There Is A PK For The Table[Document 1345152.1]
Internal Notes:
Why Add Trandata On Tables Without Primary Key, Can Cause SQL Server 2005 Replication Log Reader St[Document 1060875.1](Internal Only)
SQLServer 2005 - Add Trandata Failed With "Unable To Enable Replication"[Document 1063132.1](Internal Only)
Effect Of Key Selection Change In OGG V10, On Upgrade Procedure From Earlier Version. [Document 1060879.1] (Internal Only)