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