GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How to instantiate the OID schema in the target database of a GoldenGate replication

edited Jan 15, 2015 10:02AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

I had opened a Service Request for this, put I was advised to put my question here.

In manual https://docs.oracle.com/cd/E23943_01/doc.1111/e15250/design_consid.htm#ASDRG415, section "3.3 Database Considerations", it is documented that you can use GoldenGate as replication mechanism for a standby OID repository.

For DataGuard, it's easy : It synchronizes the full database with everything on it, including the DataDictionary. So that's always a complete copy, always a valid fallback database for OID. (Tried it, tested it, works like a charm)

GoldenGate synchronizes individual schemas, not the data dictionary. And GoldenGate is only able to keep a schema is sync, if it was already in sync in the first place. But the above manual doesn't say how to get the initial copy of the OID repository in the target database.

Tagged:

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