Get in Touch

Course Outline

Introduction

Introduction to Oracle Real Application Clusters (RAC)

  • Overview of Oracle RAC and its underlying architecture
  • Advantages of RAC regarding high availability and scalability
  • Core RAC elements: Cluster nodes, Clusterware, and ASM

Fundamentals of Grid Infrastructure

  • Grasping the concept of Oracle Grid Infrastructure
  • The function of Oracle Clusterware within RAC
  • A look at Automatic Storage Management (ASM)

Installing Oracle Grid Infrastructure

  • Hardware and software requirements for Grid Infrastructure
  • Installing and configuring Oracle Grid Infrastructure
  • Setting up network and storage for RAC

Preparing the Environment for RAC

  • Setting up shared storage using ASM
  • Configuring the network setup for RAC
  • Establishing SSH equivalency and user environments

Installing Oracle RAC

  • Detailed walkthrough of the RAC installation process
  • Post-installation procedures for Oracle RAC
  • Validating RAC installation and addressing common issues

Managing RAC Databases

  • Setting up and overseeing RAC databases
  • Specific administrative tasks for RAC
  • Comprehending RAC database instances and services

Oracle Clusterware Management

  • Overseeing Clusterware elements: Voting disks and OCR
  • Setting up and managing High Availability Services (HAS)
  • Monitoring and diagnosing Clusterware

RAC Backup and Recovery

  • Backup approaches for RAC setups
  • Executing backup and recovery in RAC
  • Utilizing RMAN for RAC databases

Introduction to ASM

  • Understanding ASM's architecture and benefits
  • Key ASM components: Disk groups, disks, and ASM instances
  • Installing and configuring ASM

Managing ASM Disk Groups

  • Creating and overseeing ASM disk groups
  • Redundancy and performance of ASM disk groups
  • Monitoring and upkeep of ASM disk groups

Managing ASM Instances

  • Starting and halting ASM instances
  • ASM instance parameters and optimization
  • Integration between ASM and Clusterware

ASM Backup and Recovery

  • Backup and recovery methods for ASM
  • Working with RMAN alongside ASM
  • Best practices for ASM administration

Optimizing RAC Performance

  • Tuning the performance of RAC databases
  • Monitoring and refining RAC workloads
  • Leveraging Oracle Enterprise Manager for RAC performance tuning

High Availability and Disaster Recovery in RAC

  • Setting up Oracle Data Guard with RAC
  • Preparing RAC for disaster recovery
  • Scenarios for RAC failover and switchover

RAC Troubleshooting and Diagnostics

  • Identifying and resolving RAC problems
  • Utilizing Clusterware diagnostics and logs
  • Best practices for troubleshooting RAC

Patching and Upgrading RAC and Grid Infrastructure

  • Applying patches to RAC databases and Grid Infrastructure
  • Carrying out rolling upgrades in RAC settings
  • Strategies to reduce downtime during upgrades

Advanced ASM Capabilities

  • Deploying ASM Flex and Flex Clusters
  • Overview and setup of ASM cluster file system (ACFS)
  • Monitoring and alerting mechanisms for ASM

Advanced Grid Infrastructure Administration

  • Configuring and overseeing Oracle Flex Clusters
  • Managing Clusterware resources and services
  • Utilizing Oracle Cluster Registry (OCR) and managing voting disks

Securing RAC and Grid Infrastructure

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

Best Practices for RAC, ASM, and Grid Infrastructure

  • Best practices for high availability and scalability
  • Strategies for performance optimization
  • Implementing automation for RAC and ASM management

Summary and Next Steps

Requirements

  • Foundational knowledge of Oracle database administration
  • Competency in SQL and PL/SQL

Audience

  • Database administrators
  • IT professionals
 35 Hours

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories