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