Migrating Your Oracle Database to Oracle Cloud Infrastructure

Migrating Oracle Database to Oracle Cloud Infrastructure: Why, What, and How

• OCI: Specifically Architected for Oracle Databases
• Managing Oracle Database: On-Premises Versus Oracle Cloud Infrastructure
• Considerations for Choosing a Migration Method
• Subscribing to an Oracle Cloud Service
• Universal Credits & Bring Your Own License

Getting Started with Oracle Cloud Infrastructure

• Regions, Availability Domains, and Backbone Network
• Comprehensive Virtual Network with Off-box Virtualization

Analyzing and Choosing Your Migration Strategy

• Migration Life Cycle of a Target Cloud Database
• Migration Methods & Prerequisites
• Migration Strategy: Selection Criteria
• Choosing a Method
• Choosing a Hardware Configuration: Compute Shapes
• Moving Large Data Sets to Oracle Cloud

Preparing Source and Target Systems for Migration

• Preparing Source On-Premises Oracle Database for Migration
• Preparing Source DBCS Service Instance for Migration
• Creating the Target System: OCI Virtual Machine DB System

Migrating Using SQL Developer

• Migrating Tables by Using SQL Developer
• Migrating Selected Tables by Using SQL Developer INSERT Statements
• Migrating Selected Tables by Using SQL Developer and SQL*Loader

Migrating an Oracle Database to OCI by Using Data Pump

• Migrating an On-Premises 12c CDB Schema to OCI 18c CDB: Conventional Mode
• Migrating an On-Premises 12c PDB to 18c PDB on OCI: Conventional Mode
• Migrating an On-Premises 12c Database Tablespace to OCI 18c CDB: Transportable Tablespace
• Data Pump Full Transportable Mode

Migrating Oracle Database to OCI Using Unplug/Plug and Remote Cloning Method

• Unplugging & Plugging In an On-Premises Non-CDB
• Unplugging/Plugging a PDB: High-Level Overview
• Unplugging & Plugging In an On-Premises PDB
• Migrating a 12.1 PDB to a 12.2 CDB in Database Cloud Service
• Remote Cloning Method: Migration Compatibility
• Remote Cloning an On-Premises Non-CDB & PDB

Migrating an Oracle Database to OCI by Using Recovery Manager (RMAN)

• RMAN Cross-Platform Transportable Tablespace Backup Sets
• RMAN Migration Methods to Oracle Cloud and Version Compatibility
• Tablespace Transport by Using RMAN CONVERT
• Cross-Platform PDB Transport
• Use-Case: Migrating a 12c On-Premises Database to Oracle Cloud by Using RMAN Cross-Platform Transportable Tablespace
• Cross-Platform Transportable Tablespace to a Different Endian Platform with RMAN Backup Sets
• Migrating by Using RMAN Cross-Platform Transportable Tablespace

Migrating Oracle Database to OCI by Using Oracle Database Cloud Backup Module

• Oracle Backup Module Installation Prerequisites
• Installing the Oracle Database Cloud Backup Module
• Creating a Tiering Container When Installing the Oracle Database Cloud Backup Module
• Restoring Oracle Database from Object Storage Classic in OCI

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?

• Network Access to the Compute Node and Database
• Creating Security Lists & Configuring Connections to the Compute Node
• Security Lists & Security Rule
• Tablespace Encryption in Database Cloud Service
• Backup and Recovery Strategy
• Patching Database Cloud Service
• Post-Migration Best Practices