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 TIMESTAMP

• TARGET_COMMIT_TIME TIMESTAMP

This can be done as follows:

SQL> ALTER TABLE EMP ADD(SOURCE_COMMIT_TIME TIMESTAMP);

Table altered.

SQL> ALTER TABLE EMP ADD(TARGET_COMMIT_TIME TIMESTAMP);

Table altered.

How to do it....