Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00001 ORA-00902

RobeenJul 30 2019 — edited Aug 8 2019

Oracle Database 12.2.0

RHEL 7.4

Hello Team,

Replication for table CBSOGG.CB_SUBS_OFFER_DETAILS is in sync(same number of rows on source and target).

I noticed a warning in ggserr.log.

Will this affect the data content?

2019-07-30T14:32:02.989+0400  INFO    OGG-01738  Oracle GoldenGate Capture for Oracle, extdwh.prm:  BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p25576_extr: start=SeqNo: 45209, RBA: 1132709904, SCN: 60.3931985277 (261630023037), Timestamp: 2019-07-30 11:05:29.000000, end=SeqNo: 45229, RBA: 321071128, SCN: 60.3940021057 (261638058817), Timestamp: 2019-07-30 14:31:49.000000, Thread: 1.

2019-07-30T14:45:10.682+0400  WARNING OGG-02544  Oracle GoldenGate Delivery for Oracle, reploggt.prm:  Unhandled error (ORA-00902: invalid datatype

                              ORA-00001: unique constraint (.) violated

                              ORA-00001: unique constraint (CBSOGG.CB_SUBS_OFFER_DTL$1) violated) while processing the record at SEQNO 110, RBA 491195569 in Integrated mode. REPLICAT will retry in Direct mode.

Regards,

Joe

Comments
Post Details
Added on Jul 30 2019
11 comments
521 views