OUA GoldenGate Checkpoint Table
Last updated on OCTOBER 25, 2016
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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.
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