goldengate故障處理一例（續）

skuary發表於2012-04-28
原文網址 : http://blog.itpub.net/25618347/viewspace-722416/
Go

在之前的一篇文章中提到的現象，詳見：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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章