当前位置:Gxlcms > mysql > 【翻译自mos文章】MainNote-ogg的SupplementalLoggingandTRANDAT

【翻译自mos文章】MainNote-ogg的SupplementalLoggingandTRANDAT

时间:2021-07-01 10:21:17 帮助过:36人阅读

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 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)

人气教程排行