Oracle Database 19c: Clusterware & RAC Administration Accelerated Training

This accelerated course covers in-depth content, starting with Oracle Database 19c: Clusterware Administration and progressing into Oracle RAC database architecture. You will also be introduced to Oracle Database Exadata Cloud Service, learning how these components work together.

Key Learning Outcomes:

– Perform pre-installation tasks for Grid Infrastructure.
– Install Standard and Flex Clusters.
– Add/remove nodes and upgrade/patch existing Grid Homes.
– Manage and administer both Standard and Policy-Managed Clusters.
– Use Oracle Clusterware for high availability of applications.
– Install Oracle RAC software and create cluster databases.
– Administer Oracle RAC databases (both administrator and policy-managed).
– Monitor and troubleshoot performance issues.
– Understand RAC services, Application Continuity, and Transaction Guard.
– Create and manage RAC One Node and Multitenant RAC databases.
– Gain a comprehensive understanding of Oracle Database Exadata Cloud Service.

Benefits to You:

Upon completing this course, you will have the expertise to install, configure, and manage Oracle Clusterware and RAC software. You’ll be equipped to make applications highly available, optimize database workloads, reduce IT costs, and enable cloud-based consolidation for enhanced performance and reliability.

Course Curriculum:

Cluster Infrastructure and Management

– Overview of Grid Infrastructure
– Understanding Clusters & Flex Clusters
– Oracle Clusterware and ASM Architecture
– Oracle RAC Architecture Overview
– Cluster-Aware Storage Solutions
– RAC Benefits: Scaleup, Speedup, Global Resources

Oracle RAC Installation & Configuration

– Installing Oracle Database and Grid Infrastructure Software
– Cluster Database Creation and Configuration
– Converting Single Instance to RAC with DBCA/rconfig
– Post-Installation Tasks

Oracle RAC Administration

– Using Enterprise Manager for RAC
– Managing RAC Alerts, Metrics, and Undo Tablespaces
– Administering Redo Threads and RAC-specific parameters
– Upgrading and Patching Oracle RAC (PSU, CPU, Merge Patches)

Backup and Recovery in RAC

– RAC Instance Failure and Recovery (LMON, SMON)
– Redo Threads and Archive Logs Management
– RMAN Configuration and Backup Strategies in RAC
– Parallel Recovery & MTTR Tuning in RAC

Global Resource Management & Cache Fusion

– Managing Global Resources
– Library Cache & Buffer Cache Management in RAC
– Understanding Multi-block Read and Undo Consistency

Monitoring and Tuning Oracle RAC

– Monitoring RAC Performance (OCPU, Wait Events, RAC-specific V$ Views)
– Using Automatic Database Diagnostic Monitor (ADDM) for RAC
– Cluster Health Advisor (CHA) for Monitoring RAC

High Availability and Services in RAC

– Configuring Oracle Services for RAC
– Load Balancing and Transparent Application Failover (TAF)
– Runtime Connection Load Balancing and FAN Events
– Configuring Application Continuity (AC) for High Availability

RAC One Node and Multitenant RAC

– Concepts of RAC One Node and Online Database Migration
– Converting Single Instance to RAC One Node
– Implementing Oracle Database In-Memory in RAC
– Multitenant Architecture in RAC: CDBs and PDBs

Quality of Service (QoS) Management

– QoS Management Concepts and Benefits
– QoS Components and Functionality