Switching Extract from Integrated Mode to Classic Mode

Valid for Oracle only.

This procedure switches an existing Extract group from integrated mode to classic mode. For more information about Extract modes for an Oracle database, see Choosing Capture and Apply Modesin .

To support the transition to classic mode, the transaction log that contains the start of the oldest open transaction must be available on the source or downstream mining system. To determine the oldest open transaction, issue the SEND EXTRACT command with the SHOWTRANS option. You can use the FORCETRANS or SKIPTRANS options of this command to manage specific open transactions, with the understanding that skipping a transaction may cause data loss and forcing a transaction to commit to the trail may add unwanted data if the transaction is rolled back by the user applications. Review these options in Oracle GoldenGate Parametersin Parameters and Functions Reference for Oracle GoldenGatebefore using them.

GGSCI> SEND EXTRACT group, SHOWTRANS�
GGSCI> SEND EXTRACT group, { SKIPTRANS ID [THREAD n] [FORCE] |�
FORCETRANS ID [THREAD n] [FORCE] }�

To Switch Extract Modes

Back up the current Oracle GoldenGate working directories.
While the Oracle GoldenGate processes continue to run in their current configuration, so that they keep up with current change activity, copy the Extract parameter file to a new name.
Grant the appropriate privileges to the Extract user and perform the required configuration steps to support your business applications in classic capture mode. See Assigning Credentials to Oracle GoldenGatein for information about configuring and running Extract in classic mode.
Issue the following command to determine whether the downgrade command can be issued. Transactions that started before the downgrade command is issued must be written to the trail before you can proceed. You may have to issue this command more than once until it returns a message stating that Extract can be downgraded.
```
INFO EXTRACT group DOWNGRADE
```
Stop the Extract group.
```
STOP EXTRACT group
```
Log into the mining database with one of the following commands, depending on where the mining database is located.
```
DBLOGIN USERIDALIAS alias

MININGDBLOGIN USERIDALIAS alias
```
Where: alias is the alias of a user in the credential store who has the privileges granted through the Oracle dbms_goldengate_auth.grant_admin_privilege procedure.
Switch the Extract group to classic mode.
```
ALTER EXTRACT group DOWNGRADE INTEGRATED TRANLOG
```
If on a RAC system, then the THREADS option has to be used with the downgrade command to specify the number of RAC threads.
Unregister the Extract group from the mining database. Among other things, this removes the logmining server.
```
UNREGISTER EXTRACT group DATABASE
```
Replace the old parameter file with the new one, keeping the same name.
Start the Extract group.
```
START EXTRACT group
```