GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Goldengate DDL replication warning OGG-00738 "Object ID could not be resolved"

edited Aug 24, 2014 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 9 commentsAnswered
 Goldengate Version 11.2.1.0.6Oracle 10GR2 to Oracle 11GR2 replication

Hi

I see the following repeatedly appearing in ggserr.log:

"WARNING OGG-00738  Oracle GoldenGate Capture for Oracle, e10bdmig.prm:  Object id [nnnnnn], SCN [nnnnnnn], commit SCN [nnnnnnnn] could not be resolved. Most likely this happens if DDL history for it was deleted. Please check purge parameters in manager parameter file (if it is too short). If that is ok, this was probably an object that was not filtered out and this can be ignored."


The object ID does not exist in the 10g database but does in the 11g database (it is a subpartitioned index) - this is because DDL replication has been running for a few weeks so object IDs have diverged.

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