OGG Newly created extract is stuck in recovery mode
(Doc ID 2434196.1)
Last updated on NOVEMBER 06, 2019
Applies to:Oracle GoldenGate - Version 126.96.36.199.2 and later
Information in this document applies to any platform.
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: Processing data
Current read position:
Redo thread #: 1
Sequence #: 0
Timestamp: 2018-08-11 01:54:49.000000
SCN: 0.0 (0)
Current write position:
Sequence #: 0
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.
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