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 21c supports logical migrations using Oracle GoldenGate. This makes it possible to migrate to Oracle Autonomous Database with zero downtime. This blog post provides a step by step instruction how to accordingly configure ZDM with the minimal parameters required. Data Pump will be used to create the initial load and GoldenGate extract…
Introduction Oracle Zero Downtime Migration (ZDM) is a free to use software solution that allows you to automate your Oracle database migrations from on-premises to Oracle Cloud. Initially, ZDM supported Data Guard based migrations following the principles of Oracle Maximum Availability Architecture (MAA). To support Standard Edition migrations, ZDM uses RMAN backup and restore instead.…
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…
You’ll get this message if Your source database uses a single-byte character set (e.g. WE8ISO8859P1), and Your column width is defined using BYTE length semantic, and You have some column values that do not fit when using a multi-byte character set (e.g. UTF8) as Autonomous Database does If you are not familiar with these terms,…
Oracle Data Pump enables you to move data and metadata from one database to another, providing an extensive range of benefits. The followings are tips and best practices to consider: 1. Run Autonomous Database Schema Advisor First of all, check the database schemas you want to export from the source database using the Autonomous Database Schema…
In this part, we will summarize all topics in previous parts and introduce a decision tree to help you determine what migration methods are applicable depending on your system characteristics and requirements. Why Move to Oracle Cloud? By running your Oracle databases on Oracle Cloud you benefit from a high degree of automation, simplified management, implementing…
In previous parts, we discussed how to move Oracle databases from on-premise to Oracle Cloud. In this part, we will deal with migrating Oracle databases running on Amazon Web Services (AWS) to Oracle cloud. Why to move to the Oracle cloud? Have a look at part 1 highlighting the benefits of the Oracle cloud. Summarized in one…
In this part we will introduce the following migration tools and methods mostly suitable for moving a small amount of data, a limited number of objects, and data stored in flat files: SQL Developer Database Copy Utility SQL Developer Cart Utility SQL Developer Drag and Drop Option SQL Developer Export and Import Wizard SQL*Loader DBMS_CLOUD COPY_DATA…
In this part we will introduce the following migration methods using Multitenant Architecture: Unplug & Plug Remote Cloning Remote Hot Cloning PDB Refreshable Clone PDB Relocate Multitenant Architecture The multitenant architecture provides easy and powerful features to move databases across platforms, even with just one single SQL command. It’s almost magic! The multitenant option was…
