CHECKPOINTRETENTIONTIME Parameter Is Not Giving Desired Results

(Doc ID 2201717.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Trying to use Oracle script to gather OGG healthcheck, but it reports inaccurate information

Oracle GoldenGate Integrated Extract/Replicat Health Check (v4.0.4)

+ 'INFO: Checkpoint Retention time set to .0000000810185185185185 days by extract EXT_ANZ1

when in fact it is set to 7 days

GGSCI (dgspo10l) 6> send ext_anz1 getparaminfo

Sending GETPARAMINFO request to EXTRACT EXT_ANZ1 ...

GLOBALS

enablemonitoring :

/app/ogg/SP/dirprm/ext_anz1.prm

extract : EXT_ANZ1
tranlogoptions :
  checkpointretentiontime : 7.000000

++ From the Database, we can see the below information

CAPTURE_NAME START_SCN FIRST_SCN REQUIRED_CHECKPOINT_SCN STATUS CHECKPOINT_RETENTION_TIME
------------------------------ ---------- ---------- ----------------------- -------- -------------------------
OGG$CAP_ANZTEST 4370817936 4370817936 4410267500 ENABLED 8.1019E-08
OGG$CAP_EXT_ANZ1 4090652399 4090652399 4410266381 ENABLED 8.1019E-08

 

Changes

 No specific changes.

Cause

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