Course Date | Start Time | End Time | Time Zone | Location | Days | Price |
---|
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
Course Date | Start Time | End Time | Time Zone | Location | Days | Price |
---|