re-enabling a RAC thread got extract abend with 'begin time .. prior to oldest log in log history.' (Doc ID 1242965.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

For a RAC with 2-nodes, the 2nd node was excluded from extraction for a while, with parameter "THREADOPTIONS PROCESSTHREADS EXCEPT 2".

Now the 2nd node is back, but after removing above parameter, the extract abended with error:

2010-10-18 13:19:07 GGS ERROR 118 begin time Sep 28, 2010 10:03:11 PM prior to oldest log in log history. Last SQL executed <SELECT 1 FROM dual WHERE TO_DATE(:begin_time,'YYYY-MM-DD HH24:MI:SS') < (SELECT MIN(first_time) FROM v$log_history WHERE thread# = :ora_thread)>.

2010-10-18 13:19:07 GGS ERROR 190 PROCESS ABENDING.

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