O'Reilly logo

Oracle GoldenGate 11g Complete Cookbook by Ankur Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Setting up a simple GoldenGate replication configuration between two single node databases

In this recipe we will look at how to configure GoldenGate for continuous replication between two single node databases.

Getting ready

For this setup, we make the following assumptions:

  1. The source and target database have already been set up.
  2. Both the databases have a schema called SCOTT which is in a consistent state. No transformations will be performed in this recipe.
  3. Oracle GoldenGate binaries are already installed in both sites.
  4. The extract method used in this example will be classic capture.
  5. Supplemental Logging is enabled at database and table level for all the objects to be replicated.

How to do it...

We will follow these steps to set up this replication ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required