Oracle GoldenGate Error Messages

OGG-30604

Do not drop any tables from the database that the GoldenGate Extract is capturing data from. Dropping any of the tables in the database will terminate the YDB streaming client and causes the Extract process to abend (abnormally end). This happens because the underlying replication stream becomes invalid when a referenced table is removed. There is no automatic way to recover from this error.


Cause

Removal of a table that is part of the active Extract/replication stream invalidates the streaming metadata and breaks the connection to YDB. YDB terminates the streaming client when it can no longer stream data from the dropped table.


Action

Ensure that none of the tables involved in the Extract process are dropped while replication is active. If a table must be dropped, stop the Extract first, make the schema change, then recreate the Extract with the new slot and restart the Extract process. There is no automatic recovery from this error; manual intervention is required.