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. If using GoldenGate credential store, add a Path Connection that the source deployment can use to connect to the target deployment:
    1. In the navigation menu, click Path Connections.
    2. On the Path Connections, click Add Path Connection (plus icon), and then complete the fields as follows:
      1. For Credential Alias, enter an alias.
      2. For User ID, enter ggsnet.
      3. For Password and Verify Password, enter a password.
    3. Click Submit.

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. If using GoldenGate credential store, create a user with which the source deployment uses to connect to the target deployment:
    1. In the navigation menu, click User Administration.
    2. Click Add New User (plus icon), complete the fields as follows, and then click Submit:
      • For Authenticated By, select Password from the dropdown.
      • For Role, select Operator from the dropdown.
      • For Username, enter a name (ggsnet, for example).
      • For Password, enter the password associated with this user. Verify the password.
  3. Add a Target-initiated Path with the following values:
    1. Source Trail Name: Enter the two character source trail name used when you created the Extract
    2. Target Authentication Method:
      • If using GoldenGate credential store, select UserID Alias.
      • If using IAM credential store, select OAuth.
    3. Target Protocol: wss
    4. Target 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.
    5. Port Number: 443
    6. Domain: Enter the source OCI GoldenGate user name (ggsnet)
    7. Alias: Enter the source OCI GoldenGate alias
    8. Target Trail Name: Enter a two character trail name for the target trail
  4. Verify that the Target-initiated 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 Target-initiated Path.
  3. Monitor performance.
  4. Manage Trail files.