Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai

Classic Extracts have been deprecated in GoldenGate 19c and shouldn’t be part of your GoldenGate replications for a long time now. Yet, some customers still have them, and with GoldenGate 19c support coming to an end in a few months, it is high time you upgrade to GoldenGate 23ai.

However, GoldenGate 23ai doesn’t support classic extract, and the migration utility provided by Oracle will not take care of them. So, what to do with your classic extracts before migrating to GoldenGate 23ai ?

Upgrade the extracts to integrated mode

The natural solution is to migrate the extracts from the classic mode to the integrated mode. It might not be possible, depending on your situation, but it is the easiest way to get your extracts ready for a GoldenGate 23ai migration.

To do so, we will use the info extract <extract> upgrade command, which tells us whether the extract is ready for an upgrade. Log in with the correct alias and stop the extract before running the command.

GGSCI (vmogg) > dblogin useridalias ggadmin
Successfully logged into database.

GGSCI (vmogg as ggadmin@DB1) > stop extract ext

Sending STOP request to EXTRACT EXT ...
Request processed.

GGSCI (vmogg as ggadmin@DB1) > info extract ext

EXTRACT    EXT       Last Started 2025-12-21 10:13   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:00:10 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2025-12-21 10:19:13  Seqno 10, RBA 18472448
                     SCN 0.2170788 (2170788)

GGSCI (vmogg as ggadmin@DB1) > info extract ext upgrade

You might need to run the command multiple times, depending on the output of the last command. Once the extract is ready to be upgraded, you will see the following output.

GGSCI (vmogg as ggadmin@DB1) > info extract ext upgrade
Extract EXT is ready to be upgraded to integrated capture.

After this, run the upgrade command and restart the extract. The extract is now in Oracle Integrated Redo Logs mode.

GGSCI (vmogg as ggadmin@DB1) > alter extract ext upgrade integrated tranlog
Extract EXT successfully upgraded to integrated capture.

GGSCI (vmogg as ggadmin@DB1) > info extract ext

EXTRACT    EXT       Initialized   2025-12-21 10:13   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:11:43 ago)
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2025-12-21 10:19:13
                     SCN 0.2170788 (2170788)

GGSCI (vmogg as ggadmin@DB1) > start extract ext

Sending START request to MANAGER ...
EXTRACT EXT starting

If your extract doesn’t start, have a detailed look at the parameters used in the extract with view params ext. You could use parameters for your extract that were accepted for classic extracts but not supported for integrated extracts.

Repeat this procedure for all your classic extracts in all your GoldenGate deployments, and you will be ready to migrate to GoldenGate 23ai !