Preparing the environment

Preparation is the key to just about any task. Get the preparation right and you will be rewarded with the best results. This is also true for GoldenGate, where a number of fundamental areas need to be prepared before the installation can take place.

Preparing the database for data replication

To successfully create, configure and start our Extract, Data Pump, and Replicat processes, it's important to configure the source database. As described in Chapter 1, Getting Started, GoldenGate relies on the database's changed data to accomplish data replication.

Enabling supplemental logging

In order to extract the committed transactions from the source Oracle database's online redo logs, as a minimum the database must be configured for supplemental logging on Primary Key columns. This can be enabled at database level using the following DDL executed as SYSDBA:

[oracle@dbserver1 ggs]$ sqlplus '/as sysdba'
SQL> alter database add supplemental log data (primary key) columns...