ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Goldengate数据传输外键问题OGG-00869

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

原创 Linux操作系统 作者:mengzhaoliang 时间:2011-02-28 11:46:55 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2008-01-30

  • 博文量
    335
  • 访问量
    2973390