About Oracle Cloud Marketplace
On Oracle Cloud Marketplace, you can find value-added applications and services that complement your existing Oracle Cloud solutions.
Resources
The Oracle GoldenGate Maximum Availability Hub image on Oracle Cloud Marketplace contains the latest Oracle GoldenGate 21c release that is available at the time of provisioning an instance.
The primary and secondary Oracle GoldenGate software
is installed on the compute node under the /u01/app/oracle/goldengate/gg21c
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) |
|---|---|---|
| VM.Standard2.1 | 1 | 15 |
| VM.Standard2.4 | 4 | 60 |
| VM.Standard2.8 | 8 | 160 |
| VM.Standard2.16 | 16 | 240 |
| VM.Standard2.24 | 24 | 320 |
| VM.Standard3.Flex | 32 | 512 GB |
| VM.Standard.E4.Flex | 64 | 1024 GB |
| VM.Standard.E5.Flex | 64 | 1024 GB |
For pricing details on compute nodes, please refer to OCI Pricing. For more information about OCPU, memory, and network bandwidth for extended memory VM shapes, see Extended Memory VM Instances.
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 | 200GB | No |
| Swap | 256GB | Yes |
| Deployments | 1024GB | Yes |
For pricing details on block storage, please refer to Oracle Storage Cloud Pricing.
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 1-1 GoldenGate Cross-Cloud Support
| Technology | Remote Capture | Remote Apply |
|---|---|---|
|
Oracle Cloud |
Yes |
Yes |
|
Amazon Web Services (AWS) |
Yes |
Yes |
|
Microsoft Azure |
Yes |
Yes |