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 platfor
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.
细节：–暂时不翻译。
Oracle GoldenGate Best Practices: Instantiation from an Oracle Source
本文来源gao!%daima.com搞$代*!码9网(
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)
转载请注明原文链接：【翻译自mos文章】MainNote-ogg的SupplementalLoggingandTRANDAT
