Migrating RAC Database to Oracle Cloud Infrastructure

Objectives

• Inventorying the source environment
• Learning how to decide on a migration strategy
• Planning your target RAC Setup on Oracle Cloud Infrastructure
• Performing prerequisites on the source Oracle RAC Database
• Creating Virtual Cloud Network (VCN) for DB System
• Deploying 2 Node Oracle RAC Virtual Machine DB System on OCI
• Migrating On-Prem 2 Node RAC Database to VM DB System on OCI Using Data Pump
• Migrating On-Prem RAC Database to OCI by Using Oracle Database Cloud Backup Module
• Review Solution: Migrating On-Prem RAC Database to OCI VM DB System Using Data Guard
• Review Solution: Migrating RAC Database to OCI VM DB System Using GoldenGate

Topics

• Course Overview
  • Prerequisites
  • Course Roadmap
• Analyzing and Choosing Your Migration Strategy
  • Inventorying the Source Environment
  • Deciding on the Best Migration Strategy
  • Plan Your Target RAC Setup on Oracle Cloud Infrastructure
  • Supported Database Editions and Versions in OCI
• Prepare Source & Target Systems for Migration
  • Perform Prerequisites on the Source Oracle Database
  • Preparing the Source Oracle RAC Database for Migration
  • Creating Virtual Cloud Network (VCN) for DB System
  • Deploying 2-Node RAC Virtual Machine DB System on OCI
  • Setting Up DNS for a DB System
• Migrating On-Prem 2-Node RAC Database to VM DB System on OCI Using Data Pump
  • Connecting to a Database on a Multi-Node DB System
  • Connecting Using SCAN IP Addresses & Public IP Addresses
  • Troubleshooting Connection Issues
  • Data Pump Migration Compatibility
  • Migrating an On-Premises 12c CDB Schema to OCI 12c CDB: Conventional Mode
  • Migrating an On-Premises 12c RAC PDB to 12c RAC PDB on OCI: Conventional Mode
  • Data Pump Transportable Tablespace (TTS) Mode
  • Migrating an On-Premises 12c Database Tablespace to OCI 12c CDB: Transportable Tablespace
• Migrating On-Prem 2-Node RAC Database to OCI by Creating a Backup in the Cloud
  • Data Pump Full Transportable Mode
  • Migration Considerations and Compatibility
  • Overall Migration Approach
  • Migrating RAC Database from On-Premises to OCI VM DB System Using Cloud
  • Backup Module
  • Installing the Oracle Database Backup Module
  • Example 1: Installing the Oracle Database Cloud Backup Module
  • Example 2: Creating a Tiering Container When Installing the Oracle Database Cloud
  • Backup Module
  • Oracle Database Backups to Object Storage
  • Restoring Oracle Database from Object Storage in OCI
• Migrating On-Prem 2-Node RAC Database to OCI by Using Data Guard
  • Architecture
  • Migration Milestones
  • Cloud Services and Roles Required
  • Planning the RAC Database Migration
  • Inventorying the Source Environment
  • Deciding on the Best Migration Strategy
  • Preparing for Migration
  • Create a Standby Database for the Oracle Cloud Infrastructure System
  • Check for Connectivity and Bundle Patches
  • Configure the On-Prem-to-OCI Communication Settings in the OCI Console
  • Migrating the RAC Database
  • Configure the Standby (Target) Database
  • Configure the Database with Oracle Data Guard Broker
  • Validate Oracle Data Guard Broker on the Primary Database and the Standby Database
    
    
• Migrating On-Prem 2 Node RAC Database to OCI Using Hybrid Data Guard
  • Hybrid: Disaster Recovery to Cloud by Using Backups & Standby
  • Enabling DR on Oracle Database Cloud: Overview
  • Prepare the On-Premises Primary Database
  • Set Initialization Parameters
  • Preparing and Creating the Disaster Recovery Database
  • Monitoring a Hybrid Data Guard Configuration
  • Performing Switchover to Physical Standby on OCI
• Use Case: Migrating RAC Database to OCI VM DB System Using GoldenGate
  • Near-Zero Down Time Migration by Using GoldenGate
  • GoldenGate Setup Between On-Premises 2 Node RAC Database and 2 Node RAC
  • Database in OCI for Migration
  • Use-Case: Migrating to Oracle Database Cloud Service by Using GoldenGate