Classic Extract abends with "ERROR OGG-02803 Encountered a Data Guard role transition. Alter Extract to SCN and restart Extract, or recreate Extract with the correct number of threads at SCN " after SWITCHOVER

(Doc ID 2289347.1)

Last updated on AUGUST 22, 2017

Applies to:

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

Symptoms

After Physical Standby became Primary the Classic Extract stops with a error message like below

2016-12-08 12:44:44 ERROR OGG-02803 Encountered a Data Guard role
transition. Alter Extract to SCN 107,579,461 and restart Extract, or recreate
Extract with the correct number of threads at SCN 107,579,461.

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