Wednesday, June 29, 2022

Goldengate Extract Fails to Start with OGG-00446 OGG-02829 after downgrading from Integrated to Classic Capture

 Problem:

On a RAC DB, after downgrading a goldengate extract group from Integrated to Classic capture and when Starting goldengate extract for the first time after the downgrade, it failed with the following error:

 2022-06-29T13:47:22.179+0000  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, extpa.prm:  �'Oo.
2022-06-29T13:47:22.187+0000  ERROR   OGG-02829  Oracle GoldenGate Capture for Oracle, extpa.prm:  Not able to establish initial position for SCN 1530.534313392 (6571834276272), Could not find archived log for sequence 0 thread 2 under default destinations SQL <SELECT  name   FROM v$archived_log   WHERE sequence# = :1 AND         thread# = :2 AND         resetlogs_id = :3 AND         archived = 'YES' AND         deleted = 'NO'         AND standby_dest = 'NO'         order by name DESC>, error retrieving redo file name for sequence 0, archived = 1, use_alternate = 0.
2022-06-29T13:47:22.187+0000  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extpa.prm:  PROCESS ABENDING.


Analysis:

The error message shows that goldengate unable to access the log sequence for Thread2 which represents the second instance in my RAC setup, because it was down when starting the goldengate extract process.

Solution:

When upgrading or downgrading an extract from Integrated to Classic capture and vise versa on a RAC DB, make sure that all RAC instances in the cluster are in OPEN mode before starting the goldengate extract; in order to allow goldengate to access all threads when you start the goldengate extract group for the first time after the upgrade or the downgrade.



No comments:

Post a Comment