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

Introduction

Overview of Oracle Real Application Clusters (RAC)

• Introduction to Oracle RAC and its underlying architecture.
• The advantages of RAC in ensuring high availability and scalability.
• Core components of RAC: Cluster nodes, Clusterware, and ASM.

Grid Infrastructure Fundamentals

• Understanding the Oracle Grid Infrastructure.
• The role of Oracle Clusterware within RAC.
• An overview of Automatic Storage Management (ASM).

Installing Oracle Grid Infrastructure

• Hardware and software prerequisites for Grid Infrastructure.
• Installation and configuration procedures for Oracle Grid Infrastructure.
• Configuring network and storage resources for RAC.

Preparing the Environment for RAC

• Setting up shared storage using ASM.
• Configuring the network environment to support RAC.
• Establishing SSH equivalency and user environment settings.

Installing Oracle RAC

• Step-by-step guide to the RAC installation process.
• Essential post-installation tasks for Oracle RAC.
• Verifying the RAC installation and resolving common issues.

Administering RAC Databases

• Creating and managing databases within an RAC environment.
• Specific administrative tasks unique to RAC.
• Understanding RAC database instances and associated services.

Oracle Clusterware Administration

• Managing Clusterware components: Voting disks and OCR.
• Configuring and overseeing High Availability Services (HAS).
• Monitoring Clusterware and addressing potential issues.

RAC Backup and Recovery

• Formulating backup strategies tailored to RAC environments.
• Executing backup and recovery operations in RAC.
• Utilizing RMAN for RAC database management.

Introduction to ASM

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

Administering ASM Disk Groups

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

ASM Instance Management

• Starting and stopping ASM instances.
• Configuring ASM instance parameters and tuning.
• Integration of ASM with Clusterware.

ASM Backup and Recovery

• Developing backup and recovery strategies for ASM.
• Using RMAN in conjunction with ASM.
• Best practices for effective ASM management.

RAC Performance Tuning

• Techniques for tuning RAC database performance.
• Monitoring and optimizing workloads in a RAC setup.
• Leveraging Oracle Enterprise Manager for RAC performance tuning.

High Availability and Disaster Recovery in RAC

• Implementing Oracle Data Guard alongside RAC.
• Configuring RAC specifically for disaster recovery scenarios.
• Managing RAC failover and switchover operations.

RAC Troubleshooting and Diagnostics

• Diagnosing and resolving issues within RAC.
• Utilizing Clusterware diagnostics and log analysis.
• Industry best practices for RAC troubleshooting.

Patching and Upgrading RAC and Grid Infrastructure

• Applying patches to RAC databases and Grid Infrastructure.
• Executing rolling upgrades in RAC environments.
• Strategies for minimizing downtime during upgrade processes.

Advanced ASM Features

• Implementing ASM Flex and Flex Clusters.
• Overview and configuration of the ASM cluster file system (ACFS).
• Setting up ASM monitoring and alerting mechanisms.

Advanced Grid Infrastructure Administration

• Configuring and managing Oracle Flex Clusters.
• Administering Clusterware resources and services.
• Managing the Oracle Cluster Registry (OCR) and voting disks.

Securing RAC and Grid Infrastructure

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

Best Practices for RAC, ASM, and Grid Infrastructure

• Best practices for ensuring high availability and scalability.
• Strategies for performance optimization.
• Automating RAC and ASM management tasks.

Summary and Next Steps