Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle Database Migration Methods
Rating: 4.3 out of 5(15 ratings)
251 students

Oracle Database Migration Methods

Move entire database from one platform to another
Created byArun Kumar
Last updated 5/2021
English

What you'll learn

  • Active database duplication using RMAN
  • Backup based database duplication using RMAN
  • RMAN Point-in-time database duplication
  • Oracle database migration from Windows to Linux using RMAN
  • Oracle database migration from Windows to Linux using Data Pump
  • Oracle Database Manual Upgrade from 12c to 19c

Course content

1 section • 11 lectures • 21h 10m total length

  • Setup Cloud Server2:14:52

    Set up two cloud servers for Oracle database migration, install Oracle software on production and test environments, and configure silent installation to enable rapid cloning and migration workflows.

  • RMAN Duplicate from active database1:54:15
  • RMAN Interview Questions1:15:48
  • RMAN PITR Duplicate to Same SID1:56:49
  • RMAN Cross Platform Migration2:39:33
  • Resolving Issues59:59

    Explore practical techniques for resolving database migration issues, including backup and archivelog management, point-in-time recovery, and troubleshooting cloning workflows in Oracle.

  • Fix PITR Clone Issue1:07:14

    Resolve a PITR clone issue in Oracle database migration methods by guiding through archive logs, backups, and point-in-time recovery on the clone server.

  • RMAN Windows to Linux Migration - Part 12:57:05
  • RMAN Windows to Linux Migration - Part 22:06:05

    Learn practical RMAN windows-to-linux migration techniques for Oracle databases, including transportable data files, startup migrations, and post-migration upgrades, with guidance on golden gate replication and cloud vs on-prem considerations.

  • Data Pump Windows to Linux Migration1:22:20
  • Oracle Database Manual Upgrade2:36:29

Requirements

  • Basic knowledge of Oracle database administration

Description

As a DBA, it is one of the common practices to clone or duplicate or move database from one server to another server. You might use different inbuilt tools like Oracle RMAN or Data Pump to perform the database migration or duplication. Master the different ways you can move the database with this recorded live sessions.

Prepare & Move Database from One Server to Another

Oracle RMAN (Oracle Recovery Manager) is a utility built into Oracle databases to automate backup and recovery process. This helps DBA to easily trigger database backups and move the database from one platform to another.

Same way, Oracle Data Pump is a newer, faster and more flexible alternative to the "exp" and "imp" utilities used in previous Oracle versions. Oracle Data Pump allows you to perform database migration without affecting the platform of source and target database.

Many of the utilities are available as part of Oracle DB installation and support migration for both Oracle and non-Oracle databases but in this course, we will only be looking at RMAN and Data Pump to migrate database.

Get scripts and steps to perform migration activities in real-time!

I shall be adding more migration steps and video lectures to the course in near future. In this migration course, you will be mainly looking at:

  • Active database duplication

  • PITR based database duplication

  • Cross platform migration using RMAN

  • Cross platform migration using data pump

  • Oracle 12c to 19c manual upgrade

Who this course is for:

  • Oracle DBA
  • Oracle Database Architects
  • Oracle Cloud DBAs

Report abuse