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.
在 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.
相關文章
- HANDLECOLLISIONS :GoldenGate Replicat的引數Go
- 瞭解GoldenGate Replicat的HANDLECOLLISIONS引數Go
- GoldenGate HANDLECOLLISIONS引數使用說明Go
- goldengate的ASSUMETARGETDEFS引數Go
- GOLDENGATE常用引數Go
- goldengate 的 COMPRESSUPDATES 引數Go
- GoldenGate 基本引數含義Go
- oracle goldengate引數學習OracleGo
- Oracle GoldenGate常用引數詳解OracleGo
- goldengate OGG引數規範Go
- goldengate 引數之GETTRUNCATES | IGNORETRUNCATESGo
- Goldengate引數簡要說明Go
- GoldenGate的一些引數的意義Go
- GoldenGate學習筆記(11)_常用引數Go筆記
- goldengate關於CONVERTUCS2CLOBS引數Go
- GoldenGate 配置文件,裡面有引數說明Go
- goldengate 目的端程式引數APPLYNOOPUPDATES 和ALLOWNOOPUPDATESGoAPPOOP
- goldengate 中使用batchsql引數需要額外考慮的地方GoBATSQL
- 關於Oracle GoldenGate 引數TRANLOGOPTIONS altarchivelogdestOracleGoHive
- oracle goldengate 複製端延時應用引數OracleGo
- Oracle GoldenGate系統之----相關引數說明OracleGo
- 使用隱含引數testMappingSpeed排查GoldenGate抽取慢的步驟APPGo
- oracle goldengate 雙活複製避免迴圈複製引數OracleGo
- 【原創】一對雙引號引發的goldengate血案Go
- oracle goldengate 引數詳解(轉MOS:Oracle GoldenGates ample parameter files)OracleGo
- kettle 引數——變數引數和常量引數變數
- C#中的值引數,引用引數及輸出引數C#
- iOS可變引數(不定引數)的用法iOS
- 常用的jvm配置引數 :永久區引數配置JVM
- Oracle引數-隱藏引數Oracle
- 什麼是請求引數、表單引數、url引數、header引數、Cookie引數?一文講懂HeaderCookie
- Swift語言中為外部引數設定預設值可變引數常量引數變數引數輸入輸出引數Swift變數
- c# 方法引數_值引數C#
- c# 方法引數_引用引數C#
- 動態引數,靜態引數
- sendEmail帶的引數AI
- Mybatis的引數-parameterTypeMyBatis
- EXPDP的parallel引數Parallel