Capability Development / Database & DataScience
Oracle RAC Administration Workshop
This advanced workshop develops the specialized skills needed to install, configure, and administer Oracle Real Application Clusters (RAC) for high availability and scalability. Participants explore Grid Infrastructure and ASM foundations, RAC installation and single-instance-to-RAC conversion, and day-to-day RAC administration including services, backup and recovery, and patching. The course dives deep into global resource management and cache fusion, RAC-specific performance monitoring and tuning, and high-availability features such as FAN, TAF, Transaction Guard, and Application Continuity. Coverage extends to Oracle RAC One Node, multitenant RAC configurations, In-Memory in RAC, and Quality of Service Management, preparing participants to run mission-critical clustered Oracle databases.
Program Overview
This advanced workshop develops the specialized skills needed to install, configure, and administer Oracle Real Application Clusters (RAC) for high availability and scalability. Participants explore Grid Infrastructure and ASM foundations, RAC installation and single-instance-to-RAC conversion, and day-to-day RAC administration including services, backup and recovery, and patching. The course dives deep into global resource management and cache fusion, RAC-specific performance monitoring and tuning, and high-availability features such as FAN, TAF, Transaction Guard, and Application Continuity. Coverage extends to Oracle RAC One Node, multitenant RAC configurations, In-Memory in RAC, and Quality of Service Management, preparing participants to run mission-critical clustered Oracle databases.
Audience Profile
Senior Oracle DBAs responsible for clustered, high-availability systems; Infrastructure engineers deploying Oracle Grid Infrastructure and RAC; DBAs preparing for Oracle RAC and high-availability certification; and Teams supporting mission-critical, always-on database platforms.
Course Syllabus
Module 1: Grid Infrastructure: Overview
Topics
- Clusters, clusterware, and Oracle Flex Clusters
- Cluster configuration options and clusterware architecture
- GPnP architecture and the Grid Naming Service (GNS)
- Oracle ASM, ACFS, and Oracle Flex ASM
Labs / Practice
- Explore Grid Infrastructure components and configuration options
Module 2: RAC Databases Overview and Architecture
Topics
- Oracle RAC architecture and Oracle RAC One Node
- Cluster-aware storage and network connectivity
- Benefits of RAC: scalability, scaleup, and speedup
- Global resources and additional memory requirements for RAC
Module 3: Installing and Configuring Oracle RAC
Topics
- Installing Oracle Database software and creating the cluster database
- Database type, storage, and configuration options
- Post-installation tasks and RAC-specific background processes
- Converting a single-instance database to RAC using DBCA and rconfig
Labs / Practice
- Install and configure an Oracle RAC database
Module 4: Oracle RAC Administration
Topics
- Enterprise Manager Cloud Control for RAC administration
- Redo logs, undo management, and local temporary tablespaces in RAC
- Starting and stopping RAC instances and PDBs with srvctl and SQL*Plus
- RAC initialization parameters and Transparent Data Encryption in RAC
Labs / Practice
- Administer and monitor a RAC database using Enterprise Manager and srvctl
Module 5: Upgrading and Patching Oracle RAC
Topics
- Patches and patch sets: types and sources
- RAC patching methods: out-of-place upgrades and rolling patches
- Using OPatch and OPatch automation
- Queryable patch inventory
Module 6: Managing Backup and Recovery for RAC
Topics
- Instance recovery and media failure protection in RAC
- Parallel recovery and the Fast Recovery Area in RAC
- Configuring RMAN channels, autolocation, and backup distribution
- Managing archived redo logs across RAC nodes
Labs / Practice
- Configure and test RMAN backup and recovery in a RAC environment
Module 7: Global Resource Management Concepts
Topics
- Global concurrency control and the Global Resource Directory (GRD)
- Global resource remastering and recovery
- Global enqueues and instance locks
- Global Cache Management and cache fusion scenarios
Module 8: RAC Database Monitoring and Tuning
Topics
- CPU and wait time tuning dimensions for RAC
- Analyzing cache fusion impact and global cache wait events
- Common RAC tuning tips: index, undo, and high-water mark considerations
- Monitoring RAC with AWR, ASH, ADDM, and the Cluster Health Advisor
Labs / Practice
- Monitor and tune RAC database and cluster performance
Module 9: Managing High Availability of Services
Topics
- Oracle Services and service characteristics in RAC
- Creating and managing services with Enterprise Manager and SRVCTL
- Services with client applications, Resource Manager, and the Scheduler
- Service thresholds, alerts, and distributed transactions
Labs / Practice
- Create and manage high-availability services for a RAC database
Module 10: High Availability for Connections and Applications
Topics
- Client-side connect-time load balancing
- Fast Application Notification (FAN) and the Load Balancing Advisory
- Transparent Application Failover (TAF) configuration
- Transaction Guard and Application Continuity
Labs / Practice
- Configure FAN, TAF, and Application Continuity for high availability
Module 11: Oracle RAC One Node
Topics
- Creating and verifying an Oracle RAC One Node database
- Online relocation and rolling patch maintenance
- Converting between RAC One Node and full RAC configurations
Labs / Practice
- Create and manage an Oracle RAC One Node database
Module 12: Oracle Database In-Memory in RAC
Topics
- In-Memory Column Store pools and implementation in RAC
- Prioritizing in-memory population
- In-Memory FastStart architecture in a RAC environment
Labs / Practice
- Implement and monitor In-Memory Column Store in RAC
Module 13: Multitenant Architecture and RAC
Topics
- Non-CDB versus multitenant CDB architecture
- Creating a RAC CDB and hosting it in server pools
- Connecting via CDB/PDB services and managing PDB services
- Adding and dropping PDBs from a RAC CDB
Labs / Practice
- Create and manage a multitenant RAC CDB
Module 14: Quality of Service Management
Topics
- QoS Management background, overview, and Exadata integration
- Server pools, performance classes, and classification
- Performance policies, objectives, and satisfaction metrics
- QoS Management architecture and recommendations