Implement Database High Availability & Disaster Recovery on OCI

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice


Implement Database High Availability & Disaster Recovery on OCI

Description: You will learn to analyze the database HA & DR options available on Oracle Cloud and choose the best strategy that meets your requirements. As part of the hands-on labs, you will create a 2 Node RAC Virtual Machine DB system and also create a 2 Node RAC Data Guard associated with your primary DB system.

Duration: 2 Days

Learn To:

  • Understand the Building Blocks for High Availability in OCI
  • Review Database Services on OCI
  • Identify the Available DB Systems for Implementing Database High Availability in OCI
  • Deploy a 2 Node RAC Virtual Machine DB System on OCI
  • Review Database Disaster Recovery Solution on OCI
  • Enable and Validate DR for a 2 Node RAC Virtual Machine DB System on OCI

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

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice


Right Menu IconMENU