14 Oracle DB Migration Methods That Can Boost Your Career

14 Oracle DB Migration Methods That Can Boost Your Career, available at $59.99, has an average rating of 4.4, with 88 lectures, based on 65 reviews, and has 696 subscribers.

You will learn about Oracle Database Migration From On-Premise Servers To AWS Cloud AWS RDS Oracle Database on AWS Oracle Database 19c Administration This course is ideal for individuals who are Beginner To Intermediate Level Database Administrators It is particularly useful for Beginner To Intermediate Level Database Administrators.

Enroll now: 14 Oracle DB Migration Methods That Can Boost Your Career

Summary

Title: 14 Oracle DB Migration Methods That Can Boost Your Career

Price: $59.99

Average Rating: 4.4

Number of Lectures: 88

Number of Published Lectures: 88

Number of Curriculum Items: 88

Number of Published Curriculum Objects: 88

Original Price: $129.99

Quality Status: approved

Status: Live

What You Will Learn

Oracle Database Migration From On-Premise Servers To AWS Cloud

AWS RDS

Oracle Database on AWS

Oracle Database 19c Administration

Who Should Attend

Beginner To Intermediate Level Database Administrators

Target Audiences

Beginner To Intermediate Level Database Administrators

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 Administratorwill 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

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

Instructors

Wysheid Learning Portal
Place for quality training experience

Rating Distribution

1 stars: 4 votes

2 stars: 0 votes

3 stars: 1 votes

4 stars: 19 votes

5 stars: 41 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!