14 Oracle DB Migration Methods That Can Boost Your Career

Learn all the must know methods for migrating On Premise Oracle Database to AWS and TAKE YOUR CAREER TO NEXT LEVEL

What you’ll learn

  • Oracle Database Migration From On-Premise Servers To AWS Cloud.
  • AWS RDS.
  • Oracle Database on AWS.
  • Oracle Database 19c Administration.

Course Content

  • Introduction –> 2 lectures • 8min.
  • Configuring Enviornment To Practise –> 7 lectures • 1hr 7min.
  • Configuring AWS CLI –> 3 lectures • 11min.
  • Uploading Files To AWS EC2 Instance –> 2 lectures • 30min.
  • Database Migration Using SQL Developer –> 2 lectures • 22min.
  • Databasse Migration Using Data Pump : Conventional Method –> 5 lectures • 18min.
  • Database Migration Using Transportable Tablespace –> 3 lectures • 18min.
  • Database Migration Using RMAN Convert Tablespace With Data Pump –> 3 lectures • 22min.
  • Database Migration Using Full Transportable Export and Import –> 3 lectures • 27min.
  • Migration Using Rman Transport Tablespace –> 3 lectures • 22min.
  • PDB Migration To AWS Using Unplugging and Plugging –> 2 lectures • 21min.
  • RMAN Cross Platform Transportable PDB –> 2 lectures • 12min.
  • Database Migration Using Oracle Golden Gate –> 16 lectures • 1hr 44min.
  • Database Migration Using Oracle Data Guard –> 11 lectures • 1hr 10min.
  • Migration To RDS Using Data Pump –> 8 lectures • 42min.
  • Migration To RDS Using S3 Buckets and Data Pump –> 2 lectures • 23min.
  • Migration To RDS Using Database Migration Service ( DMS) –> 5 lectures • 35min.
  • Migration To RDS Using Oracle Golden gate –> 8 lectures • 1hr 22min.
  • Bonus –> 1 lecture • 1min.

14 Oracle DB Migration Methods That Can Boost Your Career


  • Experience On Oracle Database Administration.
  • An Enthusiastic Mindset To Learn New Skills.


As per the latest report , by 2025 80% percentage of mission critcial work load will be migrating to

Cloud.This also means that by 2025 , you may have to migrate most of , if not all , your Oracle

database to cloud.


AWS being the pioneer in cloud technology, it will be one of most favourite choice of most companies and

You being Oracle Database Administrator will be responsible for migrating your client database to AWS Cloud


This course will helping you in this migration process. In this course I have covered all the tools and methods

you should know for migrating on-premise database to AWS


You will be learning the following


  • Oracle database in AWS
  • Difference between Database on EC2 and RDS
  • Creation of EC2 Instance
  • Download Oracle Software In EC2 Instance
  • Setting Up SSH Connectivity To EC2 Instance From On-premise
  • Installation Of Oracle Software On EC2
  • Provision of Oracle RDS Database
  • Overview of Migration Methods
  • Choosing the best migration method
  • Understanding Endian and its impact on Migration
  • Understanding Zero Downtime Migration

You will be mastering the following Migration Methods

  1. Using SQL Developer to Migrate On Premise Database to AWS (Both EC2 and RDS)
  2. Database Migration Using Data pump(Conventional)
  3. Database Migration Using Transportable Tablespace
  4. Database Migration Using Full Transportable Export and Import
  5. Using RMAN CONVERT Transportable Tablespace with Data Pump for migration
  6. RMAN Cross-Platform Transportable PDB
  7. Migration Of PDBS by Unplugging/Plugging
  8. Migration to RDS Using Datapump and DBMS_FILE_TRANSFER
  9. Migration to RDS Using Datapump and S3 bucket
  10. Zero Downtime Migration Using Goldengate
  11. Migration To RDS Using AWS Database Migration Service