Configuring Change Delivery
Change Delivery is the process of applying the transactions that contain the data changes from the source database to the target database. As we know, this is the responsibility of the Replicat process. The Replicat extracts the pure DML and DDL from the remote trail files and applies them on the target database. This process can often cause a bottleneck, depending on the volume of data being replicated. Oracle recommends multiple Replicats to enable parallel processing to enhance performance.
For this example, we shall create just one Replicat named ROLAP01.
Before we create and configure our Replicat process, we must first create a Checkpoint table in the target database. The Checkpoint table keeps track of all the GoldenGate checkpoints and sequences that support recovery following a shutdown or failure.
Although a Checkpoint table is optional, Oracle highly recommends it over the Checkpoint file as it enables the checkpoint to be included within Replicat's transaction...
