Oracle GoldenGate Error Messages

OGG-00729

Running extract against a single thread (thread# {1,number,0}) in a RAC configuration with {0,number,0} threads. All transactions owned by other redo threads will be ignored.


Cause

Oracle GoldenGate is being started in an Oracle RAC installation that has more than one instance, but the Extract process is only running against a single RAC instance.


Action

You need to redirect Extract to capture from all RAC instances by doing the following: Issue STOP EXTRACT in GGSCI, then issue DELETE EXTRACT. Next, if the database is Oracle Enterprise Edition 10.2 or higher, issue DBLOGIN as a user with the privileges listed in the DBLOGIN documentation. Finally, issue ADD EXTRACT to add back the group with the same name. Do not change the name. Include the following options in the command: TRANLOG and BEGIN with a begin time. Set BEGIN to the timestamp of the earliest record that the old Extract captured.