JavaScript must be enabled to correctly display this content
Add a Replicat for Oracle 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 Database, OCI Autonomous Databases, Oracle Exadata, and Amazon RDS for Oracle technologies.
Instructions are available for GoldenGate 23ai and 21c
deployment versions. Ensure that you follow the
appropriate instructions for your deployment
version.
Add a Replicat (23ai)
Before you begin
Ensure that you add a Checkpoint table for the Replicat to
restart without recapturing reapplying transactions should a discruption
occur.
In the OCI GoldenGate deployment console, expand DB Connections, and select
your target database.
Click Add Checkpoint (plus
icon).
For Checkpoint Table, enter the target
schema name, and then click Submit.
To add a Replicat for Oracle Database in GoldenGate
23ai:
In the OCI GoldenGate deployment console, on the Administration Service Home page, click Add Replicat (plus icon).
In the Add Replicat panel, on the Replicat
Information page, complete the fields as needed, and then click
Next:
Select a Replicat Type:
Parallel Replicat
If selected, select a Parallel Replicat Type,
either Nonintegrated or Integrated.
Integrated Replicat
Nonintegrated Replicat
Coordinated Replicat
Enter a Process Name, no more than 5 characters
long.
Enter a Description, to help distinguish this
process from others.
On the Replicat Options page, complete the fields as needed, and
then click 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.
On the Managed Options page, complete the optional fields as
needed, and then click Next:
Select a Profile Name.
Enable Critical to deployment health.
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 this Replicat process. This change
doesn't apply to deployments. For example:
setenv (TZ="US/Eastern")
setenv (TZ="GMT+5")
Click Create and Run. If you click
Create, then you can manually start the Replicat
later from the Administration Service Home page.
Add a Replicat
(21c)
Before you begin
Before you add a Replicat,
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, click
Configuration.
On the Database tab, click the database
connect icon for the target database.
Click Add Checkpoint (plus icon).
For Checkpoint Table, enter the target schema name, and then click
Submit.
To add a Replicat for Oracle Database in GoldenGate
21c:
In the OCI GoldenGate deployment console, on the Administration Service Overview page, click
Add Replicat (plus icon).
On the Add Replicat page, select a Replicat type, and then click
Next.
The Replicat types are:
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 click Next:
For Process Name, enter a name for the Replicat
process.
(Optional) For Description, enter a brief description to
distinguish this Replicat from others.
For Intent, select the Replicat's purpose:
High Availability
Disaster Recovery
Unidirectional (default)
N-Way
For Credential Domain and Credential
Alias, select the target database domain and alias, or create a new
credential.
For Source, select the source of data to process, either
Trail or File.
If the source is Trail, then for Trail Name, enter the name
of the Extract trail.
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.
For Begin, select the starting point for data
processing:
Position in Log
Now
Custom Time
For Transaction Log Sequence Number, leave the default value
or enter a transaction log sequence number.
For Transaction Log RBA Offset, leave the default value or
enter an offset value.
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.
Encryption Profile Type
Masterkey Name
Under Managed Options, select Critical to deployment
health, and then completed the other fields as needed.
Click 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: