Source System

Configure the Manager process and Extract group on the source system.

To Configure the Manager Process

On the source, configure the Manager process.

To Configure the Extract Group

  1. On the source, use the ADD EXTRACT command to create an Extract group. For documentation purposes, this group is called ext.

    ADD EXTRACT ext, {TRANLOG | INTEGRATED TRANLOG}, BEGIN time [option[, ...]]
  2. On the source, use the ADD RMTTRAIL command to specify a remote trail to be created on the target system.

     ADD EXTTRAIL local_trail, EXTRACT ext

    Use the EXTRACT argument to link this trail to the Extract group.

  3. On the source, use the EDIT PARAMS command to create a parameter file for the Extract 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 ext
    -- Specify database login information as needed for the database:
    [SOURCEDB dsn_1][, USERIDALIAS alias]
    -- Log  all of the supplementally logged columns if using integrated Replicat
    LOGALLSUPCOLS
    ENCRYPTTRAIL algorithm
    EXTTRAIL local_trail
    -- Specify tables and sequences to be captured:
    SEQUENCE [container.|catalog.]owner.sequence;
    TABLE [container.|catalog.]owner.table;

To send the trail files to the target

  1. For Classic Architecture, use the following command option:
    ADD EXTRACT ext_pmp, EXTTRAILSOURCE remote_trail, BEGIN time [option[,...]]
    For Microservices Architecture, use the following command:
    ADD DISTPATH path-name
              SOURCE source-uri
              TARGET target-uri|
             [TARGETTYPE ( MANAGER | COLLECTOR | RECVSRVR ) ]|
  2. Run the following command to add the remote trail:
    ADD RMTTRAIL remote_trail, EXTRACT ext_pmp
  3. Use the EDIT PARAMS command to create a parameter file for the target.