oracle goldengate for DB2表同步报多次同步warning

数据库是DB2 v9.7的,用OGG同步到另外一个数据库,19点开始源端数据库报同步warning,而且不止一个数据库这样,好几个源端库都是这样的错误,想请教一下,有哪些原因会导致数据表同步多次,先多谢各位了。

下面是当天所有的日志信息:

2016-08-15 12:01:11  INFO    OGG-00957  Oracle GoldenGate Manager for DB2, mgr.prm:  Purged old extract file /home/oggpehis/dirdat/pa000000040, applying UseCheckPoints purge rule: Oldest Chkp

t Seqno 43 > 40.

2016-08-15 19:07:47  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:07:47  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:07:57  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:07:57  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:07:58  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:07:58  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:08:08  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:08:08  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:08:08  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:08:08  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:08:10  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:08:10  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:08:10  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:08:10  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:08:11  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:08:11  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:08:11  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:08:11  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:08:20  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:08:20  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:09:42  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:09:42  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:09:42  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:09:42  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:09:43  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:09:43  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:09:43  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_TRANS_JOURNAL".

2016-08-15 19:09:43  WARNING OGG-02081  Oracle GoldenGate Capture for DB2, extpa.prm:  Detected duplicate TABLE/MAP entry for source table PECHS.PEB_TRANS_JOURNAL and target table PECHS.PEB_T

RANS_JOURNAL. Using prior TABLE/MAP specification.

2016-08-15 19:26:45  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_CHANNEL_HANDLER".

2016-08-15 19:26:45  INFO    OGG-06509  Oracle GoldenGate Capture for DB2, extpa.prm:  Using the following key columns for source table PECHS.PEB_CHANNEL_HANDLER: CHANNEL_ID, TRANS_TYPE.

2016-08-15 19:26:46  INFO    OGG-02262  Oracle GoldenGate Capture for DB2, dpepa.prm:  Passthru wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_CHANNEL_HANDLER".

2016-08-15 19:28:04  INFO    OGG-06508  Oracle GoldenGate Capture for DB2, extpa.prm:  Wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_CHANNEL_TECH_CONFIG".

2016-08-15 19:28:04  INFO    OGG-06509  Oracle GoldenGate Capture for DB2, extpa.prm:  Using the following key columns for source table PECHS.PEB_CHANNEL_TECH_CONFIG: TRANS_TYPE, CHANNEL_ID.

2016-08-15 19:28:05  INFO    OGG-02262  Oracle GoldenGate Capture for DB2, dpepa.prm:  Passthru wildcard MAP (TABLE) resolved (entry PECHS.*): table "PECHS"."PEB_CHANNEL_TECH_CONFIG".

2016-08-15 19:31:17  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for DB2:  GGSCI command (oggpehis): info all.

2016-08-15 19:31:32  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for DB2:  GGSCI command (oggpehis): stop er *.

2016-08-15 19:31:32  INFO    OGG-01021  Oracle GoldenGate Capture for DB2, dpepa.prm:  Command received from GGSCI: STOP.

2016-08-15 19:31:32  INFO    OGG-00991  Oracle GoldenGate Capture for DB2, dpepa.prm:  EXTRACT DPEPA stopped normally.

2016-08-15 19:31:33  INFO    OGG-01021  Oracle GoldenGate Capture for DB2, extpa.prm:  Command received from GGSCI: STOP.

2016-08-15 19:31:33  INFO    OGG-00991  Oracle GoldenGate Capture for DB2, extpa.prm:  EXTRACT EXTPA stopped normally.

2016-08-15 19:31:41  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for DB2:  GGSCI command (oggpehis): start er *.

参与4

提问者

喂小饱me9
数据库运维工程师chinapay
擅长领域: 数据库服务器存储

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2016-08-18
  • 关注会员:2 人
  • 问题浏览:3068
  • 最近回答:2016-08-30
  • X社区推广