| Oracle
11gR1 DBA: Real Application Clusters |
| |
| Duration:
5 Days |
| |
| Description: |
With every release of Oracle, the architecture behind RAC implementation has changed to provide a more robust and intelligent solution towards Oracle's grid strategy. This course discusses Oracle 11g Release 1 features in a RAC implementation with respect to usage and design considerations. Areas covered include performance tuning with examples, troubleshooting and problem solving.
This course on RAC will enlighten and
educate students on the internals of RAC operations, cache fusion and the fast reconfiguration of RAC.
Course will look at the storage subsystem using both ASM and non-ASM which includes OCFS2.0 and other cluster file system options.
In this hands-on course the students will learn to configure and manage a RAC database environment. |
| |
|
|
Audience:
|
 |
Database Administrators |
| |
|
Required Prerequisites:
|
|
Oracle 11g DBA: Architecture and Administration |
|
Oracle 11g DBA: Backup and Recovery |
| |
|
Suggested Prerequisites:
|
|
Oracle 11g DBA: Performance Tuning |
| |
|
Course Objectives:
|
|
Understand how to implement, test and tune Real Application Clusters |
|
Learn appropriate uses of RAC and ASM |
|
Learn day-to-day functions and operations regarding RAC and ASM |
|
Learn the new service oriented architecture (SOA) in Oracle 11g RAC using FAN and TAF |
|
Gain exposure to the Internals of RAC and ASM |
| |
|
Course Topics
|
|
Part I: Concepts |
| |
|
Business Requirements |
| |
|
Hardware Concepts |
| |
|
|
Hardware Architectures
- SMP, MPP, NUMA, clustered SMP |
| |
|
|
Interconnect Architectures, GigE,
Infiniband, Virtual Interface, |
| |
|
|
Storage Subsystems, RAID 1, RAID
10, RAID 5, SAME, SAN Vs. NAS, |
| |
|
|
FileSystem Vs RAW -Oracle Clustered
File System |
| |
|
Oracle Concepts
|
| |
|
|
Oracle Architecture |
| |
|
|
Background Processes |
| |
|
|
Foreground Processes |
| |
|
|
SGA |
| |
|
|
Clustering Concepts |
| |
|
|
Grid Computing Concepts |
|
Part II: Architecture |
| |
|
Oracle Clusterware
|
| |
|
|
Cluster Synchronization Services (CSS) |
| |
|
|
Cluster Ready Services (CRS) |
| |
|
|
Event Manager (EVM) |
| |
|
|
Oracle Notification Services (ONS) |
| |
|
|
Oracle Clusterware Internals |
| |
|
|
Oracle Clusterware Components |
| |
|
RAC Architecture
|
| |
|
|
Background processes |
| |
|
|
Foreground processes |
| |
|
|
Undo Management |
| |
|
|
Cache Fusion Enhancements |
| |
|
RAC Storage Management
|
| |
|
|
Clustered File System |
| |
|
|
Automatic Storage Management (ASM) |
| |
|
Transaction Management
|
| |
|
|
Transaction life scenarios
in RAC |
| |
|
Parallel Processing
|
| |
|
|
Parallel Processing in a Single Instance |
| |
|
|
Parallel Processing Across Multiple Instances |
| |
|
Installation and Configuration
|
| |
|
|
OCFS Install |
| |
|
|
Oracle Clusterware Install |
| |
|
|
RAW Device Configuration |
| |
|
|
ASM Install |
| |
|
|
Oracle RDBMS Installation |
| |
|
|
Adding Instances Dynamically |
| |
|
Parameters and Views
|
|
Part III: Operations |
| |
|
Availability and Scalability
|
| |
|
|
Services |
| |
|
|
Distributed Workload Management |
| |
|
|
Transparent Application Failover (TAF) |
| |
|
|
Fast Application Notification (FAN) |
| |
|
|
Load Balancing |
| |
|
|
Maximum Availability Architecture |
| |
|
Migration
|
| |
|
Cluster Administration
|
| |
|
Recovery Architecture
|
| |
|
|
Types of Recovery |
| |
|
|
Instance Recovery |
| |
|
|
Media Recovery |
| |
|
|
Crash Recovery |
| |
|
Performance Testing
|
| |
|
Performance Tuning – Tools and Utilities
|
| |
|
|
Grid Control |
| |
|
|
Automatic Workload Repository (AWR) |
| |
|
|
Automatic Diagnostic Monitor (ADDM) |
| |
|
|
Tuning using V$ and GV$ Views |
| |
|
Performance Tuning – A Single Instance
|
| |
|
|
Oracle Wait Interface |
| |
|
|
Oracle Event Interface |
| |
|
Performance Tuning – The Cluster
|
| |
|
|
Tuning Interconnect |
| |
|
|
Tuning the Shared Storage |
| |
|
RAC Specific Wait Events
|
|
|
