环境介绍:
源头:rhel5 32bit,oracle10.2.0.4 32bit ,goldengate v11.1.1 for oracle 10g 32bit
目的地:rhel5 32bit,oracle10.2.0.4 32bit ,goldengate v11.1.1 for oracle 10g 32bit
源头的goldengate 配置没有问题,info all 命令都是running
目的地的goldengate 配置看似没有问题,虽然info all 命令都是running
从源头做了几个dml操作后,查看源头extract进程和datapump进程的统计信息:
stats extract ext 和 stats extract datapump,都反馈如下的结果
*** Daily statistics since 2011-04-15 21:12:07 *** Total inserts 1.00 Total updates 0.00 Total deletes 1.00 Total discards 0.00 Total operations 2.00
查看目的地的replicat进程的统计信息 stats replicat rep
GGSCI (host1) 1> stats replicat rep Sending STATS request to REPLICAT REP ... No active replication maps DDL replication statistics: *** Total statistics since replicat started *** Operations 0.00 Mapped operations 0.00 Unmapped operations 0.00 Other operations 0.00 Excluded operations 0.00 Errors 0.00 Retried errors 0.00 Discarded errors 0.00 Ignored errors 0.00
后来发现居然是目的端add replicat 命令写错了:
错误的:add replicat rep, exttrail /u01/dirdat/bj , CHECKPOINTTABLE goldengate.ckpttable
正确的:add replicat rep, exttrail /u01/ggs/dirdat/bj , CHECKPOINTTABLE goldengate.ckpttable
此问题是通过查看原始的部署脚本看出来的(部署脚本就写错了)
此问题也可以通过如下命令查看rep进程和trail文件的对应关系:
GGSCI (host1) 11> info replicat rep, detail REPLICAT REP Last Started 2011-04-15 21:12 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:08 ago) Log Read Checkpoint File /u01/dirdat/bj000000 First Record RBA 0