Overview

This course will help you to 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.

Skills Covered

  • 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

Prerequisites

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

Target Audience

  • Cloud Database Administrator
  • Database Administrator

Course Curriculum

Module 1: Course Overview

  • Prerequisites
  • Course Roadmap

Module 2: 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

Module 3: 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
  • Deploying 2-Node RAC Virtual Machine DB System on OCI

Module 4: 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

Module 5: 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

Module 6: 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
  • Planning the RAC Database Migration
  • 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

Module 7: 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

Module 8: 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

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

Trainocate exam and cert

Exam & Certification

This course is not associated with any Certification.

Training & Certification Guide

Frequently Asked Questions

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes