My Oracle Support Banner

CHECKPOINTRETENTIONTIME Parameter Is Not Giving Desired Results (Doc ID 2201717.1)

Last updated on APRIL 09, 2020

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_1

when in fact it is set to 7 days

GGSCI> send ext_1 getparaminfo

Sending GETPARAMINFO request to EXTRACT EXT_1 ...

GLOBALS

enablemonitoring :

/app/ogg/SP/dirprm/ext_1.prm

extract : EXT_1
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_TEST 4370817936 4370817936 4410267500 ENABLED 8.1019E-08
OGG$CAP_EXT_1 4090652399 4090652399 4410266381 ENABLED 8.1019E-08

 

Changes

 No specific changes.

Cause

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
Symptoms
Changes
Cause
Solution
References


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