Oracle GoldenGate Trail File

Trail files are generated by both the original extract and the Data Pump (extract) process. Trail files are read by the Data Pump (extract) and Replicat (replicat) processes

goldengate extract process abending caused by nologging DDL

I use goldengate(for oracle) to do a SCHEMA synchronize […]

goldengate supports sync data from no-partition table to partition table(OGG同步非分区表到分区表)

OGG可以是否从SOURCE db 一个非分区表到TARGET db 的一个分区表的同步么?DDL/DML是否都可以?

Check goldengate replicate Availability (检查OGG REPLICATE)

通过检查replicate进程确认OGG REPLICATE进程是否存活shell

External Table On GoldenGate Discard Files

goldengate 做为数据同步的利器,越来越普遍,往往会因为某些原因replicat进程在应用trail文件时会失败,进程要么Abending也可以也忽略记录到 Discard Files中,默认在OGG_HOME/dirrpt/ *.dsc,可以用文本工具查看内容,当然也可以更方便的用pl/sql function 读取文件,做为一张外部表(external table)查询

skip a transaction in goldengate(跳过一个事务OGG)

GGSCI (ggsdb) 1> alter replicat ricme, extrba 84510103
REPLICAT altered.
GGSCI (ggsdb) 3> start ricme

goldengate update collisions

Total updates 12.00
Total deletes 0.00
Total discards 0.00
Total operations 13.00
Total update collisions 12.00

ora-600 [kcbgcur_9] internal error when ALTER DATABASE ADD SUPPLEMENTAL LOG DATA

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcbgcur_9], [8388681], [25],
[100663296], [33554432], [], [], []

GoldenGate 小测试initial load,extract change

模拟一种主库不停机,做个备库并initial load,并同步改变数据
安装配置GOLDEN GATE
源机启用本地Extract 进程抽取变化生成本地trail文件