Overview

You will figure out how to investigate and set up the source framework for movement and to pick the best relocation methodology that meets your prerequisites. As a feature of the hands-on labs you will make a Virtual Machine DB System and evaluate different relocation techniques.

This course is perfect for experienced DBAs who are hoping to improve their cloud relocation abilities. Taking this hands-on preparing will get ready DBAs for Cloud DBA accreditation tests.

Skills Covered

You will learn how to :

  • Analyze and look at your source and target conditions
  • Identify the advantages of relocating to Oracle Cloud Infrastructure (OCI)
  • Describe the means associated with the movement procedure
  • Prepare source and target frameworks for relocation
  • Migrate on-premises database tables utilizing SQL Developer
  • Migrate on-premises database diagram to utilizing Data Pump
  • Use transportable tablespace technique for movement
  • Migrate on-premises PDB utilizing Data Pump Export/Import technique
  • Migrate a PDB from OCI-C utilizing Data Pump Export/Import technique
  • Migrate a PDB from OCI-C utilizing the Unplug/Plug technique
  • Migrate a CDB from OCI-C utilizing RMAN
  • Migrate Oracle Database to OCI utilizing reinforcements from OCI-C Object Store
  • Describe propelled relocation strategies utilizing Data Guard and GoldenGate

Prerequisites

  • Oracle Cloud Infrastructure Fundamentals Ed 1
  • Oracle Database Cloud for DBAs on Oracle Cloud Infrastructure
  • General comprehension of Oracle Cloud innovation
  • Experience in Oracle Database 11g and additionally 12c Administration

Target Audience

  • Administrator
  • Cloud Administrator
  • Database Administrator

Course Curriculum

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

Module 2: Getting Started with Oracle Cloud Infrastructure

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

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

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

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

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

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

Module 8: 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 CrossPlatform Transportable Tablespace
  • Cross-Platform Transportable Tablespace to a Different Endian Platform with RMAN Backup Sets
  • Migrating by Using RMAN Cross-Platform Transportable Tablespace

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

Module 10: Use Case: Migrating Oracle Database from OCI-C to OCI Bare Metal Using Data Guard
Module 11: Use Case: Migrating DBCS Single-Instance Database from OCI-C to OCI VM Using the IBKUP Utility
Module 12: Use Case: Near Zero Downtime Migration by Using Oracle GoldenGate
Module 13: 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

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.

x Clear all selections
Trainocate exam and cert

Exam & Certification

This course is not associated with an 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