goldengate命令输入错误导致的血案2

环境介绍：

源头：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