Start Replicat Aftercsn Doesn't Work As Expected (Doc ID 1911385.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle GoldenGate - Version 9.5.0.11 and later
Information in this document applies to any platform.

Symptoms

Start replicat aftercsn doesn't work as expected

Problem happens on init load for a replicat rp01p

Customer has done an oracle datapump import with flashback_scn= 4719782660519 (source database).

After the import is complete on the target database, i have to restart replicat after the scn 4719782660519;

Customer sees start replicat aftercsn 4719782660519

But goldengate start at csn 4719782674641 in the trail 629, skipping a lot of transactions in the trail 628...

2014-07-02 15:16:35 INFO OGG-01373 Oracle GoldenGate Delivery for Oracle, rp01p.prm: User requested start after CSN 4719782660519.
2014-07-02 15:16:35 INFO OGG-01374 Oracle GoldenGate Delivery for Oracle, rp01p.prm: Transaction delivery commencing at position Seqno 629, RBA 1174, Transaction ID 443.6.305530, CSN 4719782674641, 0 transaction(s) skipped.
[...]
2014-07-02 15:16:36 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rp01p.prm: Repositioning to rba 1174 in seqno 629.
2014-07-02 15:16:36 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rp01p.prm: SQL error 1403 mapping GG.HEARTBEAT to GG.HEARTBEAT OCI Error ORA-01403: no data found, SQL <UPDATE "GG"."HEARTBEAT" SET "HB" = :a2,"SOURCE_TRS" = :a3 WHERE "HB" = :b0 AND "SOURCE_TRS" = :b1 AND ROWNUM = 1>.
2014-07-02 15:16:36 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rp01p.prm: Repositioning to rba 1174 in seqno 629.
2014-07-02 15:16:36 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, rp01p.prm: Aborted grouped transaction on 'GG.A805', Database error 0 ().
2014-07-02 15:16:36 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rp01p.prm: Repositioning to rba 1174 in seqno 629.
2014-07-02 15:16:36 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, rp01p.prm: Error mapping from GG.HEARTBEAT to GG.HEARTBEAT.
2014-07-02 15:16:36 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rp01p.prm: PROCESS ABENDING.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms