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 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…
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…
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…
Database Heartbeat 