现在的位置: 首页 > 综合 > 正文

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

2013年09月02日 ⁄ 综合 ⁄ 共 1786字 ⁄ 字号 评论关闭

环境介绍:

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

抱歉!评论已关闭.