OGG Newly created extract is stuck in recovery mode (Doc ID 2434196.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

The extract is in recovery mode even though it's a new setup with begin now.  

GGSCI > info extract EPFRDCB showch

EXTRACT EPFRDCB Last Started 2018-08-11 01:55 Status RUNNING
Checkpoint Lag 00:02:12 (updated 00:00:01 ago)
Process ID 6787
Log Read Checkpoint Oracle Integrated Redo Logs
2018-08-11 01:54:49                                                  <<<<<<<<<<<<<<<<<< The timestamp of redo is 5 hours ahead.
SCN 0.0 (0)

GGSCI> send extract EPFRDCB status

Sending STATUS request to EXTRACT EPFRDCB ...

EXTRACT EPFRDCB (PID 6787)
Current status: In recovery[1]: Processing data

Current read position:
Redo thread #: 1
Sequence #: 0
RBA: 0
Timestamp: 2018-08-11 01:54:49.000000
SCN: 0.0 (0)
Current write position:
Sequence #: 0
RBA: 1476
Timestamp: 2018-08-11 01:56:31.062616
Extract Trail: /opt/oracle/ggs/dirdat/ext/onprem/cb

The Goldengate and Database are running on two different Servers. The Hub Server (The Server OGG is running on ) and the database Sever are running in the different timezone .

Hub Server is running in UTC timezone but the database server is running in Eastern Timezone.

Cause

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