OGG 源端与目标端 约束不一致

需求：

请在生产库执行下面的脚本

--删除主键并新增复合主键             

alter table XXXXX  drop constraint PK_USERCHNL cascade;

alter table XXXXX  add constraint PK_USERCHNL primary key (USERCODE, SALECHNL, STR1);

 

目标端ogg异常：

2019-04-03 09:54:38  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, rep_1b.prm:  Aborted grouped transaction on 'XXXXX', Database error 1 (OCI Error ORA-00001: unique constraint (PK_USERCHNL) violated (status = 1). INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "XX"."XXXX" ("USERCODE","SALECHNL","STR1","STR2","STR3","DATE1","DATE2","DATE3") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7)).
2019-04-03 09:54:38  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, rep_1b.prm:  SQL error 1 mapping XX.XXXXto LIS.USERCHNL OCI Error ORA-00001: unique constraint (XXX.PK_USERCHNL) violated (status = 1). INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "XX"."XXXX" ("USERCODE","SALECHNL","STR1","STR2","STR3","DATE1","DATE2","DATE3") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7).
2019-04-03 09:54:38  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, rep_1b.prm:  Error mapping from LIS.USERCHNL to XX.XXXXX.
2019-04-03 09:54:38  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rep_1b.prm:  PROCESS ABENDING.
2019-04-03 09:57:49  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, rep_1b.prm:  OCI Error ORA-00001: unique constraint (XX.PK_USERCHNL) violated (status = 1). INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "XX"."XXXXX" ("USERCODE","SALECHNL","STR1","STR2","STR3","DATE1","DATE2","DATE3") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7).
2019-04-03 09:57:49  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, rep_1b.prm:  Aborted grouped transaction on 'XX.XXXX', Database error 1 (OCI Error ORA-00001: unique constraint (XX.PK_USERCHNL) violated (status = 1). INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "XX"."XXXXX" ("USERCODE","SALECHNL","STR1","STR2","STR3","DATE1","DATE2","DATE3") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7)).
2019-04-03 09:57:49  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, rep_1b.prm:  SQL error 1 mapping LIS.USERCHNL to XX.XXXXXX OCI Error ORA-00001: unique constraint (XXX.PK_USERCHNL) violated (status = 1). INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "XX"."XXXXX" ("USERCODE","SALECHNL","STR1","STR2","STR3","DATE1","DATE2","DATE3") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7).
2019-04-03 09:57:49  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, rep_1b.prm:  Error mapping from LIS.USERCHNL to XX.XXXXXX.
2019-04-03 09:57:49  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rep_1b.prm:  PROCESS ABENDING.

 

--对比源端与目标端约束是否一致

select owner, constraint_name, constraint_type, status, validated 
from dba_constraints 
where owner='FLORACLE' and TABLE_NAME = 'TBL_BRH_KEY_INDEX'; 

 

解决方案：

在目标端删除多余的约束