Extract Upgrade Considerations
If you are using trigger-based DDL support, you must rebuild the DDL objects, even if you plan to use the new triggerless DDL support in an integrated capture. After the upgrade, when Oracle GoldenGate is running successfully again, you can remove the trigger and DDL objects.
The output trail file is automatically rolled over when the Extract restarts and the integrated Extract version is upgraded.
Because the time zone is different, you may need to run the
ALTER REPLICAT extseqno
command to
synchronize with newer trail files after consuming the old trail file
written by Integrated Extract version 1.
After completing the upgrade, run the UPGRADE
HEARTBEATTABLE
command to add extra columns for tables and
lag views. These extra columns are used to track the Extract restart
position. See UPGRADE
HEARTBEATTABLE
to know more.