Course Details

Oracle RAC Online Training

Oracle Real Application Cluster Course Overview:

Oracle RAC allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing clustering.

In a non-RAC Oracle database, a single instance accesses a single database. The database consists of a collection of data files, control files, and redo logs located on disk. The instance comprises the collection of Oracle-related memory and operating system processes that run on a computer system.

In an Oracle RAC environment, 2 or more computers (each with an Oracle RDBMS instance) concurrently access a single database. This allows an application or user to connect to either computer and have access to a single coordinated set of data.

• Introduction to Real Application Clusters
• What is Cluster
• Types of Cluster & Cluster products
• Oracle Grid Infrastructure principles and Purpose
• Differences between single instance database and RAC database

Oracle RAC  Course Content:

Oracle Clusterware Architecture

• Global Resource Coordination in RAC
• Cache Fusion & Data Coherency Concepts
• RAC Background Processes & Daemons
• Different Layers of RAC

Shared Storage Configuration for Grid Infrastructure Installation

• Introduction to ASM and OCFS2 Cluster File system
• Creating OCFS2 File system
• Creating and Administering ASM Instances
• Manage ASM instances and associated processes
• Monitor ASM using the V$ASM dynamic performance views
• Create and delete ASM disks & disk groups
• Administering ASM Files, Directories
• Use different client tools to access ASM files(asmcmd)
• Describe the format of a fully qualified ASM filename
• Explain how ASM files, directories and aliases are
• created and managed

Grid Infrastructure Installation

• Perform pre-install tasks for Grid Infrastructure
• Install Grid Infrastructure & Verify
• Real Application Clusters Database Installation
• Install the Oracle database software
• Create a cluster database
• Perform post-database creation tasks

RAC Database Administration

• Using Common Pfile and Spfile
• Global Parameters & RAC-Specific Parameters
• Database Creation in RAC
• Managing Redo Logs
• Managing Undo Table spaces
• Using GV$ views

Administering Oracle Clusterware

• Using Server Control Utility(SRVCTL)
• Using Cluster Ready Services Control(CRSCTL)
• Creating and Administering ACFS
• Administer ASM Dynamic Volume Manager
• Implement ASM Cluster File System
• Manage ASM Cluster File System (ACFS)
• Using command line tools to Manage ACFS

Services & Workload Management

• Configure client-side,
• Connect-time load balancing and connect-time failover
• Configure server-side, connect-time load balancing
• Use the Load Balancing Advisory (LBA)
• Describe the benefits of Fast Application Notification (FAN)
• Configure Transparent Application Failover (TAF)

Applying Patch and Clusterware Upgrade

• CPU and PSU patches
• In place and Out of place upgrades
• Rolling Patching
• Applying Opatch

Managing Backup and Recovery for RAC

• OCR & Voting disk Backup & Restoration
• Managing Backup and Recovery for RAC Database
• Configure the RAC database to use Archive log mode and the flash recovery area
• Recover from media failure and instance failures
• Configure RMAN for the RAC environment
• Converting Database from Non-RAC to RAC
• Adding and Deleting Cluster nodes

Troubleshooting Oracle Clusterware

• Locate Oracle Clusterware log files
• Gather all log files using diagcollection.pl
• Enable resource debugging
• Enable component-level debugging
• Enable tracing for Java-based tools
• Troubleshoot the Oracle Cluster Registry(OCR) file

RAC DB Monitoring and Tuning

• Automated Workload Management (AWR)
• Automatic Database Diagnostic Management (ADDM)
• Determine RAC-specific tuning components