14 Oracle DB Migration Methods That Can Boost Your Career

Course Curriculum

Chapter 1: Introduction

Lecture 1: Class Notes

Lecture 2: Oracle Database Offering In AWS

Chapter 2: Configuring Enviornment To Practise

Lecture 1: Creating EC2 Instance For Oracle Software Installation

Lecture 2: Mounting EBS Volume To EC2 Instance

Lecture 3: Downloading Oracle Software on EC2 Instance

Lecture 4: Install Oracle Software On EC2 Instance

Lecture 5: Create Oracle Database On EC2 Instance

Lecture 6: Connecting To Database On EC2 Using SQL Developer

Lecture 7: Connecting To EC2 Instance Without the .pem file (Key Pair)

Chapter 3: Configuring AWS CLI

Lecture 1: Download Class Notes

Lecture 2: Configuring AWS CLI In Windows

Lecture 3: Configuring AWS CLI On Linux

Chapter 4: Uploading Files To AWS EC2 Instance

Lecture 1: Uploading Files to EC2 Instance : Concepts

Lecture 2: Uploading Files To EC2 Instance Using SCP

Chapter 5: Database Migration Using SQL Developer

Lecture 1: Installation Of SQL Developer

Lecture 2: Database Migration Using SQL Developer

Chapter 6: Databasse Migration Using Data Pump : Conventional Method

Lecture 1: Download Class Notes

Lecture 2: Database Migration Using Data pump : Concepts

Lecture 3: Taking The Source Database Backup Using Expdp

Lecture 4: Copying Files To EC2 Instance

Lecture 5: Importing Data To Target Database

Chapter 7: Database Migration Using Transportable Tablespace

Lecture 1: Download the Class Notes

Lecture 2: Concepts on Database Migration Using Transportable Tablespace

Lecture 3: Database Migration Using Transportable Tablespace : Practical

Chapter 8: Database Migration Using RMAN Convert Tablespace With Data Pump

Lecture 1: Download Class Notes

Lecture 2: RMAN Convert Transportable Tablespace : Workflow

Lecture 3: RMAN Convert Transportable Tablespace : Practical

Chapter 9: Database Migration Using Full Transportable Export and Import

Lecture 1: Download Class Notes

Lecture 2: Full Transportable Export and Import :Work Fow

Lecture 3: Full Transportable Export and Import : Practical

Chapter 10: Migration Using Rman Transport Tablespace

Lecture 1: Download Class Notes

Lecture 2: RMAN Transport Tablespace : Workflow

Lecture 3: RMAN Transport Tablespace : Practical

Chapter 11: PDB Migration To AWS Using Unplugging and Plugging

Lecture 1: PDB Migration Using Unplugging & Plugging Concepts

Lecture 2: PDB Migration Using Unplugging and Plugging Practical

Chapter 12: RMAN Cross Platform Transportable PDB

Lecture 1: RMAN Cross Platform Transportable PDB : Concepts

Lecture 2: RMAN Cross Platform Transportable PDB: Practical

Chapter 13: Database Migration Using Oracle Golden Gate

Lecture 1: Overview of Zero Downtime Migration Using Goldengate

Lecture 2: Installation of Goldengate on EC2

Lecture 3: Installation of Goldengate On Premise Server

Lecture 4: Configure Database For Goldengate Replication: Concepts

Lecture 5: Configure Database For Goldengate Replication : Practical

Lecture 6: Create source table for repication

Lecture 7: Configure Manager Process

Lecture 8: Enable supplemental Logging at object level

Lecture 9: Configure Extract and Data pump: Concepts

Lecture 10: Configure Replicat : Concepts

Lecture 11: Configure Extract Process: Practical

Lecture 12: Configuring Data Pump

Lecture 13: Start the process

Lecture 14: Initial Data load: Backup Source Tables Using expdp

Lecture 15: Initial Data Load: Load Data Using Impdp

Lecture 16: Switching Over To Database on EC2

Chapter 14: Database Migration Using Oracle Data Guard

Lecture 1: Download Oracle 19c To EC2 Instance

Lecture 2: Installation Of Oracle 19c on AWS EC2 Instance

Lecture 3: Configure Primary Database Concepts

Lecture 4: Taking Backup of Primary Database For Standby

Lecture 5: Creating TNS Names for Data guard

Lecture 6: Copying Backp Pieces To EC2 Using S3 Buckets

Lecture 7: Renaming Password File

Lecture 8: Configuring Standby Instance Parameters

Lecture 9: Restore Standby Database on EC2

Lecture 10: Making Primary and standby in sync: starting media recovery

Lecture 11: Switching Over On Premise Database To Cloud Database

Chapter 15: Migration To RDS Using Data Pump

Lecture 1: Work Flow For Migrating On Premise Database To RDS

Lecture 2: Creating RDS Database

Lecture 3: Testing Connectivity To RDS Using SQL Developer

Lecture 4: Connecting To RDS From On Premise DB Server

Lecture 5: Creating Database Link From On Premise DB to RDS

Lecture 6: Take The Backup Of Source Database Using Data pump

Lecture 7: Copy The Backup Files to RDS Server

Lecture 8: Import The Data To RDS Database

Chapter 16: Migration To RDS Using S3 Buckets and Data Pump

Lecture 1: Concets On Database Migration To RDS Using S3 Buckets and Data Pump

Lecture 2: Database Migration To RDS Using S3 Buckets and Data Pump : Practical

Chapter 17: Migration To RDS Using Database Migration Service ( DMS)

Lecture 1: Database Migration Service Work Flow

Lecture 2: Creating Replication Instance

Lecture 3: Creating End Points

Lecture 4: Add Supplemental Logging On Source Database

Lecture 5: Performing Database Migration Task

Chapter 18: Migration To RDS Using Oracle Golden gate

Lecture 1: Using Oracle GoldenGate with Amazon RDS: Scenarious

Lecture 2: Concepts On Zero Downtime Migration To RDS Using Golden Gate

Lecture 3: Congiuring On Premise Database For Golden Gate Replication