Configuring Oracle GoldenGate Replicat

This section describes the Replicat parameters that are required for most target database types. For additional parameters that may be required, see the Oracle GoldenGate installation and configuration documentation for your target database and the Reference for Oracle GoldenGate.

Perform these steps on the target replication server or target database.

Configure the Manager process according to the instructions in Administering Oracle GoldenGate.
In the Manager parameter file, use the PURGEOLDEXTRACTS parameter to control the purging of files from the local trail.
Create a Replicat checkpoint table. There are multiple options for this purpose, see Administering Oracle GoldenGate.
```
DBLOGIN SOURCEDB myttdbcs USERIDLIAS useralias
ADD CHECKPOINTTABLE owner.oggcheckpointtable
```
Create a Replicat. For documentation purposes, this Replicat is called reptt.
```
ADD REPLICAT reptt, EXTTRAIL ./dirdat/remote_trail, CHECKPOINTTABLE owner.oggcheckpointtable
```
Use the EXTTRAIL argument to link the Replicat to the remote trail that you specified with the Data Pump Extract on the source Oracle GoldenGate installation.
Use the EDIT PARAMS command to create a parameter file for the Replicat group. Include the parameters shown below plus any others that apply to your database environment.

Example 3-3 Parameters for the Replicat Group

REPLICAT reptt
-- Specify database login information as needed for the database: 
TARGETDB myttdbcs, USERIDALIAS useralias
-- Specify tables for delivery: 
MAP owner.sourcetable, TARGET owner.targettable;