2 Getting Started with Oracle Cloud Marketplace

This chapter provides an introduction to Oracle GoldenGate on the Oracle Cloud Marketplace.

Topics:

2.1 Overview

Oracle GoldenGate on Oracle Cloud Marketplace is the cloud based version of Oracle GoldenGate and provides the same benefits, scalability, security, and robustness that you can rely on for enterprise replication.

2.2 Resources

The Oracle GoldenGate image on Oracle Cloud Marketplace contains the latest Oracle GoldenGate release that is available at the time of provisioning an instance.

The Oracle GoldenGate software is installed on the compute node under the /u01/app directory.

Supported Compute Shapes

Oracle GoldenGate runs on different OCI Compute Sizes. The following table provides details on the supported OCI Compute Sizes:

Compute Shape OCPU Memory (GB) Max Network Bandwidth
VM.Standard2.1 1 15 1 Gbps
VM.Standard2.4 4 60 4.1 Gbps
VM.Standard2.8 8 160 8.2 Gbps
VM.Standard2.16 16 240 16.4 Gbps
VM.Standard2.24 24 320 24.6 Gbps

For pricing details on compute nodes, please refer to OCI Pricing.

Block Storage

The following table provides details on the default block storage configuration used by Oracle GoldenGate on Oracle Cloud Marketplace.

Volume Default Size Configurable
Boot 50GB Yes
Swap 256GB Yes
Trail 512GB Yes
Deployments 128GB Yes
Cache Manager 128GB Yes

For pricing details on block storage, please refer to Oracle Storage Cloud Pricing.

2.3 Cross Cloud Functionality

Oracle GoldenGate is designed for large scale, cloud based architectures and Oracle GoldenGate on Oracle Cloud Marketplace is a key to many cloud-based solutions. By using Oracle GoldenGate from the Oracle Cloud Marketplace, you can replicate data from on premise to the Oracle Cloud, between data points within the Oracle Cloud, or even between third party clouds.

Network Recommendations

The network recommendations listed here primarlily apply for Oracle to Oracle replication, but the general rules apply to all platforms supported by Oracle GoldenGate. This applies to Oracle GoldenGate on-premise, in 3rd party clouds, in the Oracle cloud, and OCI-GoldenGate.

  • For Capture: If you run Oracle GoldenGate remotely (on a separate server from the database that Oracle GoldenGate is capturing from), then the round trip ping time must be less than 80ms. For Integrated Extract, only the changes to tables that are being captured are sent to the Extract process itself.
  • For Replicat: If you run Oracle GoldenGate remotely (on a separate server from the database that Oracle GoldenGate is applying changes to) then the round trip ping time must be less than 5ms.
  • For Oracle GoldenGate to Oracle GoldenGate communication: The Oracle GoldenGate trail files grows at about 30-40% of the generated redo log volume (if you are capturing 100% of the data). That means that Oracle GoldenGate sends about 30-40% of the generated redo log volume across the network. If the network is not able to scale to this volume, then you can enable compression on the trail file data being sent across the network. This compression can typically achieve 8:1 compression ratios or better. You can also modify the TCP window socket size and buffers as well.

The following table provides a matrix on cross cloud support for replication by using Oracle GoldenGate on the Oracle Cloud Marketplace:

Table 2-1 GoldenGate Cross-Cloud Support

Technology Remote Capture Remote Apply

Oracle Cloud

Yes

Yes

Amazon Web Services (AWS)

Yes

Yes

Microsoft Azure

Yes

Yes