在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 <DELETE FROM "BHOMSWAS"."COMM_BASE_WELL_INFO" WHERE "WELL_ID" = :b0>.

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

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

Goldengate資料傳輸外來鍵問題OGG-00869

相關文章