My Oracle Support Banner

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 JANUARY 22, 2020

Applies to:

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


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.


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

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