注册登录
提 问
English中文版
IT其它Db2数据库ogg重复同步

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 *.

关注2
评论
参与4

1同行回答
|
按赞同排序
按时间排序

wonder_191wonder_191数据库运维工程师北京融海数据科技股份有限公司
19点开始说明19点这个表才产生了DML操作的数据，ogg的extract进程才会从日志里面抽取，你先确认下你源端数据库有几个extract进程，会不会有两个extract进程里面都在抓取PECHS.PEB_TRANS_JOURNAL这个表的内容，或者你直接把params贴上来...显示全部

19点开始说明19点这个表才产生了DML操作的数据，ogg的extract进程才会从日志里面抽取，你先确认下你源端数据库有几个extract进程，会不会有两个extract进程里面都在抓取PECHS.PEB_TRANS_JOURNAL这个表的内容，或者你直接把params贴上来

收起
互联网服务 · 2016-08-30
浏览2055
评论1
  • 喂小饱me9  喂小饱me9
    很感谢你的回复，日志中有提到通配符，而我的进程配置里都是使用PECHS.*这种形式mapping的，不知道是不是因为这个造成的告警
    2016-08-31
    赞同
    评论

提问者

喂小饱me9
喂小饱me9
数据库运维工程师chinapay
擅长领域： 数据库，服务器，存储
关注4
回答31
评论60

相关问题

  • 超融合能否扛起全闪做支撑交易类数据库最佳平台的大旗？
  • 对于业务系统的历史数据存放、查询，哪种类型的数据库更为合适？
  • 金融行业传统数据库一般如何解决io需求？
  • 哪个国产数据库更值得去学习，各国产数据库的特点及缺点？
  • 信创环境下，哪些国产数据库能上银行核心系统？

    • 相关资料

  • IDC+中国金融行业国产分布式数据库白皮书
  • oracle日常维护手册
  • Redhat7.6 Oracle 19C RAC部署手册
  • Redhat7.0 Oracle 12C RAC部署手册
  • 海通证券核心数据库系统高可用及存储设备选型经验分享

    • 相关文章

  • 南大通用对数据库领域国家标准编制与实施的贡献浅析
  • Redis 的优势是如何在保单业务中发挥出来的
  • 企业传统Oracle数据库迁移国产数据库核心难点总结
  • 招聘：建信金科基础技术中心数据库产品团队
  • 数据库运维管理平台面面观

    • 问题状态

  • 发布时间：2016-08-18
  • 关注会员：2 人
  • 问题浏览：3046
  • 最近回答：2016-08-30

    • 关于TWT使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们
    © 2024talkwithtrend — talk with trend,talk with technologist京ICP备09031017号-30

    X社区推广