Switching Replicat from Integrated Mode to Non-Integrated Mode

Valid for Oracle only. For more information about Replicat modes for an Oracle database, see About Integrated Replicat in Using Oracle GoldenGate for Oracle Database.

You can, at any time, switch Replicat from integrated mode to non-integrated mode. This switch automatically unregisters the Replicat group from the target database, which removes the inbound server.

Note:

Do not configure the switch between Replicat modes to occur immediately after Extract recovers from a failure or is repositioned to a different location in the transaction log.

Back up the 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 Replicat parameter file to a new name.
Grant the appropriate privileges to the Replicat user and perform the required configuration steps to support your business applications in non-integrated Replicat mode. See Assigning Credentials to Oracle GoldenGatein Using Oracle GoldenGate for Oracle Databasefor information about configuring and running Replicat in integrated mode.
Connect to the Oracle GoldenGate deployment as a system user.
Log into the target database from the command line.
```
DBLOGIN 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.
Create a checkpoint table in the target database for the non-integrated Replicat to use to store its recovery checkpoints. If a checkpoint table was previously associated with this Replicat group and still exists, you can omit this step. See About Checkpoint Table for more information about options for using a checkpoint table.
```
ADD CHECKPOINTTABLE [container.]table
```
Stop Replicat.
```
STOP REPLICAT group
```
Alter Replicat to non-integrated mode. For the CHECKPOINTTABLE argument, specify the checkpoint table that you created for this Replicat group.
```
ALTER REPLICAT group, NONINTEGRATED, CHECKPOINTTABLE [container.]table
```
Replace the old parameter file with the new one, keeping the same name.
Start Replicat.
```
START REPLICAT group
```
After issuing this command, wait until there is some activity on the source database so that the switchover can be completed. (Replicat waits until its internal high-water mark is exceeded before removing the status of "switching from integrated mode.")
Verify that Replicat switched to non-integrated mode.
```
INFO REPLICAT group
```