My Oracle Support Banner

OUA GoldenGate Checkpoint Table (Doc ID 2197002.1)

Last updated on JANUARY 08, 2024

Applies to:

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


**Disclaimer:** This KM article may include the following abbreviations:

OUA - Oracle Utilities Analytics
RMAN - Recovery Manager


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 /<path>/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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.