ZDM and How we Migrated to OCI in 6 weeks

29 Jun ZDM and How we Migrated to OCI in 6 weeks

Migrating an on-premise database to the cloud within a limited timeframe can be a challenging endeavour. I had a High Ed client that put us to the challenge of migrating their Dev/QA and Prod environments to an Exadata Cloud@Customer (ExaCC) environment in under six weeks. In this blog post, I’ll talk a couple of points on how Oracle ZDM enabled this swift transition. 

• Architecting the solution

Architecting the Exadata Cloud@Customer (ExaCC) VMs prior to the arrival of the hardware was one of the most critical pieces of this migration. By carefully designing the migration architecture, we anticipated potential challenges, optimized the migration process, and by doing this, minimize downtime.

This involved factors such as network connectivity, storage configurations, and application dependencies. 

• Install and Configure ZDM Environment

The second thing we needed to do was prior to the arrival of the ExaCC, is to prepare the ZDM environment. You can download ZDM here. Once downloaded we configured the ZDM environment by providing the necessary details such as the source and target database connection information, network configurations, and authentication credentials. This includes setting up the ZDM configuration file with the appropriate parameters, we could already do this as we had architected the VMs prior to this.

• Configure Source and Target Environment

We had to ensure the source database is configured correctly and accessible to ZDM. Set up the required connectivity and permissions for ZDM to capture data changes from the source database. We also had to configure the necessary networking, storage, and authentication settings to establish connectivity between ZDM and the target environment, as well as provision a shell database in the ExaCC. Last but not least, we had to verify the connectivity between ZDM, the source database, and the target environment.

• Pre-Migration Tasks

As the timeframe of this migration was short, we made sure that we captured the SQL Tuning Sets (STS) on the on-prem environment so that in case any execution plan regressed, we could use SQL Plan Management to allow us to stabilize the system. From the migration stand point, ZDM is equipped with pre-migration assessment capabilities. It performs an analysis of the on-premise database, and identifying potential migration challenges. This evaluation helped us identify potential issues prior to the execution of the migration, like identifying the difference of patches between on-prem and ExaCC, or that the on-prem environment had a different compatible parameter for the version it was using.

• Start the Migration

Once the pre-migration is validated, we initiated the migration process by executing the appropriate ZDM commands.We made sure to monitor the progress of the migration and address any issues or errors that may arise during the migration process. 

• Perform Post-Migration Validations
  After the migration completed, we conducted post-migration validations to ensure the migrated database is fully functional and performing as expected. Making use of the previously captured STS to stabilize the system and make this a successful migration.

Migrating an on-prem database to an ExaCC in under six weeks can seem like an ambitious goal. However, Oracle ZDM empowered us to plan and achieve this objective with confidence and efficiency. By automating the database conversion, enabling near zero-downtime for this particular client, and providing validation capabilities, ZDM allowed us to  perform a seamless transition within the desired timeframe. I can say with confidence that ZDM helped us to accelerate the migration journey and enables our client to quickly leverage the benefits of the ExaCC. I will say, embrace Oracle ZDM and expedite your on-premise to ExaCC migration today.