Goldengate数据传输外键问题OGG-00869

在goldengate数据传输中，在目标数据库出现下面的错误：

74:错误

2011-02-28 10:00:47  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, rorabb.prm:  OCI Error ORA-02292: integrity constraint (BHOMSWAS.FK_DH_OPS_WELLFRACTACIDEXTRUBA) violated - child record found (status = 2292), SQL .

2011-02-28 10:00:47  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, rorabb.prm:  Aborted grouped transaction on 'BHOMSWAS.COMM_BASE_WELL_INFO', Database error 2292 (ORA-02292: integrity constraint (BHOMSWAS.FK_DH_OPS_WELLFRACTACIDEXTRUBA) violated - child record found).

2011-02-28 10:00:47  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rorabb.prm:  Repositioning to rba 605117 in seqno 465.

2011-02-28 10:00:47  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rorabb.prm:  Repositioning to rba 605117 in seqno 465.

2011-02-28 10:00:47  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, rorabb.prm:  Error mapping from BHOMSWAS.COMM_BASE_WELL_INFO to BHOMSWAS.COMM_BASE_WELL_INFO.

2011-02-28 10:00:47  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rorabb.prm:  PROCESS ABENDING.

 

 

27:在源数据库：

GGSCI (CBDBS01) 10>dblogin userid ggtransfer,password ggtransfer

GGSCI (CBDBS01) 11> info trandata BHOMSWAS.COMM_BASE_WELL_INFO

 

Logging of supplemental redo log data is enabled for table BHOMSWAS.COMM_BASE_WE

LL_INFO

 

74：在目标数据库

禁止目标数据库的表关联的触发器及外键

禁止与COMM_BASE_WELL_INFO表关联的3个触发器

 

select * from dba_constraints t

where t.constraint_name='FK_DH_OPS_WELLFRACTACIDEXTRUBA'

 

禁止外键约束

alter table DH_OPS_WELLFRACTACIDEXTRUBASE

disable constraint FK_DH_OPS_WELLFRACTACIDEXTRUBA

 

GGSCI (BZXXDBS01) 2> start rorabb

 

Sending START request to MANAGER ...

REPLICAT RORABB starting

 

 

GGSCI (BZXXDBS01) 3> info all

 

Program     Status      Group       Lag           Time Since Chkpt

 

MANAGER     RUNNING                                          

EXTRACT     RUNNING     EIEXPP      00:00:00      00:00:05   

EXTRACT     RUNNING     EPMPPP      00:00:00      00:00:07   

REPLICAT    RUNNING     RORABB      74:51:36      00:49:19   

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12778571/viewspace-688083/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12778571/viewspace-688083/