Oracle Database Migration Methods

Move entire database from one platform to another

Ratings: 4.24 / 5.00




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

What You Will 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

Who Should Attend!

  • Oracle DBA
  • Oracle Database Architects
  • Oracle Cloud DBAs