Note: This is Base Content and may change based on requirements

Oracle DBA RAC

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 behavior

Ø  Extra background process in RAC

2. Installation of Oracle Clusterware (CRS) and configuration 

Ø  Oracle RAC 11g 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

Ø  g. Workload distribution

Ø  h. 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 and Case Studies

Ø  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