Requirements, Prerequisites, and Assumptions

This section outlines specific requirements, prerequisites, and assumptions related to the user of GoldenGate Replication with Oracle Utilities cloud services. Refer to the Oracle Utilities Cloud Services Cloud Service Descriptions document (available from the Oracle Cloud Services Contracts page) for additional details.

Use of GoldenGate Replication requires a subscription to Oracle Utilities Cloud Service, GoldenGate Replication (Part # B110320).

In addition, you must subscribe to the following OCI services:

  • OCI Autonomous Database ATP (Autonomous Transaction Processing), which is the target database into which data is replicated.
  • OCI GoldenGate Service, which provides the replicate and other GoldenGate services and features for maintaining ongoing replication.

The instructions in this chapter assume customer has:

  • An OCI tenancy and administrative privileges in that tenancy.
  • Any other users working on OCI components have been created.

The instructions in this chapter assume a fresh compartment. If you are working in an existing compartment, you may be able to skip some of the steps outlined in the GoldenGate Replication Administration Tasks section.

The instructions in this chapter assume the target compartment is in the same region as the SaaS source environment. If this is not the case and data needs to traverse regions, the customer must create a pass through compartment in the SaaS region and connect it to your other region using remote VCN peering via Remote Peering Connection (RPC) on the Dynamic Routing Gateways (DRG) attached to your VCNs. For more information, see Remote VCN Peering using an RPC.

Once all pre-requisite subscription components are in place, your administrators will work with Oracle to establish secure OCI network connectivity between your target OCI tenancy (which is fully owned and managed by you) and the SaaS tenancy in which your Oracle Utilities Enterprise SaaS service is deployed.

The GoldenGate Replication services are designed to support change data capture and replication of regular, Production/Live Operation transactions. To avoid overloading the replication services and/or causing potentially unrecoverable data de-synchronization situations, you may not perform any high-volume data modification activities which are not part of normal, regular Production (live operate) activities in (or into) the source environment while replication services are active. The following actions may only be performed on a GoldenGate Replication source environment once GoldenGate replication services have been disabled, and with the understanding (and acceptance) that these actions will invalidate the ongoing replication and will require full re-establishment of replication services via the source export/initial load process (which has a usage limit; please refer to the service description):

  • Data migration/conversion
  • Bulk test data inserts or updates via any provided import tools (such as Content Migration Assistant, or SQL Loader)

    Note:

    Configuration (admin and master data) loads via CMA are not considered bulk data.
  • Table truncation
  • Factory Reset
  • Data copy or clone
  • Any other bulk data or destructive environment management operation which would not normally be performed on a production environment during live operation.

Furthermore, performing a data copy or clone into a GoldenGate Replication source environment invalidates the GoldenGate Replication configuration from an infrastructure/network connectivity standpoint. As this means that Oracle will need to perform re-configuration of the Named Distribution Path, such an activity is deemed a request to "change the Source Environment for a Named Distribution Path" (which has an additional usage limit; please refer to the service description).

Target Environment Sizing Recommendations

The following are minimum sizing recommendations for Target Environments:

  • Database – Autonomous Database
    • Single Database
    • Transaction Processing & Mixed (ATP)
    • 4 Peak ECPUs
    • Autoscale ON
    • Database and backup storage as required
  • OCI GoldenGate
    • 2-4 OCPUs
    • Autoscale ON