oracle goldengate

I use goldengate(for oracle) to do a SCHEMA synchronized,include DDL operrations. when the the EXTRACT process was running to capture the changes ,then if you try do a DDL such as “alter table t_a no logging” on the capture table will cause EXT process ABENDING, I hit these errors today. ogg version: Oracle GoldenGate Command … Read more

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

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

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