This post is the third video of our three-part video series on “Zero Downtime Migration On-Premise to Cloud” which is taken from our FREE masterclass.
Note: To join FREE masterclass on Zero Downtime Migration click here
In this blog post, we’ve covered the Live Q/A asked by attendees on Zero Downtime Migration FREE masterclass from On-Premise to the database on the cloud.
Note: If you have missed my first post on ZDM In OCI: Overview & Capability, check out here & If you have missed my previous (Second) post on Zero Downtime Migration (ZDM) Database To Oracle Cloud In 8 Steps click here
(To be the first one to receive Updates on Oracle Cloud, Subscribe to Our Youtube channel)
ZDM FREE Masterclass Q/A
Q)~ Iftikhar: ZDM can be used for On-Premise to On-Premise scenarios meaning no cloud involved?
Ans: No, ZDM is only from On-Premise or OCI-C to Cloud (OCI: BM/VM/ExaCS or Cloud@Customer (ExaCC).
Note: To know the difference between OCI & OCI-C check here
Q) ~ Deepak: Please confirm, ZDM can be used for migration of an on-premise DB to a cloud other than Oracle cloud?
Ans: No, ZDM is only for Oracle to Oracle. If you want to migrate to Other Cloud use other migration tools mentioned in the session.
Q) ~ Andeeas: Can we use ZDM to a cross-platform migration?
Ans: No, as of April 2020, it’s only for Linux to Oracle Cloud on Linux.
Q) ~ Paul: Can we perform migration from 11g source to 19c target?
Ans: No, it’s for same source & target version so 11g to 11g or 19c to 19c.
Note: To know the more about the supported configuration check part one
Q) ~Amila: Will this ZDM migration tool encrypts all the tablespaces encrypted in the target using TDE? Please confirm?
Ans: Yes, TDE is the default in the cloud.
Q) ~ Andeeas: Zero downtime migration is an extra tool and is this licensed?
Ans: No, the tool is FREE to migrate databases from On-Premise or OCI-C to Oracle Cloud or Cloud@Cusotmer (ExaCC).
Note: To know more about the cloud at customer click here
Q) ~ Iftikhar: Is there downtime required and at which stage?
Ans: Yes for a very short duration. During switchover/failover/Cutover when you wish to database on Cloud as Primary Database.
Q) ~ Ramesh: ZDM can convert the ASM filesystem as well from source to target?
Ans: Yes, ZDM will take care of ASM File System
Q) ~ Priyatosh: Can we just migrate the EBS database(No application Migration) to the cloud using ZDM?
Ans: Technically Yes, but EBS Team has not yet supported the ZDM tool for EBS R12 database migration. You use EBS Cloud Manager but you may not be able to achieve ZDM. For almost Zero Downtime Migration using Hybrid Data Guard (same principle as ZDM but with manual steps) to migrate EBS R12 to OCI, check free class here
Q) ~ Paul: Can we practice ZDM on the free oracle cloud account?
Ans: Absolutely Yes, In fact in our training students practice on a Free account. Just take care of Network Connectivity & Bandwidth.
Note: To know how to register Oracle cloud FREE account by using my step-by-step video & guide. Click here to download the guide
Q) ~ Iftikhar: if this ZDM interrupted can we resume it after fixing the or we need to start from the beginning?
Ans: As mentioned in class by Rajeev, it’s based on Oracle’s Fleet Provisioning & Patching (FPP) framework meaning it’s rerunnable, resumable and you can even do a dry run. If there is a network connection break, you’ll be able to continue once the network is back.
Q) ~ Ramanatha: Can ZDM be used for DB upgrade with migrations like 11g to 12c along with DB schema and data?
Ans: ZDM is only for migration and can’t be used for Upgrade or can’t be used for migration from one version to another.
Q) ~ Ramesh: Can we consider Data Pump as ZDM?
Ans: No, ZDM is based on a data guard feature. Data Pump uses Logical Backup & Restore for Migration.
Q) ~ Syed: What is the difference between migration with Data Guard and migration with ZDM?
Ans: Conceptually they are the same but in ZDM oracle is doing all Data Guard tasks for you with some additional features like Pause, Re-Run, Dry Run, etc based on Oracle’s Fleet Provisioning & Patching (FPP) Framework.
Note: To know more about data guards click here
Q) ~ Mangesh: So does ZDM auto-create a standby database? Is this physical or logical Standby?
Ans: Yes, ZDM automatically creates a standby database and it creates a Physical Sandy database.
Q) ~ Andeeas: There is no downtime when you copy your datafiles?
Ans: Correct there is no downtime to copy datafiles (similar to physical standby/data guard setup).
Read this post for an overview of Autonomous Database, Types of Autonomous database (Autonomous data warehouse & Autonomous Transaction Processing) and Autonomous offering as Serverless & Dedicated Infrastructure.
Platform / Pre-requisite related
Q) ~ Iftikhar: if this ZDM interrupted can we resume it after fixing the or we need to start from the beginning?
Ans: As mentioned in class by Rajeev, it’s based on Oracle’s Fleet Provisioning & Patching (FPP) framework meaning it’s rerunnable, resumable and you can even do a dry run. If there is a network connection break, you’ll be able to continue once the network is back.
Q) ~ Karthik: Any tablespace limitations and any prerequisites in the cloud in terms of platform mismatch between source and target cloud?
Ans: Yes, there is a bunch of prereqs that you have to be aware so follow ZDM Migration documentation.
Q) ~ Naresh: if the source is Microsoft SQL server is zero downtime applicable?
Ans: Not using ZDM but you can use Oracle GoldenGate for this use case.
Install & Configure ZDM
Q) ~Stylianou: Where do we install ZDM? On the source database server or on a separate machine?
Ans: Linux 7 or Higher and recommendation is to deploy on a separate server so it doesn’t impact existing Grid Infrastructure or source databases. All you need is connectivity to the source database.
Q) ~Andeeas: Do you have to create any schemas or users on the target database for ZDM?
Ans: No, there is no schema/user creation at source or target. All you need to do is SSH connectivity & TDE wallets for connectivity. The process is similar to what you use for Physical Standby or Data Guard Configuration.
Q) ~Pankaj: What could be the risk to migrate Production through ZDM?
Ans: Risk of using the tool as with any software, this is why recommend testing.
Connect to Object Store
Q) ~PN Reddy: Is it mandatory to have Object storage?
Ans: Yes, if you are migrating to Object Storage. If you are migrating to Exadata Cloud @ Customer (ExaCC) you can also use local NFS or Zero Data Loss Recovery Appliance (ZDLRA).
Note: To know more about the cloud at customer click here
Note: To know more about object storage click here
Related Post
- [Part 1] Zero Downtime Migration In Oracle Cloud Infrastructure (OCI): Overview & Capability
- [Part 2] Zero Downtime Migration (ZDM) Database To Oracle Cloud In 8 Steps
- Oracle Database Migration To Cloud Lift & Shift: Overview & Methodology
- Zero Downtime Migration: Database & Applications To Oracle Cloud Using Hybrid Data Guard
- Migrate Database To Oracle Autonomous Database Cloud Options
Next Task For You
If you want to upgrade your career from an Oracle DBA to Oracle Cloud DBA, and wants to clear Oracle Cloud Database Service Specialist[1Z0-1093-21] & Oracle Cloud Autonomous Database Certification[1Z0-931-21] with 18 Hands-On labs, then register for a FREE class, and don’t miss an opportunity to gain a plethora of insights on becoming a certified Oracle Cloud DBA.
Leave a Reply