Changing the Number of Oracle RAC Threads when Using Classic Capture

Valid for Extract in classic capture mode for Oracle. When Extract operates in classic capture mode, the Extract group must be dropped and re-added any time the number of redo threads in an Oracle RAC cluster changes. To drop and add an Extract group, perform the following steps:

On the source and target systems, run GGSCI.
Stop Extract and Replicat.
```
STOP EXTRACT group
STOP REPLICAT group
```
On the source system, issue the following command to delete the primary Extract group and the data pump.
```
DELETE EXTRACT group
DELETE EXTRACT pump_group
```
On the target system, issue the following command to delete the Replicat groups.
```
DELETE REPLICAT group
```
Using standard operating system commands, remove the local and remote trail files.
Add the primary Extract group again with the same name as before, specifying the new number of RAC threads.
```
ADD EXTRACT group TRANLOG, THREADS n, BEGIN NOW
```
Add the local trail again with the same name as before.
```
ADD EXTTRAIL trail, EXTRACT group
```
Add the data pump Extract again, with the same name as before.
```
ADD EXTRACT group EXTTRAILSOURCE trail, BEGIN NOW
```
Add the remote trail again with the same name as before.
```
ADD RMTTRAIL trail, EXTRACT group
```
Add the Replicat group with the same name as before. Leave off any BEGIN options so that processing begins at the start of the trail.
```
ADD REPLICAT group EXTTRAIL trail
```
Start all processes, using wildcards as appropriate. If the re-created processes are the only ones in the source and target Oracle GoldenGate instances, you can use START ER * instead of the following commands.
```
START EXTRACT group
START REPLICAT group
```