Add a Replicat

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

• Add Database Connections

• Add TRANDATA

• Add a Checkpoint Table

• Add Heartbeat Table

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

1. From the Microservices 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.
{: .infoboxnote}

• 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.

1. Click Next. The Replicat Options screen is displayed.

2. 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. To know more about creating and applying encryption profiles, see Apply the OKV Encryption Profile.
   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.

3. Click Next. The Managed Options screen is displayed.

4. 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.

5. Click Next. The Parameter File screen is displayed.

6. 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.*;

7. 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.