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. 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. The new ZDM version 21c…
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 the Cloud Premigration Advisor Tool (CPAT) First of all, check the database schemas you want to export from the source database using the Cloud…
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…
In this part we will introduce the following migration methods using RMAN: RMAN Transportable Tablespace with Data Pump RMAN Convert Transportable Tablespace with Data Pump RMAN Cross-Platform Transportable Tablespace Backup Sets RMAN Cross-Platform Transportable PDB RMAN Cross-Platform Transportable PDB Inconsistent Backups RMAN Duplicate from an Active Database RMAN Backup & Restore RMAN Oracle Recovery Manager…
Database Heartbeat 