当前位置: 首页 > GoldenGate, Oracle > 正文

OGG启动REPLICAT进程又遇到OGG-00212错误

今天在给客户安装OGG的时候,REPLICAT进程无法启动。

GGSCI (ycods1) 24> start REPCIMXB

Sending START request to MANAGER ...
REPLICAT REPCIMXB starting
GGSCI (ycods1) 25> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING
REPLICAT    ABENDED     REPCIMXB    00:00:00      00:09:08
REPLICAT    RUNNING     TREPLVA     00:00:00      00:00:05

观察日志,发现又是OGG-00212错误。

2013-05-08 11:43:30  ERROR   OGG-00212  Invalid option for MAP: SG_CIM.MATCONPERFRECEVIEDINFO.

经过分析发现MATCONPERFRECEVIEDINFO表在MAP的时候出现问题,而源端和目标端表结构、字符集什么的都一致,配置文件是客户总部下发,按理说经过严格测试不会存在问题,仔细观察配置文件。

MAP CIM.MATCONTRACT ,TARGET SG_CIM.MATCONTRACT , COLMAP ( USEDEFAULTS, UPDATETIME=@DATENOW());
MAP CIM.MATCONPERFRECEVIEDINFO,TARGET SG_CIM.MATCONPERFRECEVIEDINFO , COLMAP ( USEDEFAULTS, UPDATETIME=@DATENOW());
MAP CIM.MATCONPERFPAYMENT ,TARGET SG_CIM.MATCONPERFPAYMENT , COLMAP ( USEDEFAULTS, UPDATETIME=@DATENOW());
MAP CIM.MATSUPPLIERINFO ,TARGET SG_CIM.MATSUPPLIERINFO , COLMAP ( USEDEFAULTS, UPDATETIME=@DATENOW());

发现MATCONPERFRECEVIEDINFO表(标红部分的逗号前面少了一个空格),只有这行在表名后面没有空格,其他行表名后面都有空格,猜测是因为少个空格导致的,加上空格,再次启动。

GGSCI (ycods1) 38> start REPCIMXB
Sending START request to MANAGER ...

REPLICAT REPCIMXB starting

GGSCI (ycods1) 39> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING
REPLICAT    RUNNING     REPCIMXB    00:00:00      00:00:01
REPLICAT    RUNNING     TREPLVA     00:00:00      00:00:03

而且,REPLICAT进程复制正常。

Start of Statistics at 2013-05-08 11:50:44.
Replicating from CIM.MATCONPERFRECEVIEDINFO to SG_CIM.MATCONPERFRECEVIEDINFO:
*** Total statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00
*** Daily statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00
*** Hourly statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00
*** Latest statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00
Replicating from CIM.MATCONPERFPAYMENT to SG_CIM.MATCONPERFPAYMENT:
*** Total statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00
*** Daily statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00
*** Hourly statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00
*** Latest statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00
Replicating from CIM.MATSUPPLIERINFO to SG_CIM.MATSUPPLIERINFO:
*** Total statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00
*** Daily statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00
*** Hourly statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00
*** Latest statistics since 2013-05-08 11:50:29 ***
Total inserts                                1.00
Total updates                                0.00
Total deletes                                0.00
Total discards                               0.00
Total operations                             1.00

End of Statistics.

这个问题很有意思,正常没有这个空格也是可以的,通过这个案例也可以说明,表名后面要是所有行都不加空格直接加逗号,是没有问题的,要是都加个空格也是可以的,但只要有一个没加就可能遇到问题,也就是要加就全家,不加就都不加,恶心啊。

本文固定链接: http://www.dbdream.com.cn/2013/05/ogg%e5%90%af%e5%8a%a8replicat%e8%bf%9b%e7%a8%8b%e5%8f%88%e9%81%87%e5%88%b0ogg-00212%e9%94%99%e8%af%af/ | 信春哥,系统稳,闭眼上线不回滚!

该日志由 dbdream 于2013年05月17日发表在 GoldenGate, Oracle 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: OGG启动REPLICAT进程又遇到OGG-00212错误 | 信春哥,系统稳,闭眼上线不回滚!
关键字: , ,
【上一篇】
【下一篇】

OGG启动REPLICAT进程又遇到OGG-00212错误:等您坐沙发呢!

发表评论

快捷键:Ctrl+Enter