>  기사  >  데이터 베이스  >  【翻译自mos文章】MainNote-ogg的SupplementalLoggingandTRANDAT

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

WBOY
WBOY원래의
2016-06-07 15:58:421378검색

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)

성명:
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.
이전 기사:memcached安装和验证다음 기사:数据库设计