Migrate MongoDB to Oracle AI Database with zero downtime
Discover how to use OCI GoldenGate to MongoDB to Oracle AI Database with zero downtime.
OCI GoldenGate Big Data supports migrations from MongoDB and MongoDB Atlas to the following targets with zero downtime:
- Oracle Autonomous AI JSON Database
- Oracle Autonomous AI Database
- Oracle AI Database
Autonomous AI JSON Database and Autonomous AI Database come with preconfigured Oracle API for MongoDB connection strings that OCI GoldenGate uses to connect to target Oracle AI Database systems. Refer to Using Oracle Database API for MongoDB for more information.
If your target is an on-premise Oracle AI Database, you can use Oracle Rest Data Services to enable Oracle Database API for MongoDB with your on-premise Oracle AI Database.
Before you begin
To successfully complete this quickstart, ensure you have:
- A MongoDB source, version 5 or higher
- Created an OCI GoldenGate Big Data deployment, version 23.7 or higher
- MongoDB Database Tools, including mongodump and mongostore, installed and respective directory paths added to PATH environment variable
Tips
Here are some tips to ensure your migration goes smoothly:
- It's recommended to use
mongodb-database-tools
version 100.10.0 or below. - Before you run
mongodump
, clean up the the existing dump folder to delete inconsistent data. - MongoDB restore: Multiple collections of a database can be replicated
using multiple
--nsInclude
options inmongorestore
command. However, the ORDS multiple databases cannot be restored using mulitple--nsInclude
commands. You must use multiple restore commands, one for each database to be restored.