Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
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)
252 students

Oracle Database Migration Methods

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

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

    Master RMAN duplicate from an active database to create live, no-backups clones, configure cross-server cloning with listener and DNS, and validate the cloned database.

  • RMAN Interview Questions1:15:48

    Explore RMAN interview questions on database cloning, including cloning steps, troubleshooting failures, password file usage, and the importance of cross-team approvals for Oracle database migration.

  • RMAN PITR Duplicate to Same SID1:56:49

    Execute RMAN point-in-time recovery to duplicate a database to the same SID using backups and archived logs. Compare spfile versus pfile approaches for cloning and parameter management in testing environments.

  • RMAN Cross Platform Migration2:39:33

    Explore cross-platform migration of an Oracle database, moving from Windows to Linux, using transportable platforms and a transport script to convert data files.

  • 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

    Learn how to migrate Oracle databases from Windows to Linux using RMAN and transportable tablespaces, including installing Oracle tools, creating the source database, and transporting data files.

  • 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

    Explore data pump migration from Windows to Linux by exporting a full Oracle database, creating a directory object, and importing on Linux, with practical troubleshooting of tablespaces and privileges.

  • Oracle Database Manual Upgrade2:36:29

    Master the Oracle database manual upgrade from 20c to 19c, covering prechecks, environment setup, and the steps to ensure application compatibility and successful migration.

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