Oracle Database 19c - RAC, ASM, and Grid Infrastructure Administration

• Basic understanding of Oracle database administration
• Familiarity with SQL and PL/SQL

Audience

• Database administrators
• IT professionals

Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration refers to the comprehensive set of tools, technologies, and processes used to manage and optimize Oracle's Real Application Clusters (RAC), Automatic Storage Management (ASM), and Grid Infrastructure in an Oracle Database 19c environment. These components are critical for ensuring high availability, scalability, and efficient resource management in complex, enterprise-level database systems.

This instructor-led, live training (online or onsite) is aimed at intermediate-level database administrators who wish to manage and optimize complex, high-availability Oracle database environments.

By the end of this training, participants will be able to:

• Gain a comprehensive understanding of Oracle RAC architecture and Grid Infrastructure, including installation, configuration, and management.
• Develop practical skills in managing Automatic Storage Management (ASM), including disk group management, instance tuning, and backup/recovery.
• Learn advanced RAC performance tuning techniques, disaster recovery configurations, and best practices for high availability.
• Acquire troubleshooting and diagnostic skills for resolving issues in RAC and Grid Infrastructure environments.
• Understand the process of patching and upgrading Oracle RAC and Grid Infrastructure while minimizing downtime and maintaining system stability.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction

Overview of Oracle Real Application Clusters (RAC)

• Introduction to Oracle RAC and its architecture
• Benefits of RAC in high availability and scalability
• Key components of RAC: Cluster nodes, Clusterware, and ASM

Grid Infrastructure Fundamentals

• Understanding Oracle Grid Infrastructure
• Role of Oracle Clusterware in RAC
• Overview of Automatic Storage Management (ASM)

Installing Oracle Grid Infrastructure

• Hardware and software prerequisites for Grid Infrastructure
• Installation and configuration of Oracle Grid Infrastructure
• Configuring network and storage for RAC

Preparing the Environment for RAC

• Preparing shared storage with ASM
• Configuring the network environment for RAC
• Setting up SSH equivalency and user environments

Installing Oracle RAC

• Step-by-step RAC installation process
• Post-installation tasks for Oracle RAC
• Verifying RAC installation and troubleshooting common issues

Administering RAC Databases

• Creating and managing RAC databases
• RAC-specific administration tasks
• Understanding RAC database instances and services

Oracle Clusterware Administration

• Managing Clusterware components: Voting disks and OCR
• Configuring and managing High Availability Services (HAS)
• Monitoring and troubleshooting Clusterware

RAC Backup and Recovery

• Backup strategies for RAC environments
• Performing backup and recovery in RAC
• Using RMAN for RAC databases

Introduction to ASM

• Understanding the architecture and benefits of ASM
• ASM components: Disk groups, disks, and ASM instances
• Installing and configuring ASM

Administering ASM Disk Groups

• Creating and managing ASM disk groups
• ASM disk group redundancy and performance
• Monitoring and maintaining ASM disk groups

ASM Instance Management

• Starting and stopping ASM instances
• ASM instance parameters and tuning
• ASM and Clusterware integration

ASM Backup and Recovery

• Backup and recovery strategies for ASM
• Using RMAN with ASM
• Best practices for ASM management

RAC Performance Tuning

• Tuning RAC database performance
• Monitoring and optimizing RAC workloads
• Using Oracle Enterprise Manager for RAC performance tuning

High Availability and Disaster Recovery in RAC

• Implementing Oracle Data Guard with RAC
• Configuring RAC for disaster recovery
• RAC failover and switchover scenarios

RAC Troubleshooting and Diagnostics

• Diagnosing and resolving RAC issues
• Using Clusterware diagnostics and logs
• Best practices for RAC troubleshooting

Patching and Upgrading RAC and Grid Infrastructure

• Patching RAC databases and Grid Infrastructure
• Performing rolling upgrades in RAC environments
• Downtime minimization techniques during upgrades

Advanced ASM Features

• Implementing ASM Flex and Flex Clusters
• ASM cluster file system (ACFS) overview and configuration
• ASM monitoring and alerting mechanisms

Advanced Grid Infrastructure Administration

• Configuring and managing Oracle Flex Clusters
• Managing Clusterware resources and services
• Using Oracle Cluster Registry (OCR) and voting disk management

Securing RAC and Grid Infrastructure

• Implementing security best practices in RAC environments
• Configuring ASM security features
• Managing user roles and privileges in Grid Infrastructure

Best Practices for RAC, ASM, and Grid Infrastructure

• High availability and scalability best practices
• Performance optimization strategies
• Implementing automation for RAC and ASM management

Summary and Next Steps