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.
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.
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.
Post a Comment