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:
Classic 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.
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.
Select your Target from the dropdown.
Note:
Depending on your target
selection, you may have additional options to such as Streaming, Stage and
Merge, and Staging locations.
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).
On the Managed Options page, complete the optional fields as
needed, and then click Next:
Select a Profile Name, if one is available.
Enable Critical to deployment health.
Enable and configure Auto Start settings.
On the Parameter File page, you can add parameters to further
configure your Replicat. For example:
table source.table1;
If using Coordinated Replicat,
add TARGETDB LIBFILE libggjava.so SET
property=/u02/Deployment/etc/conf/ogg/your_replicat_name.properties to the
parameters file.
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")
On the Properties File page, configure the following Azure Data Lake Storage properties:
Required property:
For
gg.eventhandler.abs.bucketMappingTemplate: provide
the Azure Data Lake Storage container name. If container is
pre-configured, a static container name can be provided. If Azure
authentication method permissions are provided, then OCI GoldenGate can use Template Keywords
to auto create the container.
(Optional) Additional properties you may consider adding:
(Optional) gg.handler.abs.format: Select
how to format the output. JSON is the default setting. Available options
include:
For information on this target's properties, see Azure Blob Storage in the
Oracle GoldenGate for Distributed Applications and Analytics
guide.
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)
To add a Replicat for an Azure Data Lake Storage target in Oracle
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 types of Replicats are:
Classic Replicat
Coordinated 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 Trail Name, enter two-character trail name.
For Target, select Azure Data Lake
Storage from the dropdown.
For Alias, select the Azure Data Lake Storage connection.
On the Parameter File page, add and configure Replicat parameters as
needed, and then click Next.
Note:
If using Coordinated Replicat, add the following parameters on the
second line of the Parameter
File:
TARGETDB LIBFILE libggjava.so SET property=/u02/Deployment/etc/conf/ogg/<replicat
name>.properties
Using
coordinated replicat will result in multiple files created.
If
omitted, you will encounter the following
error:
OGG-01091 Oracle GoldenGate Delivery, RSNOW.prm: Unable to open file
"/u02/Deployment/etc/conf/ogg/<replicat name>001.properties" (error 2, No such file or
directory).
GoldenGate uses Greenwich Mean Time (GMT) by default. Use SETENV to
override the default setting. For
example:
On the Properties File page, configure the following Azure Data Lake Storage properties:
Required property:
For
gg.eventhandler.abs.bucketMappingTemplate: provide
the Azure Data Lake Storage container name. If container is
pre-configured, a static container name can be provided. If Azure
authentication method permissions are provided, then OCI GoldenGate can use Template Keywords to auto
create the container.
(Optional) Additional properties you may consider adding:
gg.handler.abs.format: Select how to
format the output. JSON is the default setting. Available options
include: