The next few blogs will be related to the design, implantation and operation of the Oracle GoldenGate hub architecture.  The Oracle GoldenGate hub architecture is where Oracle GoldenGate is installed and configured on a different server from the database server.  This is not the same as downstream processing, since you are accessing the database logs on the server where they are generated.

Qualify for a FREE GoldenGate Health Check Here!

The Oracle GoldenGate hub architecture allows you to setup Oracle GoldenGate in a single environment and setup extracts and replicats associated with many different databases.  There are a few caveats, however.  In order for GoldenGate to process against another server, they must be the same OS.  I.e. Linux to Linux, Solaris to Solaris, etc.  At this time, cross platform extracts/replicats are not supported.

In addition, a GoldenGate home must be configured for each database to be accessed.  Thus, it is possible to have a Linux GoldenGate Server Farm that supports a GoldenGate home for Oracle 11g and Oracle 12c.  Each GoldenGate home can support multiple databases on multiple servers.

This architecture is the same type of architecture that is used with GoldenGate cloud services and has been proven effective.  Performance is great and resource consumption is offloaded from the database server.

I have been using the Oracle GoldenGate hub architecture model for quite a while.  In my next few blogs I will be talking about the performance and benefits of the Oracle GoldenGate hub architecture along with some of the issues you might run into.

Next: Configuring the Oracle GoldenGate Hub