Oracle Cloud Infrastructure Documentation

Use Oracle GoldenGate to Replicate Data with Autonomous Database

You can replicate data to Autonomous Database using Oracle GoldenGate and Oracle GoldenGate Cloud Service. You can capture changes from the Autonomous Database and replicate to any target database or platform that Oracle GoldenGate supports, including other Autonomous Database on Dedicated Exadata Infrastructures.

Oracle GoldenGate offers efficient data replication solutions in multiple scenarios, some of which are listed below:
  • Data migration to or between Autonomous Databases
  • Real-time data capture and replication to support:
    • Scalable active-active architecture
    • Real-time data warehouse
    • Big data integration
    • Real-time streaming analytics
Depending on whether your Autonomous Database is configured as the source database (extract) or target database (replicat) in the data replication setup, you will have to perform one or more tasks listed below:
  • Unlock the GGADMIN account: GGADMIN is a pre-created Oracle GoldenGate database user in Autonomous Database. This account is used for both Extracts and Replicats in the Autonomous Database and must be unlocked before configuring data replication with Oracle GoldenGate. For more details, see Establishing Oracle GoldenGate Credentials.
  • Configure Extract to capture from an Autonomous Database: This is required only if you want to use Autonomous Database as the source database in the data replication activity. For complete details, see Configuring Extract to Capture from an Autonomous Database.
    Note

    GoldenGate capture support is available on autonomous container databases running version 19.11 or higher.
  • Configure Replicat to apply to an Autonomous Database: This is required only if you want to use Autonomous Database as the target database in the data replication activity. For complete details, see Configuring Replicat to Apply to an Autonomous Database.
    Parallel Replicat is a variant of Replicat that applies transactions in parallel to improve performance. Autonomous Database supports Parallel Replicat in integrated mode, that is, you can also create (or add) and configure parallel replication in your environment. See Using Parallel Replicat for more information.
    Note

    Parallel Replicat is not supported for overprovisioned Autonomous Databases, that is, databases provisioned with fractional OCPUs (less than 1 OCPU).

Tip:

For a "Try it out" alternative that demonstrates live migration to Autonomous Database using Oracle Goldengate replication, run Lab 10: Oracle GoldenGate Replication in the Oracle Autonomous Database Dedicated for Fleet Administrators Workshop.