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

最新推荐文章于 2025-03-28 14:58:28 发布

转载最新推荐文章于 2025-03-28 14:58:28 发布 · 562 阅读

文章标签：

#数据库

本文记录了在使用Oracle GoldenGate进行数据复制过程中遇到的外键约束错误ORA-02292，并提供了详细的解决步骤，包括禁用相关触发器和外键约束，确保数据同步的顺利进行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在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 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'

禁止外键约束