We have 3 Oracle 11GR2 database servers, A, B and C. At the moment we have GoldenGate replicating from A to B. We want to set up another GoldenGate process to replicate from B to C. Database server A cannot reach C, so the replication must come from B to C. Is there a way of replicating the replicated data in B to C? Can the second GoldenGate process (between B and C) be configured to pickup the replicated data in B from the first GoldenGate process (from A to B)?
What I did to achieve this was to create the same GG process on B, but using a different OGGADMIN user (OGGADMIN2). Server B GG was configured to ignore data from OGGADMIN2 but not from OGGADMIN (from server A). This way I was able to replicate the replicated data from A to B and C while also maintaining a GG user between B and C.