GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Sequences in GoldenGate uni-directional replication

edited Dec 26, 2014 10:01AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered

Hi,

While testing uni directional replication with Goldengate, we are observing a strange behaviour with sequences.

For initial load, we did an exp/imp from source to target of the schema to be replicated. At this point we checked, and the last_number for a very frequently used sequence was same on both sides. We started the application and simulated some load and stopped after a few minutes.

Now the last_number on both sides is different; its higher by on the target side. In previous test the difference was 25. During every test, it is the target that is on the higher side. But why does this happen?

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