Migrate MongoDB to Oracle Database with zero downtime
Discover how to use OCI GoldenGate to MongoDB to Oracle Database with zero downtime.
OCI GoldenGate Big Data supports migrations from MongoDB and MongoDB Atlas to Oracle Autonomous JSON Database, Oracle Autonomous Database and Oracle Database with zero downtime. Autonomous JSON Database and Oracle Autonomous Database come with preconfigured Oracle API for MongoDB connection strings that OCI GoldenGate uses to connect to target Oracle Database systems. Refer to Using Oracle Database API for MongoDB for more information. If your target is an on-premise Oracle Database, you can use Oracle Rest Data Services to enable Oracle Database API for MongoDB with your on-premise Oracle 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.