My Oracle Support Banner

Extract Is Not Coming Up After Switchover (Doc ID 2663464.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

Classic extract is stuck and it is not processing after an ADG switchover/ failover in RAC environment . 


EXTRACT xxx  Last Started 2020-02-12 13:02 Status RUNNING
Checkpoint Lag 04:43:03 (updated 02:58:22 ago)
Process ID 325734

There is no error in report.

GGSCI>send xxx , status
Sending STATUS request to EXTRACT xxx ...
EXTRACT xxx (PID xxx )
Current status: In recovery[1]: Processing data with empty data queue
Current read positions:
Redo thread #: 1
Sequence #: 449
RBA: 368491536
Timestamp: 2020-02-12 05:37:43.000000
SCN: 3874.1982026498 (16640685331202)
Redo thread #: 6
Sequence #: 395
RBA: 177168
Timestamp: 2020-02-12 05:43:56.000000
SCN: 3874.1982162987 (16640685467691)
Redo thread #: 2
Sequence #: 396
RBA: 204959248
....

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
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.