Configuring Oracle GoldenGate Replicat

This section highlights the basic Replicat parameters that are required for most target database types. Additional parameters 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 system.

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.
Create a Replicat group. For documentation purposes, this group is called rep.
```
ADD REPLICAT rep, EXTTRAIL remote_trail, CHECKPOINTTABLE owner.table
```
Use the EXTTRAIL argument to link the Replicat group to the remote trail that you specified for the data pump on the source server.
Use the EDIT PARAMS command to create a parameter file for the Replicat group. Include the parameters shown in **INTERNAL XREF ERROR** plus any others that apply to your database environment.

Example 3-2 Parameters for the Replicat Group

-- Identify the Replicat group:
REPLICAT rep
-- Specify database login information as needed for the database:
[TARGETDB target_dsn_name,] [USERID user id[, PASSWORD pw]]
-- Specify tables for delivery:
MAP owner.source_table, TARGET owner.target_table;