数据库是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 *.