Introduction ZDM uses RMAN to perform an offline physical migration. It backs up the source database and instantiates a new database from this backup to the target environment. This is similar to cloning a database. The target database has no relationship to the source, so there is no data synchronization or fallback capability. No SQL*Net…
Introduction ZDM uses Oracle Data Guard to perform an online physical migration. This means: it backs up the source database, instantiates a standby database from this backup to the target environment, configures Data Guard to synchronize the source and target databases, and finally switches over to the target database. ZDM allows you to pause the…
Introduction ZDM version 21c supports logical migrations using Oracle GoldenGate as described in Part 2 or using the classical Data Pump export and import. This blog post provides a step by step instruction how to accordingly configure ZDM for Data Pump export and import with the minimal parameters required. Using Data Pump export and import…
Introduction ZDM version 21.3 supports logical migrations using Oracle GoldenGate. This makes it possible to migrate to Oracle Autonomous Database with zero downtime. This blog post provides step-by-step instructions on how to accordingly configure ZDM with the minimal parameters required. Data Pump will be used to create the initial load and GoldenGate extract and replicate…
Introduction Oracle Zero Downtime Migration (ZDM) is a free-to-use software solution that allows you to automate your Oracle database migrations to Oracle Cloud, Multicloud, and engineered systems on-premises. In this blog post, we will install the ZDM software to be ready to use in the next blog posts that will show each of the migration…
Introduction Oracle Databases on Oracle Cloud are created using the Multitenant architecture. All databases are encrypted using Transparent Data Encryption (TDE) by default. All databases on Exadata, Bare Metal machines, and RAC on Virtual Machines use ASM storage management. For Single Instance databases on Virtual Machine DB systems you have the choice between Logical Volume…
Introduction This is a step by step instruction of the minimum steps needed to import your Data Pump dump files into Oracle Autonomous Database. Without installing anything! Before you export your data, have a look at best practices and what to consider when you migrate to Autonomous Database. Step 0: Upload you Dump Files into…
Introduction Oracle Multitenant architecture makes it possible to effortlessly move PDBs from one CDB to another, even though the source and target CDBs were of different release versions, e.g. 18c and 19c, and even of different editions like moving from SE to EE. In the previous blog we discussed how patching can be done with…
Introduction Oracle Multitenant allows you to clone PDBs from one CDB to another easily, even though the source and target CDBs were of different patch levels, e.g. 19.9 and 19.10, and even different editions like moving from SE to EE. The only thing you’ll need is to run datapatch afterwards. Unplug and Plug the PDB…
You’ll get this message if If you are not familiar with these terms, then let’s discover them by example. Screenshots in gray are from the source, in turquoise from the target database. Download all SQL queries used in this blog and try it out yourself. Source Database For testing, I created a DBCS VM database using the…
Database Heartbeat 