Oracle Database Migration Methods OnPrem to OCI
What you’ll 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
Description
With the advent of Cloud Computing the biggest challenge that is being faced by the DBA’s & Solution Architects is how to migrate the On-Prem Oracle Databases onto the Cloud. This course teaches you all the different Strategies and methods that you can use to migrate from On-Prem to Oracle Cloud (OCI) along with a method to migrate from AWS RDS to OCI as well.Please note the same strategies can be used if you are looking to migrate your Oracle Database to IaaS based Cloud Services in AWS(EC2) / Azure / OCI & GCP as well.We shall start our migration journey with some discussion around : the factors that help you to choose your migration strategy, from here we will discuss two main concepts which drive a Migration Strategy and they are Endianness & Database Character Sets. As the biggest bottleneck in any Database Migration exercise is Nework Bandwidth hence we will discuss the concept of Oracle Data Transfer Appliance.In the next module we shall build our On-Prem Environment using Vagrant & VirtualBox , there will be a deep dive session into Vagrant if you are new to this technology as we will be installing, configuring Vagrant and then provision our Virtual Machine (VM) using Vagrant and show how this whole process is automated. This would be followed by the installation of Oracle 18c XE , creation of database along with Sample Schemas and this will act as our on-prem Oracle Database environment.Once our On-Prem environment is all setup we will proceed our journey to oracle Cloud and will introduce you to 2 important concepts in OCI which are Compartments and VCN’s (Virtual Cloud Network) and then we shall provision a VM based DbaaS Instance in OCI. I shall teach you the method to setup SSH connectivity between On-prem machine and OCI DB System.From next module onwards we will be delving deeper into different types of Oracle Database Migration methods which are available to us. The whole discussion will be divided into three parts : Discussion on the concept , Workflow of the Method , An End to End Demo on the migration method. Please note that the commands used in the demos are all given under the Resources section as well. The Methods that will be taught are :•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 ObjectsAs with my all courses in the last Module we shall try and challenge ourselves and the challenge will be to Migrate the Oracle Database running in AWS RDS to Oracle Cloud and to accomplish this we shall be making use of AWS DMS (Data Migration Service).I hope at the end of the course you will feel more confident as you would be equipped with all the tools & techniques that you need to Migrated your on-prem oracle databases.Happy Learning !!!RegardsKshitij Joy (OCM)DB Alchemist Academy
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 What will you learn from the Course
Section 2: Oracle Database Migration : Introduction
Lecture 3 Choosing a Migration Method
Lecture 4 What is Endianness ?
Lecture 5 What are Database Charactersets
Lecture 6 What is a Data Transfer Appliance (DTA)
Section 3: Setting up On-Prem Environment
Lecture 7 Setting up On-Prem Environment: Intro
Lecture 8 What is Vagrant ?
Lecture 9 Install Oracle VirtualBox
Lecture 10 Install Vagrant
Lecture 11 Setup & Configure Vagrant
Lecture 12 Provision a VM using Vagrant
Lecture 13 Configure the VM before Oracle Install
Lecture 14 Install Oracle 18c XE on the VM
Lecture 15 Setup Your On-Prem Environment (Schemas/Tbs)
Section 4: Setting up OCI DB System
Lecture 16 Setting up OCI DB System : Intro
Lecture 17 Create a Compartment
Lecture 18 Create a Virtual Cloud Network (VCN)
Lecture 19 Setup a Public/Private Keypair on Laptop
Lecture 20 Provision an Oracle 18c Database on Oracle Cloud
Lecture 21 Post Provisioning Checks on OCI DB System
Lecture 22 Setup SSH Connectivity from On-Prem to OCI Machine
Lecture 23 A 10 Second Survey
Section 5: Migration Methods : Discussion & Demos
Lecture 24 Migration Methods : Discussion & Demos- Intro
Lecture 25 Oracle Database Migration Methods
Lecture 26 Migration Methods Use-Cases
Lecture 27 Data Pump Conventional Export/Import
Lecture 28 Workflow for Data Pump Conventional Export/Import
Lecture 29 Demo: Data Pump Conventional Export/Import
Lecture 30 Data Pump Transportable Tablespace
Lecture 31 Workflow Data Pump Transportable Tablespace
Lecture 32 Data Pump Full Transportable
Lecture 33 Workflow: Data Pump Full Transportable
Lecture 34 Demo: Data Pump Full Transportable
Lecture 35 RMAN CONVERT Transportable Tablespace with Data Pump
Lecture 36 Workflow:RMAN CONVERT Transportable Tablespace with Data Pump
Lecture 37 Demo: RMAN CONVERT Transportable Tablespace with Data Pump
Lecture 38 Unplugging/Plugging (CDB)
Lecture 39 Workflow:Unplugging/Plugging (CDB)
Lecture 40 Demo:Unplugging/Plugging (CDB)
Lecture 41 RMAN Cross-Platform Transportable PDB
Lecture 42 Workflow: RMAN Cross-Platform Transportable PDB
Lecture 43 Demo: RMAN Cross-Platform Transportable PDB
Lecture 44 RMAN Cross-Platform Transportable PDB (Inconsistent Backups)
Lecture 45 Workflow:RMAN Cross-Platform Transportable PDB (Inconsistent Backups)
Lecture 46 Demo: RMAN Cross-Platform Transportable PDB (Inconsistent Backups)
Lecture 47 RMAN Backup/Restore using Oracle Cloud Backup Module
Lecture 48 Workflow: RMAN Backup/Restore using Oracle Cloud Backup Module
Lecture 49 Demo: RMAN Backups using Oracle Cloud Backup Module
Lecture 50 Demo:RMAN Restore using Oracle Cloud Backup Module
Lecture 51 Workflow: Sql Developer Method
Lecture 52 Demo: Sql Developer Method
Section 6: New Course: Demystifying Oracle Database Security:On-Prem & Oracle Cloud
Lecture 53 New Course: Demystifying Oracle Database Security:On-Prem & Oracle Cloud
Lecture 54 Course Link
Section 7: Migrating Oracle Database from AWS RDS to OCI
Lecture 55 Migrating Oracle Database from AWS RDS to OCI-Intro
Lecture 56 Provision an Oracle Database in AWS RDS
Lecture 57 AWS Data Migration Service (AWS DMS)
Lecture 58 Workflow:AWS Data Migration Service (AWS DMS)
Lecture 59 Demo: AWS Data Migration Service (AWS DMS) : Create Replication Instance
Lecture 60 Demo: AWS DMS : Create Source Endpoint
Lecture 61 Demo: AWS DMS : Create Target Endpoint
Lecture 62 Demo: AWS DMS : Create & Run Migration Task
Beginner to the World of Cloud Computing & Any Experienced DBA’s / Developers looking to get Understanding around Oracle Database Migration Techniques
Course Information:
Udemy | English | 6h 30m | 2.69 GB
Created by: Kshitij Joy (Udemy Instructor Partner)
You Can See More Courses in the IT & Software >> Greetings from CourseDown.com