1. Oracle GoldenGate Classic Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. PostgreSQL
  5. Configuring Replicat
  6. Creating a Replicat

Creating a Replicat

These steps create a Replicat to deliver transactional data to a target PostgreSQL database.
  1. In GGSCI, create the Replicat parameter file.
    EDIT PARAMS repnm

    In this sample, repnm is a name of the Replicat. For Classic Replicat, the name can be no more than 8 alpha-numeric characters in length. For Coordinated Replicat, the name must be five or less alpha-numeric characters in length.

  2. Enter the Replicat parameters in the order shown, starting a new line for each parameter statement.

    Sample basic parameters for Classic Replicat:

    REPLICAT repnm
TARGETDB dsn_name USERIDALIAS alias
BATCHSQL
GETTRUNCATES
MAP schema.object, TARGET schema.object;
    Sample basic parameters for Coordinated Replicat:
    REPLICAT repnm
TARGETDB dsn_name USERIDALIAS alias
BATCHSQL
GETTRUNCATES
MAP schema.object1, TARGET schema.object1, THREAD (1);
MAP schema.object2, TARGET schema.object2, THREAD (2);
MAP schema.object3, TARGET schema.object3, THREAD (3);
    Parameter Description

    REPLICAT repnm

    repnm is the name of the Replicat and cannot be more than 8 alpha-numeric characters in length for Classic Replicat and 5 or less for Coordinated Replicat. For more information, see REPLICAT in Reference for Oracle GoldenGate.

    TARGETDB dsn_name

    Specifies the name of the database connection DSN.

    USERIDALIAS alias

    Specifies the alias of the database login credential of the user that is assigned to Replicat. This credential must exist in the Oracle GoldenGate credential store. For more information, see Establishing Oracle GoldenGate Credentials.

    BATCHSQL

    GETTRUNCATES

    Optional parameters for Replicat that supports transaction batching and replication of truncate operations.

    MAP schema.object, TARGET schema.object;

    or

    MAP schema.*, TARGET schema.*;
    Specifies the relationship between a source table and the corresponding target object or objects.

    • MAP specifies the source table or a wildcarded set of tables.

    • TARGET specifies the target table or a wildcarded set of tables.

    • schema is the schema name or a wildcarded set of schemas.

    • object is the name of a table or a wildcarded set of tables.

    • THREAD assigns table operations to a specific coordinated Replicat thread.

      Terminate the parameter statement with a semi-colon.

      To exclude objects from a wildcard specification, use the MAPEXCLUDE parameter.

      For more information and for additional options that control data filtering, mapping, and manipulation, see MAP in Reference for Oracle GoldenGate.

  3. Enter any optional Replicat parameters that are recommended for your configuration. You can edit this file at any point before starting processing by using the EDIT PARAMS command.

  4. Save and close the file.

  5. Add the Replicat, which in this example, will be a Coordinated Replicat. 

    GGSCI> ADD REPLICAT repnm, COORDINATED, EXTTRAIL ./dirdat/ep, CHECKPOINTTABLE ggadmin.oggcheck

  6. Start the Replicat.