GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

replication is not happening in DB although in GG stats showing the UPDATE counter increased

Hi,

  1. I have updated a non primary key column in source . Committed.
  2. Stats from GG UI shows an increase in no of updates at both in extract as well as in apply.
  3. But problem is actually that record is not being updated in the Target DB.
  4. Supplimental log has been set in DB at db and schema level. Table is having big no of column so have not set the supplimental for all columns.
  5. I have used HANDLECOLLISIONS to control data collision.
  6. Normal insert/updates/deletes working fine.
  7. It's not updating in the scenario, when I am updating the record in the source but the same record is not existing in the target DB. Ideally it should have converted the update as insert , since I have used the HANDLECOLLISIONS parameter.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center