Replicate Data Using Oracle GoldenGate
You can replicate data to Autonomous AI Database using Oracle GoldenGate and Oracle GoldenGate Cloud Service. You can capture changes from the Autonomous AI Database and replicate to any target database or platform that Oracle GoldenGate supports, including other Autonomous AI Database on Dedicated Exadata Infrastructures.
Note: Backups must be enabled on the source Autonomous Container Database to guarantee that all source operations are properly recorded in the redo logs. If backups are not enabled, NOLOGGING operations may not be captured by Oracle GoldenGate, which can lead to data loss or data inconsistency on the target system.
Additionally, configure a backup retention period that allows archived redo logs to be restored from backup if they are removed from the database file system due to space constraints.
Oracle GoldenGate offers efficient data replication solutions in multiple scenarios, some of which are listed below:
-
Data migration to or between Autonomous AI Databases
-
Real-time data capture and replication to support:
-
Scalable active-active architecture
-
Real-time data warehouse
-
Big data integration
-
Real-time streaming analytics
-
Tip: For a “Try it out” alternative that demonstrates live migration to Autonomous AI Database using Oracle Goldengate replication, run Lab 10: Oracle GoldenGate Replication in the Oracle Autonomous AI Database Dedicated for Fleet Administrators Workshop.
Depending on whether your Autonomous AI 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:
GGADMINis a pre-created Oracle GoldenGate database user in Autonomous AI Database. This account is used for both Extracts and Replicats in the Autonomous AI 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 AI Database: This is required only if you want to use Autonomous AI Database as the source database in the data replication activity. For complete details, see Configuring Extract to Capture from an Autonomous AI Database.
-
Configure Replicat to apply to an Autonomous AI Database: This is required only if you want to use Autonomous AI Database as the target database in the data replication activity. For complete details, see Configuring Replicat to Apply to an Autonomous AI Database. Parallel Replicat is a variant of Replicat that applies transactions in parallel to improve performance. Autonomous AI 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 AI Databases, that is, databases provisioned with fractional OCPUs (less than 1 OCPU).