These steps add the processes necessary to send data from the primary system to the secondary database.

Perform these steps on the primary system.

1. Use the ADD EXTRACT command to create a primary Extract group. For documentation purposes, this group is called ext_1.

   ADD EXTRACT exte, {TRANLOG | INTEGRATED TRANLOG}, BEGIN time

2. Use the ADD EXTTRAIL command to add a local trail. For documentation purposes, this trail is called trail_east.

   ADD EXTTRAIL trail_east, EXTRACT exte

   For EXTRACT, specify the ext_1 group to write to this trail

3. Use the EDIT PARAMS command to create a parameter file for the ext_1 group. Include the following parameters plus any others that apply to your database environment. For possible additional required parameters, see the Oracle GoldenGate installation and setup guide for your database.

   -- Identify the Extract group:
   EXTRACT exte
   -- Specify database login information as needed for the database:
   [SOURCEDB dsne][, USERIDALIAS alias]
   -- Specify the local trail that this Extract writes to
   -- and the encryption algorithm:
   ENCRYPTTRAIL algorithm
   EXTTRAIL trail_east
   -- Exclude Replicat transactions. Uncomment ONE of the following:
   -- DB2 z/OS, DB2 LUW, DB2 IBM i, and Oracle:
   -- TRANLOGOPTIONS EXCLUDEUSER Replicat_user
   -- Oracle integrated capture:
   -- EXCLUDETAG tag
   -- SQL Server:
   -- TRANLOGOPTIONS FILTERTABLE schema.checkpointtable"
   -- -- Teradata:
   -- SQLEXEC 'SET SESSION OVERRIDE REPLICATION ON;'
   -- SQLEXEC 'COMMIT;'
   -- Log all scheduling columns for CDR and if using integrated Replicat
   LOGALLSUPCOLS
   -- Specify tables to be captured and (optional) columns to fetch:
   TABLE [container.|catalog.]owner.* [, FETCHCOLS cols | FETCHCOLSEXCEPT cols];

Perform these steps on the primary system.

1. Use the ADD EXTRACT command to create a data pump group. For documentation purposes, this group is called pumpe.

   ADD EXTRACT pumpe, EXTTRAILSOURCE ea, BEGIN time

   For EXTTRAILSOURCE, specify ea as the data source.

2. Use the ADD RMTTRAIL command to add a remote trail that will be created on the secondary system. For documentation purposes, this trail is called er.

   ADD RMTTRAIL er, EXTRACT pumpr

   For EXTRACT, specify the pump_1 data pump to write to this trail.

   See Parameters and Functions Reference for Oracle GoldenGate for additional ADD RMTTRAIL options.

   Use the EDIT PARAMS command to create a parameter file for the pumprgroup. Include the following parameters plus any others that apply to your database environment.

   -- Identify the data pump group:
   EXTRACT pumpe
   -- Specify database login information as needed for the database:
   [SOURCEDB dsne][, USERIDALIAS alias]
   -- Decrypt the data only if the data pump must process it.
   -- DECRYPTTRAIL
   -- Specify the name or IP address of the secondary system
   -- and optional encryption of data over TCP/IP:
   RMTHOSTOPTIONS system_2, MGRPORT port_number, ENCRYPT encryption_options
   -- Specify remote trail and encryption algorithm on secondary system:
   ENCRYPTTRAIL algorithm
   RMTTRAIL remote_trail_1
   -- Specify tables to be captured:
   TABLE [container.|catalog.]owner.*;
   

Perform these steps on the secondary system.

1. Create the Replicat checkpoint table after using the DBLOGIN command to connect to the database. See ADD CHECKPOINTTABLE in Command Line Interface Reference for Oracle GoldenGate.

2. Run the command:

   ADD CHECKPOINTTABLE schema.checkpointtable

3. Use the ADD REPLICAT command to create a Replicat group. For documentation purposes, this group is called repe.

   ADD REPLICAT repe
   [, PARALLEL | INTEGRATED | COORDINATED [MAXTHREADS number]]
   , EXTTRAIL er, CHECKPOINTTABLE schema.checkpointtable

   For EXTTRAIL, specify remote_trail_1 as the trail that this Replicat reads.

4. Use the EDIT PARAMS command to create a parameter file for the rep_1 group. Include the following parameters plus any others that apply to your database environment. For possible additional required parameters, see the Oracle GoldenGate installation and setup guide for your database.

   -- Identify the Replicat group:
   REPLICAT repe
   -- Specify database login information as needed for the database:
   [TARGETDB dsnw][, USERIDALIAS alias]
   -- Specify error handling rules:
   REPERROR (error, response)
   -- Set redo tag for Oracle only replicat via settag
   -- Default is 00.
   SETTAG tag_value
   -- Valid for Oracle only. Specify tables for delivery, threads if coordinated Replicat 
   -- and conflict-resolution:
   MAP [container.|catalog.]owner.*, TARGET owner.*, COMPARECOLS (ON operation {ALL | KEY | KEYINCLUDING (col_list) | ALLEXCLUDING (col_list)}), RESOLVECONFLICT (conflict type (resolution_name, resolution_type COLS (col[,...]))
   [, THREAD (thread_ID)]
   [, THREADRANGE (thread_range[, column_list])]
   ;
   -- Specify mapping of exceptions to exceptions table:
   MAP [container.|catalog.]owner.*, TARGET owner.exceptions, EXCEPTIONSONLY;