goldengate故障處理一例(續)
在之前的一篇文章中提到的現象,詳見: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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- goldengate故障處理一例Go
- OGG 故障處理一例
- ORA-00054 故障處理一例
- database link故障處理一例Database
- 處理mysql複製故障一例薦MySql
- ORACLE 10G rac故障處理一例Oracle 10g
- oracle dataguard資料同步故障處理一例Oracle
- goldengate複製過程字符集處理一例Go
- 【故障處理】一次RAC故障處理過程
- MongoDB故障處理MongoDB
- 故障分析 | Greenplum Segment 故障處理
- GoldenGate COLMAP字串處理Go字串
- 處理set autotrace故障又一例_ora-942_sp2-0611
- GPON網路故障如何處理?GPON網路故障處理流程
- 【故障處理】ORA-600:[13013],[5001]故障處理
- 【故障處理】ORA- 2730*,status 12故障分析與處理
- linux故障處理Linux
- ora-故障處理
- mysqlconnect bug 處理一例。MySql
- 線上故障處理手冊
- MySQL show processlist故障處理MySql
- 微服務的故障處理微服務
- teams登入故障處理
- Oracle更新Opatch故障處理Oracle
- 如何快速處理線上故障
- Mysql故障處理2則MySql
- dataguard故障處理一則
- AIX系統故障處理AI
- 【Linux】 nfs 故障處理LinuxNFS
- GoldenGate常見異常處理Go
- 遠端通過監聽連線報ORA-01034故障處理一例
- ORA-04030處理一例
- ORA-16038處理一例
- OGG-00952---oracle goldengate無法purge歷史表和mark表處理一例OracleGo
- 【故障處理】CRS-1153錯誤處理
- 【故障處理】ORA-19809錯誤處理
- undo表空間故障處理
- flash_recovery_area故障處理