OUA GoldenGate Checkpoint Table (Doc ID 2197002.1)

Last updated on OCTOBER 25, 2016

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.5.2.0.0 and later
Information in this document applies to any platform.

Goal

We have installed OUA and GoldenGate per the installation guide. The GoldenGate replicat processes are configured as non-integrated without a checkpoint table per the standard installation, eg -

GGSCI (vpduouaa201) 1> info *

REPLICAT CCB1AA Last Started 2016-09-06 16:43 Status STOPPED
Checkpoint Lag 1273:35:23 (updated 864:39:30 ago)
Log Read Checkpoint File /u01/shared/app/oracle/product/12.1.2/goldengate/dirdat/CCB1AA/op000000
  2016-07-15 15:07:49.000000 RBA 4764030

We would like to ensure that when the database is restored using RMAN, GoldenGate knows where to resume replication from the trail files. In order to achieve this, we would like to use a GoldenGate checkpoint table.

 Does the OUA product support us creating a checkpoint table in addition to the checkpoint file?
 Is it planned to use integrated replicat processes? Since these are not compatible with checkpoint tables.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms