What is our primary use case?
Many organizations are moving to cloud for various reasons. Every database migration opportunity comes with a very common challenge, e.g., service downtime. So, companies look for a solution which can help do DB migration with minimal or reduced downtime. Thus, Oracle provides a solution with Zero Downtime Migration (ZDM). It's a software solution that provides a simple, easy, automated procedure to migrate an on-premise Oracle Database to the cloud seamlessly. This has helped migrating on-premise databases.
How has it helped my organization?
Zero Downtime Migration provides a simple, easy automated solution for on-premise Oracle Database migration to Oracle Cloud and Exadata Cloud at Customer (ExaCC). We have used this approach to migrate a couple of our 12c databases to the cloud and managed to reduce the required downtime significantly. This approach provides pause/restart, monitoring, and auditing capabilities to help the migration process.
What is most valuable?
It's a solution offered to migrate on-premise Oracle Database versions from 126.96.36.199, 188.8.131.52, 184.108.40.206, 18c and 19c from the Linux platform to Oracle cloud, including Exadata Cloud at Customer. It uses eight simple steps to automate the process:
- Download and install.
- Launch the DB migration process.
- Establish connectivity between the source to object storage.
- Transfer backup files to object storage.
- Create a standby on the cloud.
- Synchronize data between the primary and standby.
- Perform a switch over and swap of DB roles.
- Complete the migration.
What needs improvement?
For now, it is supported on the Linux platform with the 11gR2, 12cR1, 12cR2, 18c and 19c Oracle Database versions. Oracle should start supporting other operating systems, including Windows, Unix, and other OS platforms. It should also support migration between different DB versions and platforms to have this solution adopted by more companies.
They should provide the interface in GUI along with the CLI. This will simplify configuration and DBAs with little experience could also start using the solution.
For how long have I used the solution?
This is a new database migration solution from Oracle to reduce downtime significantly. I have used it a couple of times in the recent past.
What do I think about the stability of the solution?
It is very controllable and customizable.
What do I think about the scalability of the solution?
Oracle ZDM uses the Maximum Availability Architecture approach and leverages Active Data Guard technologies.
How are customer service and technical support?
There are plenty of supported notes on MOS. Also, Oracle Support is accurate.
Which solution did I use previously and why did I switch?
We did use other methods to migrate databases, data pumps, RMAN backups, and the SQL Developer tool.
How was the initial setup?
You don't need much experience to work on this tool. Installation and setup are pretty easy.
Configuration requires a separate host and a little experience is required for installation. However, the usage is very straightforward.
What about the implementation team?
What was our ROI?
What's my experience with pricing, setup cost, and licensing?
Oracle ZDM comes absolutely free of cost. There is no additional licensing required for use of this software. It is fully automated with controls.
Which other solutions did I evaluate?
Because the procedure is between Oracle databases, only Oracle solutions are preferred.
What other advice do I have?
As specified, it should support other platforms, Windows, Unix, etc.
Which deployment model are you using for this solution?
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?