Oracle Cloud Infrastructure Documentation

Add a Replicat for Autonomous Database

Learn to add a Replicat for Autonomous Database targets.

Note

For update intensive workloads, the Big Data Autonomous Database Replicat uses the stage and merge flow. For low latency requirements and more comprehensive data type support, Oracle recommends using an Oracle GoldenGate deployment. Learn more about GoldenGate data ingest for Autonomous Data Warehouse.

Add a Replicat (23ai)

Before you add and run a Replicat, ensure that you first review details specific to this target type.
To add a Replicat for Autonomous Database:
  1. In the OCI GoldenGate deployment console, on the Administration Service Home page, click Add Replicat (plus icon).
  2. 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.
  3. 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.
      • For Target, select Autonomous Data Warehouse 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).
  4. 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.
  5. 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")
  6. On the Properties File page, set values for each property marked #TODO, as needed.
    For information on this target's properties, see OCI Autonomous Data Warehouse in the Oracle GoldenGate for Distributed Applications and Analytics guide.
  7. 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 Autonomous Database:
  1. In the OCI GoldenGate deployment console, on the Administration Service Overview page, click Add Replicat (plus icon).
  2. 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.
  3. On the Replicat Options page, complete the following fields, and then click 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.
  4. 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
  5. Under Managed Options, select Critical to deployment health, and then completed the other fields as needed.
  6. Click Next.
  7. On the Parameter File page, you can specify parameters to further configure your Replicat.
    table source.table1;
    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:
      setenv (TZ="US/Eastern")
setenv (TZ="GMT+5")

      Learn more about SETENV.

  8. Click Create and Run. If you click 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.