Migrating RAC Database to Oracle Cloud Infrastructure

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Call for In Class or Live Virtual Dates3$3,600 USDPurchase


Migrating RAC Database to Oracle Cloud Infrastructure

Description: Every migration project needs a well-planned strategy and the method to be used for migration depends on various considerations. Gain a first-hand experience of performing RAC Database migration in this workshop using some of the popular methods with the help of hands-on labs.

Duration: 3 Days

Learn To:

  • Analyze source system
  • Identify the considerations for choosing a migration strategy
  • Prepare source & target database systems for migration
  • Migrating On-Prem RAC Database to OCI Using Data Pump
  • Migrating On-Prem RAC Database to OCI Using Oracle Database Cloud Backup Module
  • Migrating On-Prem RAC Database to OCI Using Data Guard
  • Migrating On-Prem RAC Database to OCI Using GoldenGate

Prerequisites

  • Experience in Oracle Database12cR2 administration & general understanding of Oracle Cloud Infrastructure services.

Audience

  • Cloud Database Administrator
  • Database Administrator

Course 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
  • Data Pump Full Transportable Mode

Migrating On-Prem 2-Node RAC Database to OCI by Creating a Backup in the Cloud

  • 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

Right Menu IconMENU