GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Handling Errors and Conflicts

edited Apr 9, 2014 12:00PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hello,

In my understanding there are 3 ways of handling errors/conflicts:

1 - dont do anything. Let replicat process abend and log the error in ggserr.log and report file. To resolve, correct the values or skip the dml and resume.

2 - configure reperror with discard or exceptions and allow the process to continue. Later, manually handle the dml or leave it as skipped.

3 - put in-built CDR and custom-built conflict resolution in place which is like auto-handling (for e.g. if ora-1403 no data found is encountered then convert to an insert or for unique constraint violation, convert to update).

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