• goldengate的HANDLECOLLISIONS参数


    HANDLECOLLISIONS 是一个 replicat 进程参数,主要在 initial load 中使用。
    在 replicat 进程中使用该参数时,即使目标数据库环境中存在数据完整性问题(如 update、delete 操作遇到缺失行或重复的插入操作),
    replicat 进程仍然能够继续处理 trail 中的数据。

    如果使用了 HANDLECOLLISIONS 参数,则 replicat 进程将按如下方式处理数据:
    Missing updates are ignored.
    Missing deletes are ignored.
    Duplicate inserts are turned into updates.

    如果要使用 HANDLECOLLISIONS 参数,只需在 replicat 进程参数文件中加入该参数,然后重启 replicat 进程即可生效。

    --如果不使用此参数,双方表不一致,会出现进程挂起,如下的出错:
    2013-08-29 15:40:33  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, rep1.prm:  OCI Error ORA-00001: unique constraint (TEST.SYS_C0011221) violated (status = 1). INSERT INTO "TEST"."TEST1" ("AA") VALUES (:a0).
    2013-08-29 15:40:33  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Aborted grouped transaction on 'TEST.TEST1', Database error 1 (OCI Error ORA-00001: unique constraint (TEST.SYS_C0011221) violated (status = 1). INSERT INTO "TEST"."TEST1" ("AA") VALUES (:a0)).
    2013-08-29 15:40:33  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Repositioning to rba 1426 in seqno 2.
    2013-08-29 15:40:33  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Repositioning to rba 1426 in seqno 2.
    2013-08-29 15:40:33  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Error mapping from TEST.TEST1 to TEST.TEST1.
    2013-08-29 15:40:33  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rep1.prm:  PROCESS ABENDING.

    ###################
    2013-08-29 15:29:39  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rep2.prm:  REPLICAT REP2 started.
    2013-08-29 15:29:39  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, rep2.prm:  Aborted grouped transaction on 'TEST.TEST1', Database error 1403 (OCI Error ORA-01403: no data found, SQL <DELETE FROM "TEST"."TEST1"  WHERE "AA" = :b0>).
    2013-08-29 15:29:39  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rep2.prm:  Repositioning to rba 1018 in seqno 0.
    2013-08-29 15:29:39  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, rep2.prm:  SQL error 1403 mapping TEST.TEST1 to TEST.TEST1 OCI Error ORA-01403: no data found, SQL <DELETE FROM "TEST"."TEST1"  WHERE "AA" = :b0>.
    2013-08-29 15:29:39  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rep2.prm:  Repositioning to rba 1018 in seqno 0.
    2013-08-29 15:29:39  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, rep2.prm:  Error mapping from TEST.TEST1 to TEST.TEST1.
    2013-08-29 15:29:39  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rep2.prm:  PROCESS ABENDING.

  • 相关阅读:
    【数量技术宅|量化投资策略系列分享】股指期货IF分钟波动率统计策略
    【数量技术宅 | Python爬虫系列分享】实时监控股市重大公告的Python爬虫
    0-1背包问题
    活动选择的贪心算法与动态规划
    图的邻接表、拓扑排序、无权最短路径和加权最短路径
    把二叉树转变为左孩子右兄弟树
    基于接缝裁剪的图像压缩 算法导论
    公司聚会
    二叉堆部分练习
    编辑距离问题
  • 原文地址:https://www.cnblogs.com/pangblog/p/3395315.html
Copyright © 2020-2023  润新知