Oracle GoldenGate 11g Complete Cookbook

Creating a GoldenGate configuration with a consistent state behind the target database

In this recipe you will learn how to set up an Oracle GoldenGate configuration with a deferred apply state target database. You will also learn about some scenarios where such a configuration can be useful.

Getting ready

For this recipe we will refer to the setup done in the Setup a simple GoldenGate replication configuration between two single node databases recipe in Chapter 2, Setting up GoldenGate Replication. For the purpose of this recipe, we will modify the replication to replicate only the records for the EMP table in the SCOTT schema. We will also modify the structure of the EMP table in the target database to add the following two new columns:

• SOURCE_COMMIT_TIME ...