Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: ORACLE REAL APPLICATION CLUSTERS OVERVIEW

• Oracle RAC Features
• Oracle RAC Technology Hierarchy
• Oracle RAC Capabilities
• Oracle RAC Components
• Tools for Installing, Configuring and Managing Oracle RAC

Session 2: ORACLE GRID INFRASTRUCTURE OVERVIEW

• Cluster Overview
• Grid Foundation Components and Architecture
• Oracle Clusterware Components and RAC
• Oracle Clusterware Software and Storage
• Oracle Storage Subsystems
• File Types used by a RAC Database
• Methods used to Share Database Files across a Cluster
• ASM Architecture
• Create and Manage ASM Disk Groups
• Create and Manage ASM Cluster Filesystems
• An Overview of RAC Services
• Network Requirements and Configuration
• Single Client Access Names
• Overview of Grid Plug and Play

Session 3: RAC INSTALLATION AND CONFIGURATION TASKS

• Oracle RAC Pre-installation Tasks
• Job Role Separation
• Create Oracle Groups, User Accounts and Directories
• Validate and Prepare the Hardware and the Operating System
• Configure RAC Nodes for Remote Access using SSH
• Configure the Network for RAC
• Configure the Startup Commands for the Oracle RAC Nodes
• Install and Configure ASMLIB

Session 4: INSTALL ORACLE GRID INFRASTRUCTURE AND REAL APPLICATION CLUSTERS

• Install the Oracle Grid Infrastructure
• Use the Cluster Verification Utility
• Install Oracle Database Software and Create a Cluster Database
• Verify the Installation
• Post Installation Tasks
• Configure Client Connections with Oracle Net Manager
• Convert an Oracle Database to a RAC Database
• Use the DBCA for Single Instance Conversion
• Use rconfig for Single Instance Conversion
• RAC Specific Background Processes

Session 5: RAC CLUSTER DATABASE AND DATABASE INSTANCE ADMINISTRATION

• Administer Oracle RAC using Enterprise Manager
• Policy Managed and Administrator Managed Databases
• RAC Initialization Parameters
• Manage Undo Tablespaces in a RAC Environment
• Manage Redo Log Files and Groups in a RAC Environment
• Oracle Enterprise Manager Cluster Database Pages
• Start and Stop Oracle RAC Databases and Instances
• Administer Database Storage

Session 6: ADMINISTER ORACLE CLUSTERWARE COMPONENTS

• CRS Resources and Daemon Functionality
• Manage Clusterware with Enterprise Manager
• CRSCTL Commands to Stop, Start and Administer Clusterware
• Backup and Recover Voting Disks
• Add and Remove Voting Disks
• The ocrcheck Utility
• The ocrdump Command
• Administer the Oracle Cluster Registry (OCR)
• Locate OCR Automatic Backups
• Backup and Restore OCR
• Troubleshoot the OCR with ocrcheck

Session 7: ASM INSTANCE ADMINISTRATION

• ASM Overview
• ASM Components in RAC
• ASM Initialization Parameters
• Create an ASM Instance using ASMCA
• Start and Stop an ASM Instance using srvctl
• Start and Stop an ASM Instance using ASMCMD and ASMCA
• Start and Stop an ASM Instance Containing Cluster Files
• Start and Stop the ASM Listener

Session 8: ASM DISK GROUP ADMINISTRATION

• Create and Delete ASM Disk Groups
• ASM Disk Group Attributes
• ASM Disk Group Maintenance Tasks
• Preferred Read Failure Groups
• ASM Disk Statistics

Session 9: RAC MANAGEMENT COMMANDS

• RAC Management Commands
• RAC Administration with SVRCTL
• SVRCTL Cluster Database Configuration Tasks
• SVRCTL Cluster Database Administration Tasks
• Check the Current Configuration
• SVRCTL Command Summary
• Administer Databases and Instances
• Administer Services and Node Applications
• Bring a Cluster Database online and offline
• Introduction to CRS
• Cluster Services

Session 10: MANAGING THE DATABASE WORKLOAD USING SERVICES

• Manage the Database Workload using Services
• Create and Administer Services in a RAC Environment
• Services and Client Applications
• Manage Services with Enterprise Manager and from the Command Line
• Configure Oracle Net to Support Services
• Configure Service Level Thresholds
• Configure Clients for Failover

Session 11: HIGH AVALABILITY OF CONNECTIONS

• RAC High Availability Framework
• Failure Detection with Cluster Services
• Oracle RAC and Hardware Failover
• Connection Failover
• Transparent Application Failover (TAF)
• Server, Client And Runtime Load Balancing
• Fast Application Notification (FAN)
• Server and Client Side Oracle Notification Services

Session 12: BACKUP AND RECOVER A RAC DATABASE

• Configure a Fast Recovery Area for use with RAC
• Tune Instance Recovery in RAC
• Parallel Recovery in RAC
• Initiate Archiving
• Configure RMAN Backup and Recovery Settings
• Backup a RAC Database using RMAN
• Restore and Recover a RAC Database using RMAN
• Display Backup Reports
• Best Practices and Tips for Backup and Recovery

Session 13: RAC PERFORMANCE TUNING

• Monitoring and Performance Guidelines
• RAC Monitoring Tools
• RAC Performance Recommendations
• Analyze Performance Issues
• Use the Automatic Workload Repository in RAC
• Use the Automatic Database Diagnostic Monitor in RAC
• Use Statspack with RAC
• Global Cache Services (GCS) Monitoring
• V$cache_transfer Views
• Monitor the GES Processes
• Monitor and Tune the RAC Cluster Environment using Enterprise Manager

Session 14: ADD AND DELETE NODES AND CLUSTERS

• Grid Plug and Play (GPnP)
• Prepare a New Node
• Extend the Oracle Grid Infrastructure Home to the New Node
• Extend the Oracle RAC Home Directory
• Add the New Node to the Cluster
• Create an Instance on the New Node
• Delete an Instance from the Cluster Database
• Remove a Node from the Cluster

Session 15: MANAGE ORACLE SOFTWARE AND APPLY PATCHES

• Configure the EM Patch Interface
• Obtain Patches
• Apply Rolling Patches to a RAC System
• Apply a Patchset with the opatch Utility
• Apply a Patchset with OUI