Replicate data between cloud databases in different regions with VCN peering

Oracle Cloud Infrastructure GoldenGate enables you to replicate data in supported OCI databases located in different regions with private endpoints. This example demonstrates how to connect OCI GoldenGate in Phoenix (Region A) to an Autonomous AI Database instance in Frankfurt (Region B) with a private endpoint.

You must have the following in order to proceed:

• An existing source database in one region (Region A)
• An existing target database in a different region (Region B)
• Both should only allow private network connectivity
• An existing Dynamic Routing Gateway (DRG)

1. In Region A, create a VCN (VCN A) with two regional subnets:
   • Public (10.0.0.0/24)
   • Private (10.0.1.0/24)
   1. On the VCN A Details page, click Gateways.
   2. Under Dynamic Routing Gateway Attachments, click Create DRG Attachment
   3. In the Create DRG Attachment panel, enter a name and select a location, and then click Create DRG Attachment.
   4. In the DRG Attachments list, click the DRG name you created. You're brought to the DRG Details page.
   5. On the DRG details page, click the DRG name, and then click Attachments.
   6. Under Remote peering connection attachments, click Create remote peering connection.
   7. In the Create remote peering connection panel, enter a name, leave the default settings as is, and then click Create remote peering connection. An RPC attachment is automatically added to the DRG and its peering status set to New (not peered).
   8. In the Remote peering connections attachments list, select the RPC you created.
   9. On the RPC Details page, for OCID, click Copy.
      Note
      
      You can temporarily paste the OCID to a text editor for later use.
2. Repeat the previous step in Region B to create a VCN (VCN B) with two regional subnets and DRG:
   • Public (192.168.0.0/24)
   • Private (192.168.1.0/24)
3. On Region B's RPC Details page, click the RPC name, and then click Establish Connection.
4. In the Establish connection panel, select Region A, and then paste Region A's RPC OCID. The Peer Status is then set to Peered.
5. On VCN A's Details page, click Routing, and then click route table for private subnet-<VCN Name>.
6. Click Add Route Rules.
7. In the Add Route Rules panel, complete the following fields, and then click Add Route Rules:
   1. Target Type: Dynamic Routing Gateway
   2. Destination CIDR Block: 192.168.1.0/24
8. On VCN B's Details page, under Resources, click Security Lists, and then click security list for private subnet-<VCN Name>.
9. Click Add Ingress Rules.
10. In the Add Ingress Rules dialog, complete the following fields and then click Add Ingress Rules:
    1. Source Type: CIDR
    2. Source CIDR: 10.0.1.0/24
    3. IP Protocol: TCP
    4. Source Port Range: All
    5. Destination Port Range: 1522
       Note
       
       This is the default port to access Oracle Autonomous Database (ADB) instances.
11. On VCN B's Details page, under Resources, click Route Tables, and then click route table for private subnet-<VCN Name>.
12. Click Add Route Rules.
13. In the Add Route Rules panel, complete the following fields and then click Add Route Rules:
    1. Target Type: Dynamic Routing Gateway
    2. Destination CIDR: 10.0.1.0/24

1. Create connections for the source and target databases.
   Note
   
   Ensure that:

   • You select 'Dedicated endpoint' for Traffic routing method.
   • Ensure that the domain used by the FQDN provided in the connection string or wallet is being correctly forwarded to the appropriate DNS Resolver using its Rules. See Resolver Rules for more information.
2. Assign the connections to the deployment created in Task 2.

1. Navigate back to the Deployments page, and then select the deployment you created in Task 2.
2. On the Deployment details page, click Launch console.
3. Log in to the OCI GoldenGate deployment console
4. Add transaction information and a a checkpoint table.
5. Add and run an Extract.
6. Add and run a Replicat.

1. Monitor the replication process.
2. Manage Trail files.

• Remote VCN Peering using an RPC
• Private DNS Implementation
• VCN Peering for ADBs with Private Endpoints and Cross-Region Autonomous Data Guard