OGG Replicating Oracle source data to multiple Oracle targets using ALO (Doc ID 1357786.1)

Last updated on SEPTEMBER 15, 2011

Applies to:

Oracle GoldenGate - Version: 11.1.1.1.9 to 11.1.1.0.0 - Release: 11.1.1.1 to 11.1.1
Information in this document applies to any platform.

Goal

The plan is to use ALO to replicate data from an Oracle source database to multiple Oracle target databases.  The archive logs will reside on the primary source database server in location X and the non-primary target database will be in location Y.

At times, the user will want to make the database in Location Y the primary and the database in location X the non-primary.  Both need to read the archive logs from the server in Location X.  What is the best practice to set up GG?  Is OGG required on both source and target servers or just the source server whenusing ALO?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms