Oracle 19c RAC - Detailed Study Guide
1. Introduction to Oracle RAC
Oracle Real Application Clusters (RAC) allows multiple servers to run a single Oracle database,
providing high availability and scalability.
2. Architecture Overview
RAC consists of multiple database instances, shared storage, interconnect network, and
clusterware managing node communication.
3. Key Components
- Oracle Clusterware - Shared Disk Storage (ASM) - Cache Fusion - Global Cache Service (GCS) -
Global Enqueue Service (GES)
4. Installation Overview
Installation involves setting up grid infrastructure, configuring nodes, shared storage, and installing
database software across cluster nodes.
5. Administration Tasks
DBA tasks include instance management, monitoring cluster health, load balancing, failover
handling, and patching.
6. High Availability Features
RAC ensures continuous availability using node failover, service relocation, and automatic workload
distribution.
7. Performance Tuning
Involves interconnect optimization, load balancing, memory tuning, and reducing cache fusion
overhead.
8. Best Practices
- Use dedicated interconnect - Proper ASM configuration - Regular patching - Monitor cluster health
- Enable services for workload management