Add a Replicat for Oracle AI Database

A Replicat is a process that delivers data to a target database or technology. It reads the trail file on the target, reconstructs the DML or DDL operations, and then applies them to the target. Learn to add a Replicat for Oracle AI Database, Oracle Autonomous AI Database, Oracle Exadata, and Amazon RDS for Oracle technologies.

Instructions are available for GoldenGate 26ai and 21c deployment versions. Ensure that you follow the appropriate instructions for your deployment version.

Add a Replicat (26ai)

Before you begin

Ensure that you add a Checkpoint table for the Replicat to restart without recapturing reapplying transactions should a disruption occur.

In the OCI GoldenGate deployment console navigation menu, expand DB Connections, and select your target database.
Select Add Checkpoint (plus icon).
For Checkpoint Table, enter the target schema name, and then select Submit.

Add the Replicat

In the OCI GoldenGate deployment console navigation menu, select Replicats.
On the Replicats page, select Add Replicat.
The Add Replicat form consists of four pages. Complete the form as needed:
1. On the Replicat Information page:
  1. Select a Replicat Type, then select Next:
    - Parallel Replicat
      - If selected, select a Parallel Replicat Type, either Nonintegrated or Integrated.
    - Integrated Replicat
    - Nonintegrated Replicat
    - Coordinated Replicat
  2. Enter a Process Name, no more than 5 characters long.
  3. Enter a Description, to help distinguish this process from others.
2. On the Replicat Options page, complete the fields as needed, and then select Next:
  - Replicat Trail:
    - Enter a Name.
    - Enter a Subdirectory, if you expect the Trail file to be in a location other than the default.
    - Select an Encryption profile. If an encryption profile wasn't created, the Local Wallet is selected by default.
  - Target Credentials:
    - Select a Domain.
    - Select an Alias within the specified Domain.
    - Select a Checkpoint Table. Leave the default selection or select the checkpoint table you created for the target deployment.
    - Select the Max Threads Number (Coordinated Replicats only).
  - For Begin, select the starting point for data processing:
    - Position in Log (default)
    - Now
    - Custom Time
  - Trail Position:
    - Enter the Sequence Number.
    - Enter the RBA Offset.
3. On the Managed Options page, complete the optional fields as needed, and then select Next:
  - Select a Profile Name.
  - Enable Critical to deployment health.
4. On the Parameter File page, you can add parameters to further configure your Replicat. For example:
```
table source.table1;
```
Note:

GoldenGate uses Greenwich Mean Time (GMT) by default. Use SETENV to override the default setting for the Replicat. This change doesn’t apply to deployments. For example:
```
setenv (TZ="US/Eastern")
setenv (TZ="GMT+5")
```
Select Create and Run. If you select Create, then you can manually start the Replicat later on the Replicats page.

Add a Replicat (21c)

Before you begin

Create a checkpoint table to ensure the Replicat can restart without reapplying transactions should a disruption occur.

In the OCI GoldenGate deployment console navigation menu, select Configuration.
On the Database tab, select the database connect icon for the target database.
Select Add Checkpoint (plus icon).
For Checkpoint Table, enter the target schema name, and then select Submit.

Add the Replicat

In the OCI GoldenGate deployment console, on the Administration Service Overview page, select Add Replicat (plus icon).
On the Add Replicat page, select a Replicat type, and then select Next.
- Parallel Replicat
- Integrated Replicat
- Coordinated Replicat
- Classic Replicat
For more information about the different Replicat types, see Types of Replicat.
On the Replicat Options page, complete the following fields, and then select Next:
1. For Process Name, enter a name for the Replicat process.
2. (Optional) For Description, enter a brief description to distinguish this Replicat from others.
3. For Intent, select the Replicat's purpose:
  - High Availability
  - Disaster Recovery
  - Unidirectional (default)
  - N-Way
4. For Credential Domain and Credential Alias, select the target database domain and alias, or create a new credential.
5. For Source, select the source of data to process, either Trail or File.
6. If the source is Trail, then for Trail Name, enter the name of the Extract trail.
7. If the source is Trail and you expect the trail file to be in a location other than the default, then enter the location for Trail Subdirectory.
8. For Begin, select the starting point for data processing:
  - Position in Log
  - Now
  - Custom Time
9. For Transaction Log Sequence Number, leave the default value or enter a transaction log sequence number.
10. For Transaction Log RBA Offset, leave the default value or enter an offset value.
11. For Checkpoint Table, leave the default selection or select the checkpoint table you created for the target deployment.
Under Encryption Profile, select a profile name. If an encryption profile wasn't created, the Local Wallet is selected by default.
1. Encryption Profile Type
2. Masterkey Name
Under Managed Options, select Critical to deployment health, and then completed the other fields as needed.
Select Next.
On the Parameter File page, you can specify parameters to further configure your Replicat.
```
table source.table1;
```
Note:

GoldenGate uses Greenwich Mean Time (GMT) by default. Use SETENV to override the default setting for the Replicat. This change doesn’t apply to deployments. For example:
```
setenv (TZ="US/Eastern")
setenv (TZ="GMT+5")
```
Select Create and Run. If you select Create, then you can manually start the Replicat later from the Administration Service Overview page.

You return to the Administration Service Overview page where you can view the creation of the Replicat process and access Replicat Actions.