GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Oracle Streams 11.2.0.1 Child records attempting to apply before parent records

edited Sep 21, 2013 10:58PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
We recently had to re-sync our multi-master streams configuration. We brought down all of the streams processes; chose a single master site and uploaded it with the differentiating data from all sites; exported the "master" to the other sites; then started the streams processes again. Now one of our sites is having an issue keeping its apply process enabled. It is constantly aborting due to error 02291 - integrity constraint <constraint name> violated - parent key not found. Because this is happening roughly every 1 - 5 mins, this particular site is falling further and further behind causing us to

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