Oracle DBA RAC (10g, 11g)

1. Introduction 

• What is a ClusterOracle Real Application Clusters (RAC)

• Advantage of using RAC

• Clusters High Availability, Scalability and Performance

• Oracle Real Application Clusters Architecture

• Cache fusion

• Multi instance transaction behaviour

• Extra background process in RAC

2. Installation of Oracle Clusterware (CRS) and configuration

• Oracle RAC 10g Installation: Outline

• Pre-Installation Tasks

• Hardware Requirements

• Network Requirements

• The oracle User Environment Setup & User Shell Limits

• Linux Operating System Parameters

• Cluster Setup Tasks

• Storage for Cluster

• Oracle Cluster Registry File

• Voting Disk File

• Verifying the Oracle Clusterware Installation

• Cluster verify utility (CLUVFY)

3. ASM with RAC

• ASM Overview

• Installation of ASM Instances

• Managing ASM Disk Groups and Instances.

• ASM Instance and Crash Recovery in RAC

4. RAC Software Installation & Database Creation

• Oracle database software installation

• Cluster database creation

• Post installation tasks

5. Oracle Clusterware Administration & Debugging

• Oracle Cluster registry (OCR)

• Voting disk

• VIP Addresses

• Debugging Clusterware log files

• Workload distribution

• Transparent application failover

 6. RAC Administration 

• Starting and Stopping RAC Instances

• Creating and Registering Instances

• Transparent Application Failover (TAF)

• Database files with RAC

• Initialization Parameter Files

• Trace & Alert logs.

• Undo management

• Temporary table space monitoring

7. RAC Services

• What is a Service

• Advantage of using service

• Possible service configuration

• Creation and maintenance of services using SRVCTL, DBCA,EM

• Statistics gathering and tracing to check performance of Services

• Service performance views

• Workload distribution

• Transparent application failover

8. Performance Monitoring

• Finding & Monitoring the Sessions

• Session and system statistics

• Finding and Resolving Locks across Instances

• Cache Fusion impact & events in RAC

• Wait events & Wait event views

• Generating AWR Snapshots & Reports in RAC

• Doing ADDM analysis

9. Backup and Recovery in RAC

• Protecting Against Media Failure

• Archived Log File Configurations & Conventions

• RAC and the Flash Recovery Area

• Oracle Recovery Manager

• Distribution of Backups

 10. Workshop

• Single instance to RAC conversion

• Cloning a RAC Instance

• No archive log to Archive log conversion

• Node addition and deletion

• Patching RAC software and Clusterware