skip a transaction in goldengate(跳过一个事务OGG)
GGSCI (ggsdb) 1> alter replicat ricme, extrba 84510103
REPLICAT altered.
GGSCI (ggsdb) 3> start ricme
OGG
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文件