Oracle RAC

Oracle Real Application Clusters (Oracle RAC) is a clustered version of Oracle Database based on a comprehensive high-availability stack that can be used as the foundation of a database cloud system as well as a shared infrastructure, ensuring high availability, scalability, and agility for any application.

Overview

  • Clustered database deployments for high availability, performance, and agility
  • Oracle’s premier shared disk database clustering technology
  • Efficiently runs any packaged or custom application
  • Choice of administrator-managed or policy-managed deployments

Benefits

  • Runs all database workloads
  • Foundation for database clouds
  • Scale out and scale up on-demand
  • Highest availability for the database
  • Flexible workload management

Duration of Training : 8 weekends
Oracle RAC Syllabus

  • What is a Cluster
  • Grid Foundation Components
  • Oracle Clusterware Architecture
  • Oracle Clusterware Software and Storage
  • Describe ASM Architecture
  • Creating and Managing ASM Disk Groups
  • Creating and Managing ASM Cluster Filesystems
  • Grid Infrastructure Installation and Configuration
  • Hardware Requirements
  • Network Requirements
  • Post installation tasks
  • Administering Oracle Clusterware
  • Managing Clusterware with Enterprise Manager
  • Determining the Location of the Oracle Clusterware Configuration Files
  • Backing Up and Recovering the Voting Disk
  • Adding, Deleting, or Migrating Voting Disks
  • Locating the OCR Automatic Backups
  • Oracle Local Registry
  • Migrating OCR Locations to ASM
  • Managing Network Settings
  • Managing Oracle Clusterware
  • Prerequisite Steps for Extending a Cluster
  • Using addNode.sh to Add a Node to a Cluster
  • Rolling Patches, And Rolling Upgrades
  • Comparing Software Versions With the Active Version
  • Installing A Patchset With the OUI Utility
  • Installing A Patch With The opatch Utility
  • Oracle Clusterware High Availability
  • Oracle Clusterware high availability components
  • Contrasting policy-managed and administration managed databases
  • Troubleshooting Oracle Clusterware
  • Oracle Clusterware Log Files
  • Component-level Debugging
  • Troubleshooting the Oracle Cluster Registry
  • Administering ASM Instances
  • ASM Initialization Parameters
  • Adjusting ASM Instance Parameters in SPFILEs
  • Starting and Stopping ASM Instances Using srvctl
  • Starting and Stopping ASM Instances Using ASMCA and ASMCMD
  • Starting and Stopping ASM Instances Containing Cluster Files
  • Starting and Stopping the ASM Listener
  • Administering ASM Disk Groups
  • Creating And Deleting ASM Disk Groups
  • ASM Disk Group Attributes
  • ASM Disk Group Maintenance Tasks
  • Preferred Read Failure Groups
  • Viewing ASM Disk Statistics
  • Performance And Scalability Considerations For ASM Disk Groups
  • ASM Files, Directories, and Templates
  • Creating and Managing ASM files, Directories and Aliases
  • Administering ASM Cluster File Systems
  • ASM Dynamic Volume Manager
  • Managing ASM Volumes
  • Implementing ASM Cluster File System
  • Real Application Clusters Database Installation
  • Installing The Oracle Database Software
  • Creating A Cluster Database
  • Post–database Creation Tasks
  • Single-Instance Conversion Using the DBCA
  • Background Processes Specific to Oracle RAC
  • Oracle RAC Administration
  • Enterprise Manager Cluster Database Pages
  • Redo Log Files In A RAC Environment
  • Undo Tablespaces In A RAC Environment
  • Starting And Stopping RAC Databases And Instances
  • Initialization Parameters In A RAC Environment
  • Managing Backup and Recovery for RAC
  • Archived Log File Configurations
  • RAC Backup and Recovery Using EM
  • Archived Redo File Conventions in RAC
  • Monitoring and Tuning the RAC Database
  • Determining RAC-Specific Tuning Components
  • Tuning Instance Recovery in RAC
  • RAC-Specific Wait Events, Global Enqueues, and System Statistics
  • Implementing the Most Common RAC Tuning Tips
  • Using the Cluster Database Performance Pages
  • Using the Automatic Workload Repository in RAC
  • Using Automatic Database Diagnostic Monitor in RAC
  • Services
  • Configure and Manage Services in a RAC environment
  • Using Services with Client Applications
  • Managing Services From the Command Line
  • Maximum Availability Architecture