Oracle Database Migration Methods :On-Prem to OCI

Build On-Prem VM / Database & follow same techniques to Migrate DB to IaaS based Cloud Services for AWS(EC2)/Azure/GCP

Created by: Kshitij Joy (Cloud Alchemy)
Oracle Certified Master(OCM) & Oracle Cloud Architect

What Will I Learn?

• How to Choose a Migration Method ?
• What is Endianness ?
• What are Database Character Sets ?
• What is Oracle Data Transfer Appliance
• Install VirtualBox
• Install & Configure Vagrant
• Provision a VM using Vagrant
• Install Oracle 18c XE on VM
• Setup Database & Sample Schemas
• Create a new Compartment in OCI
• Create a VCN in OCI
• Provision a Database in OCI Db System
• Setup SSH Connectivity between On-Prem & OCI DB System
• Oracle Database Migration Methods
• Data Pump Conventional Export/Import
• Data Pump Transportable Tablespace
• Data Pump Full Transportable
• RMAN CONVERT Transportable Tablespace with Data Pump
• RMAN Cross-Platform Transportable PDB
• RMAN Cross-Platform Transportable PDB (Inconsistent Backups)
• RMAN Restore using Oracle Cloud Backup Module
• Unplugging/Plugging (CDB)
• SQL Developer to Migrate Selected Objects
• Provision an AWS RDS Database
• Discuss AWS DMS
• Create Replication Instance
• Create Data Migration Task

Requirements

• Oracle DBA's / Developers / DevOps

Target audience

• Beginner to the World of Cloud Computing & Any Experienced DBA's / Developers looking to get Understanding around Oracle Database Migration Techniques