ITPub博客

首页 > Linux操作系统 > Linux操作系统 > goldengate故障处理一例(续)

goldengate故障处理一例(续)

原创 Linux操作系统 作者:skuary 时间:2012-04-28 10:41:30 0 删除 编辑

在之前的一篇文章中提到的现象,详见:http://space.itpub.net/25618347/viewspace-722335,昨天观察下来,没有再发生,问题基本上定位是内存不足的原因,看来以后得更加小心才行!

附上截图: 

gg主库:

GGSCI (rac3) 26> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                          
EXTRACT     RUNNING     DPKSR1      00:00:02      00:00:09   
EXTRACT     RUNNING     EXTKSR1     00:00:01      00:00:09  

errlog:

2012-04-28 10:38:15  INFO    OGG-00487  Oracle GoldenGate Capture for Oracle, extksr1.prm:  DDL operation included [INCLUDE MAPPED], optype [TRUNCATE], objtype [TABLE], objowner [MYNET_APP], objname [M_GOODS_STOCK2].
2012-04-28 10:38:15  INFO    OGG-00497  Oracle GoldenGate Capture for Oracle, extksr1.prm:  Writing DDL operation to extract trail file.
2012-04-28 10:42:16  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extksr1.prm:  Rolling over remote file /share_disk/ggs/trails/s1000289.
2012-04-28 10:42:16  WARNING OGG-00869  Oracle GoldenGate Capture for Oracle, dpksr1.prm:  Object MYNET_APP.M_ADVERTISEMENT_CLICK_SUM has NOLOGGING option specified either at the table level or at the level of one of its (sub)partitions.
2012-04-28 10:42:16  WARNING OGG-00869  Oracle GoldenGate Capture for Oracle, dpksr1.prm:  No unique key is defined for table M_ADVERTISEMENT_CLICK_SUM. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
2012-04-28 10:43:16  INFO    OGG-00538  Oracle GoldenGate Capture for Oracle, extksr1.prm:  Metadata not invalidated for [MYNET_APP.M_GOODS_STOCK2] because of TRUNCATE.
2012-04-28 10:43:16  INFO    OGG-01487  Oracle GoldenGate Capture for Oracle, extksr1.prm:  DDL found, operation [truncate table m_goods_stock2  (size 30)], start SCN [77464228117], commit SCN [77464228297] instance [yesmynet1 (1)], DDL seqno [13315], marker seqno [10315].
2012-04-28 10:43:16  INFO    OGG-00487  Oracle GoldenGate Capture for Oracle, extksr1.prm:  DDL operation included [INCLUDE MAPPED], optype [TRUNCATE], objtype [TABLE], objowner [MYNET_APP], objname [M_GOODS_STOCK2].
2012-04-28 10:43:16  INFO    OGG-00497  Oracle GoldenGate Capture for Oracle, extksr1.prm:  Writing DDL operation to extract trail file.
2012-04-28 10:43:22  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, dpksr1.prm:  Rolling over remote file /home/oracle/ggs/trails/t1000291.

gg备库:

GGSCI (rptdb) 11> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                          
REPLICAT    RUNNING     REPKSR1     00:00:00      00:00:01

errlog:

2012-04-28 10:35:12  INFO    OGG-00482  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  DDL found, operation [truncate table m_goods_stock2  (size 30)].
2012-04-28 10:35:12  INFO    OGG-00540  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  Metadata not cleared for [MYNET_APP.M_GOODS_STOCK2] because of TRUNCATE.
2012-04-28 10:35:12  INFO    OGG-00489  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  DDL is of mapped scope, after mapping new operation [truncate table "MYNET_APP"."M_GOODS_STOCK2"  (size 44)].
2012-04-28 10:35:12  INFO    OGG-00487  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  DDL operation included [INCLUDE MAPPED], optype [TRUNCATE], objtype [TABLE], objowner [MYNET_APP], objname [M_GOODS_STOCK2].
2012-04-28 10:35:12  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  Setting current schema for DDL operation to [MYNET_APP].
2012-04-28 10:35:12  INFO    OGG-00484  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  Executing DDL operation.
2012-04-28 10:35:12  INFO    OGG-00483  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  DDL operation successful.
2012-04-28 10:35:12  INFO    OGG-01408  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  Restoring current schema for DDL operation to [OGG].
2012-04-28 10:40:13  INFO    OGG-00482  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  DDL found, operation [truncate table m_goods_stock2  (size 30)].
2012-04-28 10:40:13  INFO    OGG-00540  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  Metadata not cleared for [MYNET_APP.M_GOODS_STOCK2] because of TRUNCATE.
2012-04-28 10:40:13  INFO    OGG-00489  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  DDL is of mapped scope, after mapping new operation [truncate table "MYNET_APP"."M_GOODS_STOCK2"  (size 44)].
2012-04-28 10:40:13  INFO    OGG-00487  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  DDL operation included [INCLUDE MAPPED], optype [TRUNCATE], objtype [TABLE], objowner [MYNET_APP], objname [M_GOODS_STOCK2].
2012-04-28 10:40:13  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  Setting current schema for DDL operation to [MYNET_APP].
2012-04-28 10:40:13  INFO    OGG-00484  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  Executing DDL operation.
2012-04-28 10:40:13  INFO    OGG-00483  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  DDL operation successful.
2012-04-28 10:40:13  INFO    OGG-01408  Oracle GoldenGate Delivery for Oracle, repksr1.prm:  Restoring current schema for DDL operation to [OGG].

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25618347/viewspace-722416/,如需转载,请注明出处,否则将追究法律责任。

下一篇: WARNING OGG-00869
请登录后发表评论 登录
全部评论

注册时间:2011-03-31

  • 博文量
    88
  • 访问量
    314836