GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Verify Replication Caught Up

edited Nov 16, 2016 4:19PM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered ✓

In Oracle GoldenGate Integrated capture/apply, how can we verify a large transaction has finished applying at the target? 

We need to ensure a large transaction has fully applied at the target before starting the next phase of our nightly batch processing, which relies on that data being current in the target.  Ideally, we'd like the validation to happen entirely in-database.

I was initially hoping I could look at the source SCN at the end of the transaction, and then look at the target's applied SCN, but I'm having a difficult time locating the SCN associated with the most recent apply action on the target side.

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