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