Migrating Your Oracle Database to Oracle Cloud Infrastructure

Migrating Your Oracle Database to Oracle Cloud Infrastructure

You will learn to analyze and prepare the source system for migration and to choose the best migration strategy that meets your requirements. As part of the hands-on labs you will create a Virtual Machine DB System and try out various migration methods.

Duration: 2 Days

Prerequisites

• Experience in Oracle Database 11g and/or 12c Administration
• General understanding of Oracle Cloud technology
• Working knowledge of Oracle Database Cloud Service on Oracle Cloud Infrastructure
• Oracle Cloud Infrastructure Fundamentals Ed 1
• Oracle Database Cloud for DBAs on Oracle Cloud Infrastructure

Audience

• Administrators
• Cloud Administrators
• Database Administrators

Learning Objectives

• Identify the benefits of migrating to Oracle Cloud Infrastructure (OCI)
• Identify the building blocks of Oracle Cloud Infrastructure
• Get familiar with OCI terminology such as tenant, region, availability domain, shapes
• Analyze and compare your source and target environments
• Learn to prepare source and target systems for migration
• Create a Virtual Machine DB System on Oracle Cloud Infrastructure for migration
• Explore the RMAN backup and restore mechanism
• Review migration use cases
• Migrate to Oracle Database 18c on Oracle Cloud Infrastructure
• Migrate on-premises database tables using SQL Developer
• Migrate on-premises database schema to using Data Pump
• Use transportable tablespace method for migration
• Migrate on-premises PDB using Data Pump Export/Import method
• Migrate a PDB from OCI-C using Data Pump Export/Import method
• Migrate a PDB from OCI-C using the Unplug/Plug method
• Migrate a CDB from OCI-C using RMAN
• Migrate Oracle Database to OCI using backups from OCI-C Object Store
• Describe advanced migration methods using Data Guard and GoldenGate
• Understand what changes after migration and the post migration tasks

Topics

• Migrating Oracle Database to Oracle Cloud Infrastructure: Why, What, and How
• Getting Started with Oracle Cloud Infrastructure
• Analyzing and Choosing Your Migration Strategy
• Preparing Source and Target Systems for Migration
• Migrating Using SQL Developer
• Migrating an Oracle Database to OCI by Using Data Pump
• Migrating Oracle Database to OCI Using Unplug/Plug and Remote Cloning Method
• Migrating an Oracle Database to OCI by Using Recovery Manager (RMAN)
• Migrating Oracle Database to OCI by Using Oracle Database Cloud Backup Module
• Use Case: Migrating Oracle Database from OCI-C to OCI Bare Metal Using Data Guard
• Use Case: Migrating DBCS Single-Instance Database from OCI-C to OCI VM Using the IBKUP Utility
• Use Case: Near Zero Downtime Migration by Using Oracle GoldenGate
• What Changes After Migration?