Replicate data between cloud databases in different regions

Learn to set up and configure Oracle Cloud Infrastructure GoldenGate to replicate data between two Autonomous Databases located in different regions.

Related Topics

Overview

Oracle Cloud Infrastructure GoldenGate enables you to replicate data in supported OCI databases located in different regions. The following steps guide you through how to set up and run this replication model.

Description of regiona-regionb.png follows
Description of the illustration regiona-regionb.png

Before you begin

You must have the following in order to complete this quickstart:

  • An existing source database in one region (Region A)
  • An existing target database in different region (Region B)

See what's supported, and in which regions OCI GoldenGate is available.

Task 1: Create the OCI GoldenGate resources

  1. Create deployments in Regions A and B. Ensure that you Enable GoldenGate console public access in the Advanced options.
  2. In Region A (source region), create a connection to the source database.
  3. Assign the source connection to the source deployment in Region A.
  4. In Region B (target region), create a connection to the target database.
  5. Assign the target connection to the target deployment in Region B.
  6. Create a GoldenGate connection in Region A with the target deployment connection details and assign it to the source deployment.

Task 2: Configure the source deployment

  1. In Region A (source region), launch the deployment console from the deployment details page, and log in with the GoldenGate credentials you specified in Task 1.
  2. Add Transaction information.
  3. Add and run an Extract. Ensure that the Extract is running and capturing source changes before proceeding to the next step.
  4. Add a credential that the target OCI GoldenGate deployment can use to connect to the source deployment:
    1. Open the navigation menu and then click Administrator.

      For 23ai, click User Administration in the left navigation.

    2. Click Add User, give the user a name (ggsnet, for example), and then assign the user the Operator role.

Task 3: Configure the target deployment

  1. In Region B (target region), launch the deployment console from the deployment details page, and then log in using the GoldenGate credentials you specified in Task 1.
  2. Add the source GoldenGate credential:
    1. In the navigation menu, click Configuration.

      In 23ai, click DB Admininstration in the left navigation.

    2. On the Credentials page, click Add Credential, and then complete the fields to add the source OCI GoldenGate ggsnet user from Task 2.
    3. Click Submit.
  3. Add and run a Receiver Path with the following values:
    1. Source Authentication Method: UserID Alias
    2. Source Protocol: wss
    3. Source Host: <domain>.deployment.goldengate.<source-region>-1.oci.oraclecloud.com

      Note:

      You can copy and paste the Console URL from the source Deployment Details page and remove the https:// protocol.
    4. Source Port Number: 443
    5. Source Trail Name: Enter the two character source trail name used when you created the Extract
    6. Source Domain: Enter the source OCI GoldenGate user name (ggsnet)
    7. Source Alias: Enter the source OCI GoldenGate alias
    8. Target Trail: Enter a two character trail name for the target trail
  4. Verify that the Receiver Path is created in the target region OCI GoldenGate Deployment Console.

Task 4: Replicate data

  1. On the source deployment console in Region A, verify that the Distribution path was created in the Distribution Service.
  2. Return the target deployment console in Region B, and then add and run a Replicat. The Replicat reads the Trail file created by the Receiver path.
  3. Monitor performance.
  4. Manage Trail files.