RAC IN ORACLE 10g

Introduction to RAC and Grid Computing
Implement One from Many
Manage Many as One
Oracle Enterprise Manager 10g Grid Control
Oracle Database 10g: The Database for the Grid
What Is Oracle Real Application Clusters?
Clusters and Scalability
Typical Cluster Stack with RAC
Speedup/Scaleup and Workloads

RAC Architecture
The Necessity of Global Resources
Global Dynamic Performance Views
Additional Memory Requirement for RAC
Parallel Execution with RAC
RAC Software Storage Principles & Database Storage Principles
Global Resources Coordination
Object Affinity and Dynamic Remastering
RAC and Instance/Crash Recovery

RAC and Shared Storage
Oracle Cluster File System
Automatic Storage Management: General Architecture, Disk Group, Key Features, Benefits and New Concepts
Disk Group: Mirroring & Dynamic Rebalancing
Database Storage Consolidation
ASM Instance and Crash Recovery in RAC
ASM: Administration Page
ASM Scalability
Demos: Install ASM in its own home directory in a RAC

Installation and Administration Basics
Oracle RAC 10g Installation: Outline
Pre-installation Tasks
Verifying Cluster Setup With cluvfy
Installing Oracle Clusterware & Automatic Storage Management
Verifying the Oracle Clusterware Installation
Create a RAC Database
Cloning
Conversion from single-instance to RAC
RAC Performance Tuning
RAC-Specific Tuning
Most Common RAC Tuning Tips
Cluster Database Performance Page
Cluster Cache Coherency Page
Cluster Interconnects Page
RAC-Specific ADDM Findings
ADDM Analysis Results
Demos: Use ADDM to identify issues with free list segments and sequences

Services
Traditional Workload Dispatching
Grid Workload Dispatching
Data Warehouse Example
RAC and Data Warehouse: An Optimal Solution
High Availability of Services in RAC
Possible Service Configuration with RAC
Service Aggregation and Tracing
Connection Load Balancing in RAC

Oracle Clusterware
Oracle Clusterware Runtime View
Virtual IP Addresses and RAC
OCR Architecture
OCR Contents and Organization
Automatic OCR Backups
OCR Considerations
The One Golden Rule in RAC Debugging
Diagnostics Collection Script

Design for High Availability
Causes of Planned & Unplanned Down Time
Oracle’s Solution to Down Time
RAC and Data Guard Complementarity
Maximum Availability Architecture
RAC and Data Guard: Topologies & Architecture
Data Guard Broker (DGB) and Oracle Clusterware (OC) Integration
Hardware Assisted Resilient Data
Which RAID Configuration for Best Availability?