Migrating Your Oracle Database to Autonomous Database Cloud

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Call for In Class or Live Virtual Dates2$2,700 USDPurchase


Migrating Your Oracle Database to Autonomous Database Cloud

Description: This course teaches you migration techniques to move data to cloud and to quickly create test or development database instances using Oracle Autonomous Database Cloud service. You will reinforce your learning with the hands-on labs as part of this course.

Duration: 2 Days

Learn To:

  • Analyze and compare your source and target environments
  • Choose your migration strategy
  • Preparing Source and Target Systems for Migration
  • Migrate data using SQL Developer to Autonomous Database
  • Migrate On-Premises Oracle Database Schema Using Data Pump
  • Perform Post Migration Verification

Audience

  • Database Administrator
  • Cloud Administrator
  • Cloud Architect

Course Objectives

  • Describe the Building Blocks for High Availability in Oracle Cloud Infrastructure
  • Get familiar with Oracle Cloud Infrastructure for Oracle Maximum Availability Architecture
  • Review Oracle Cloud Infrastructure: Database Service
  • Learn to deploy a 2 Node RAC Virtual Machine DB System on OCI
  • Explore High Availability Features
  • Demonstrate Transparent Application Failover on a 2 Node RAC
  • Review Database Disaster Recovery Solution on OCI
  • Learn to Enable and Validate DR for a 2 Node RAC Virtual Machine DB System on OCI
  • Perform Data Guard Operations - Switchover, Failover, and Reinstate

Prerequisites

  • Experience in Oracle Database 11g and/or 12c Administration
  • Working knowledge of Oracle Database Cloud Service on Oracle Cloud Infrastructure
  • Completed the Oracle Database Cloud for DBAs on Oracle Cloud Infrastructure course

Topics

Building Blocks for High Availability in Oracle Cloud Infrastructure

  • High Availability Building Blocks
  • Architecting High Availability Solutions
  • Floating IP Addresses
  • HA with Public & Private Load Balancer
  • Fast Connect Redundancy
  • Using Both IPSec VPN and FastConnect
  • 2-Node RAC DB System to Support High Availability of a Two-Tier Web Application
  • Using Data Guard for a High Availability Database Design
  • Oracle Cloud Infrastructure for MAA
  • Bronze, Silver, Gold & Platinum Reference Architecture
  • RTO and RPO Service-Level Requirements

Oracle Cloud Infrastructure: Database Service Overview

  • Database Service: Use Cases
  • Virtual Machine DB Systems
  • VM DB Systems Storage Architecture
  • Bare Metal DB Systems
  • Shapes for Bare Metal Database Systems
  • BM DB Systems Storage Architecture
  • Exadata DB Systems
  • Exadata DB X7 Systems
  • Exadata DB Systems Storage Architecture
  • Scaling Exadata DB Systems
  • OCI DB Systems - VM, BM, Exadata
  • Database Editions and Versions
  • Database Editions and Options
  • High Availability and Scalability
  • Data Guard

Available DB Systems for Implementing Database High Availability in OCI

  • Compute: Bare Metal and Virtual Machines
  • Bare Metal
  • Database Editions and Versions
  • Database Editions and Options
  • Shapes for Bare Metal Database Systems
  • Bare Metal Database Storage Options
  • Shapes for Virtual Machine Database Systems
  • Storage Options for Virtual Machine DB Systems
  • VM DB Systems Storage Architecture
  • BM DB Systems Storage Architecture

Deploying a 2 Node RAC Virtual Machine DB System on OCI

  • Creating a Virtual Cloud Network (VCN) for a DB System
  • Using the Console to Launch a 2 Node RAC Virtual Machine DB System
  • Using Console to Check the Status of a DB System
  • Setting Up DNS for a DB System
  • Special Considerations for Creating DB Systems

Working with 2 Node RAC Virtual Machine DB System on OCI

  • Connecting to a Database on a Multi-Node DB System
  • Create TNS Entry for PDBs
  • Connecting to a 2 Node RAC DB System with SSH
  • Connecting to a Database with Oracle SQL Developer
  • Troubleshooting Connection Issues

Introduction to Database Disaster Recovery on OCI

  • Why You Need Disaster Recovery Plan?
  • Challenges with Disaster Recovery Deployment
  • Disaster Recovery to Oracle Cloud Infrastructure: Strategies
  • Hybrid: Disaster Recovery to Cloud
  • Benefits of Using Oracle Active Data Guard
  • Benefits of Using Golden Gate
  • Disaster Recovery to Cloud: Networking Considerations

Database Disaster Recovery Solutions on OCI

  • Database Strategies for Disaster Recovery
  • Benefits of Data Guard on OCI
  • Data Guard Configuration Modes
  • Architecture for Data Guard on OCI
  • Benefits of Using Golden Gate on OCI
  • Best Practices for Golden Gate Configuration
  • Architecture for Golden Gate on OCI
  • Using Both Active Data Guard and Golden Gate on OCI

Enabling a Validating DR for a 2 Node RAC Virtual Machine DB System on OCI

  • Using Oracle Data Guard on OCI
  • Security List for Primary & Standby DB System Subnet
  • Working with Data Guard on OCI
  • Enable Data Guard on a Bare Metal DB System
  • Enable Data Guard on a Virtual Machine DB System
Right Menu IconMENU