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
Understanding Backup and Standby for RAC Databases