| Oracle
10gR2 DBA: Real Application Clusters |
| |
| Duration:
5 Days |
| |
| Description: |
With every release of Oracle, the architecture behind RAC implementation has been changing significantly to provide a more robust and intelligent solution towards Oracle grid strategy. This course discusses Oracle 10g Release 2 features in a RAC implementation. The course covers architecture, design, implementation and administration features specifically to a RAC environment Topics covered include partitioning, indexes, tablespace management, transaction management, backup and recovery principles. Performance tuning with examples, troubleshooting and problem solving scenarios are covered, as well as discussions on the migration process from a single instance database to RAC or upgrade process from Oracle 9i Release 2 RAC environment to an Oracle 10g Release 2 environment.
This course on Oracle Real Application Clusters will enlighten and
educate students on RAC operations, cache fusion, fusion recovery processes and the fast reconfiguration of RAC. The course will llok at the storage subsystem using both ASM and non-ASM which includes OCFS 2.0 and other third party clustered file systems.
In this hands-on course the students will learn to configure and
manage a RAC database environment. The course also includes detailed
discussions on Oracle's Cluster File System (OCFS), Automatic Stroage Management (ASM) and Oracle Clusterware |
| |
|
|
Audience:
|
 |
Database Administrators |
| |
|
Required Prerequisites:
|
|
Oracle 10g DBA: Architecture and Administration |
|
Oracle 10g DBA: Backup and Recovery |
| |
|
Suggested Prerequisites:
|
|
Oracle 10g 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 10g RAC using FAN and TAF |
|
Learn tips and techniques regarding RAC and ASM |
|
Learn the best practices |
| |
|
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) |
| |
|
RAC Architecture
|
| |
|
|
Background processes |
| |
|
|
Foreground processes |
| |
|
|
Undo Management |
| |
|
RAC Storage Management
|
| |
|
|
RAW |
| |
|
|
Clustered File System |
| |
|
|
Automatic Storage Management (ASM) |
| |
|
Transaction Management
|
| |
|
|
Transaction life cycle in a single
instance |
| |
|
|
Transaction life scenarios
in RAC |
| |
|
Installation and Configuration
|
| |
|
|
OCFS install |
| |
|
|
Oracle Clusterware install |
| |
|
|
RAW device configuration |
| |
|
|
ASM installation and Configuration |
| |
|
|
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
|
| |
|
|
Migration Steps - Single Instance to RAC |
| |
|
|
Upgrade Steps - 9iR2 RAC to 10gR2 RAC |
| |
|
Backup and Recovery
|
| |
|
|
Configuring RMAN |
| |
|
|
Backup and Recovery steps |
| |
|
Performance Tuning – Tools and Utilities
|
| |
|
|
Grid Control |
| |
|
|
Automatic Workload Repository (AWR) |
| |
|
|
AWR Vs. STATSPACK |
| |
|
|
Automatic Diagnostic Monitor (ADDM) |
| |
|
|
ASH for RAC |
| |
|
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
|
|
|
