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…
In this part we will introduce the following migration methods using Oracle Data Pump export and import utilities: Data Pump Conventional Export and Import. Data Pump Full Transportable. Data Pump Transportable Tablespace. Data Pump Convert Full Transportable. Data Pump Oracle Data Pump technology enables you to move data and metadata from one database to another.…
In this part, we will introduce the automation tools and Maximum Availability Architecture (MAA) migration methods. Automation Tools Automation is one of the major benefits of migrating workloads to the cloud. Oracle provides different database migration solutions to even automate the migration process to the cloud. MV2ADB (Move to Autonomous Database) MV2ADB is a command-line tool…
In this part, we will discuss the database characteristics and factors that affect choosing a migration method. Some of the migration methods apply only if specific characteristics of the source and destination database match or are compatible. Logical vs. Physical Migrations Logical migration means extracting the database objects and data from the source database and creating…
In this part, we will talk about the different database service offerings and their characteristics in Oracle cloud to help you determine the right service to move to according to your needs and requirements. There is no THE ORACLE DATABASE in the cloud, but many different service offerings that primarily differ in their level of…
In this part, we will talk about the benefits of the Oracle cloud. If someone suggests you should do something, the first thing comes into you mind might be „why should I do that?“, “what’s in for me?” or “what are the benefits of doing that?”. In this blog post, we will discuss the benefits…
Oracle provides different technologies and methods to migrate Oracle databases across platforms. This decision tree is intended to provide an overview of options available to migrate Oracle on-premises databases to Oracle Cloud Database Service (DBCS) or Oracle Autonomous Database. Before making the final decision, review the Oracle documentation for all prerequisites, restrictions, and recommendations. Some…
Database Heartbeat 