在之前的一篇文章中提到的现象,详见: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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25618347/viewspace-722416/