Get in Touch
 Duration 35 hours

Course Outline

Introduction

Oracle Real Application Clusters (RAC) Overview

  • Introducing Oracle RAC and its architectural design
  • Advantages of RAC regarding high availability and scalability
  • Core RAC elements: Cluster nodes, Clusterware, and ASM

Grid Infrastructure Basics

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

Deploying Oracle Grid Infrastructure

  • Hardware and software requirements for Grid Infrastructure
  • Installing and setting up Oracle Grid Infrastructure
  • Network and storage configuration for RAC

Preparing the Environment for RAC

  • Setting up shared storage using ASM
  • Network environment configuration for RAC
  • Establishing SSH equivalency and user settings

Installing Oracle RAC

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

Managing RAC Databases

  • Creation and administration of RAC databases
  • Administration tasks specific to RAC
  • Understanding RAC database instances and services

Oracle Clusterware Administration

  • Oversight of Clusterware components: Voting disks and OCR
  • Configuration and management of High Availability Services (HAS)
  • Clusterware monitoring and issue resolution

RAC Backup and Recovery

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

Introduction to ASM

  • Comprehending ASM architecture and its benefits
  • ASM elements: Disk groups, disks, and ASM instances
  • Installation and configuration of ASM

Managing ASM Disk Groups

  • Creation and management of ASM disk groups
  • ASM disk group redundancy and performance optimization
  • Monitoring and maintenance of ASM disk groups

ASM Instance Management

  • Starting and stopping ASM instances
  • Tuning ASM instance parameters
  • Integration of ASM with Clusterware

ASM Backup and Recovery

  • Backup and recovery methods for ASM
  • Using RMAN in conjunction with ASM
  • Best practices for ASM administration

RAC Performance Tuning

  • Optimizing RAC database performance
  • Monitoring and refining RAC workloads
  • Utilizing Oracle Enterprise Manager for RAC performance tuning

High Availability and Disaster Recovery in RAC

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

RAC Troubleshooting and Diagnostics

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

Patching and Upgrading RAC and Grid Infrastructure

  • Applying patches to RAC databases and Grid Infrastructure
  • Executing rolling upgrades in RAC settings
  • Techniques to minimize downtime during upgrades

Advanced ASM Capabilities

  • Implementing ASM Flex and Flex Clusters
  • Overview and setup of ASM cluster file system (ACFS)
  • ASM monitoring and alerting systems

Advanced Grid Infrastructure Administration

  • Configuration and management of Oracle Flex Clusters
  • Oversight of Clusterware resources and services
  • Utilizing Oracle Cluster Registry (OCR) and voting disk management

Securing RAC and Grid Infrastructure

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

Best Practices for RAC, ASM, and Grid Infrastructure

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

Summary and Future Directions

Requirements

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

Target Audience

  • Database administrators
  • IT specialists

Number of participants


Price per participant (excl. VAT)

Testimonials (1)

Upcoming Courses

Related Categories