Add a Replicat

Before you add a Replicat, make sure that the following settings are configured:

You can add Replicats for the target deployment from the Administration Service. After you’ve set up your source and target deployments, you can create and run the Replicat by following these steps:

  1. From the Administration Service home page, click the + (plus) sign next to Replicats to start the Add Replicat wizard.
  2. Select a Replicat type from the Replicat Information screen.

    Note:

    Some Replicat types are only available for certain databases. All Replicat types may not be applicable to your database.

    The types of Replicat are:

    • Parallel Replicat: If you select this option, then select an integrated or non-integrated parallel Replicat.

      • Integrated: This option appears when you select Parallel Replicat.

      • Non-Integrated: This option appears when you select Parallel Replicat.

      Note:

      When configuring parallel Replicat for Sybase, make sure that you upgrade to version 16.0 SP3 PL15 and higher to prevent the Administration Service from disconnecting intermittently.

    • Integrated Replicat

    • Non-integrated Replicat: This option is displayed with heterogeneous or non-Oracle databases.

    • Coordinated Replicat

    Select the type of Replicat and specify the following:

    • Process Name: The name of the Replicat process. For coordinated and parallel Replicats, the limit is 5 characters.

    • Description: Describes the Replicat process, text that can be entered and is longer than 5 or 8 characters to identify this process.

  3. Click Next. The Replicat Options screen is displayed.
  4. On the Replicat Options screen, specify the following:
    Replicat Options Screen Description

    Trail Name

    A two character trail name.

    Trail Subdirectory

    Where you want the trail information to be stored or the name of the log file. The default trail file location is the Oracle GoldenGate Data Home.

    Encryption Profile

    List of the available encryption profiles. If you have not created an encryption profile, then the Local Wallet profile would be selected, by default.

    Credential Domain

    Select a domain for the target endpoint.

    Alias

    Select an alias for the target database.

    Checkpoint Table

    Set the use of an existing checkpoint table.

    Begin
    From where you want the Replicat to start. The following three options are available:

    • Position in Log

    • Now

    • Custom Time

    Now is the default option.

    Custom Time

    The Date and Timezone options appear when you select the Custom Time option from the Begin drop-down list.

    Specify the date and timezone as per your requirement, for Replicat to start.

    Transaction Log Sequence Number

    Set the log file number of the log file that contains the START TRANSACTION record for the transaction you are creating.

    Transaction Log RBA Offset

    Set the record offset of the log file you specified.

    Max Threads Number

    Valid for Coordinated Replicat.

    Set a hard limit for the maximum number of active threads that can run simultaneously or use the 25 threads default.
  5. Click Next. The Managed Options screen is displayed.
  6. On the Managed Options screen, specify the following options:
    Option Description

    Profile Name

    Provides the name of the autostart and autorestart profile. You can select the default or custom options.

    If you have already created a profile, then you can select that profile also. If you select the Custom option, then you can set up a new profile from this section itself.

    Critical to deployment health

    (Oracle only) Enable this option if the profile is critical for the deployment health.

    Note:

    This option only appears while creating the Extract or Replicat and not when you set up the managed processes in the Profiles page.

    Auto Start

    Enables autostart for the process

    Startup Delay

    Time to wait in seconds before starting the process

    Auto Restart

    Configures how to restart the process if it terminates

    Max Retries

    Specify the maximum number of retries to try to start the process

    Retry Delay

    Delay time in trying to start the process

    Retries Window

    The duration interval to try to start the process

    Restart on Failure only

    If true, the task is only restarted if it fails.

    Disable Task After Retries Exhausted

    If true, then the task is disabled after exhausting all attempts to restart the process.
  7. Click Next. The Parameter File screen is displayed.
  8. On the Parameters File screen, enter the basic parameters for setting up a Replicat. By default, the Parameter File text contains some parameters, which can be customized as required.
    REPLICAT repe 
USERIDALIAS ggwest DOMAIN OracleGoldenGate 
DDL INCLUDE MAPPED 
DDLERROR default discard 
REPERROR (default,discard) 
DDLOPTIONS REPORT 
SOURCECATALOG DBEAST 
MAP hr.*, TARGET hr.*;
  9. Click Create and Run to start the Replicat after adding it. Click Create to simply add the Replicat but not start it immediately after being created.