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

    技术2022-05-20  36

    环境介绍:

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


    最新回复(0)