| Oracle
9i DBA: Real Application Clusters |
| |
| Duration:
5 Days |
| |
| Description: |
Compared to its predecessor,
OPS, the architecture behind RAC implementation has changed significantly.
This course discusses Oracle9i features in a RAC implementation
with respect to usage and design considerations, as well as those
parameters that are and are not applicable. Areas 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.
This course on Oracle Real Application Clusters will enlighten and
educate students on the internals of RAC operations, cache fusion,
fusion recovery processes and the fast reconfiguration of RAC.
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) and Cluster Manager
used in a Linux environment |
| |
|
|
Audience:
|
 |
Database Administrators |
| |
|
Required Prerequisites:
|
|
Oracle 9i DBA: Architecture and Administration |
|
Oracle 9i DBA: Backup and Recovery |
| |
|
Suggested Prerequisites:
|
|
Oracle 9i DBA: Performance Tuning |
| |
|
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 |
|
Part II: Architecture |
| |
|
RAC Architecture
|
| |
|
|
Background processes |
| |
|
|
Foreground processes |
| |
|
|
Undo Management |
| |
|
Transaction Management
|
| |
|
|
Transaction life cycle in a single
instance |
| |
|
|
Transaction life scenarios
in RAC |
| |
|
Parallel Processing
|
| |
|
|
Parallel processing on a single instance |
| |
|
|
Parallel processing across
multiple instances |
| |
|
Designing Databases
|
| |
|
|
Partitioning |
| |
|
|
Advanced Queuing |
| |
|
|
Index types and usage |
| |
|
|
Dictionary Vs Locally Managed |
| |
|
Installation and Configuration
|
| |
|
|
OCFS install |
| |
|
|
Cluster Manager install |
| |
|
|
RAW device configuration |
| |
|
|
Oracle installation |
| |
|
|
Oracle cluster components |
| |
|
Parameters and Views
|
|
Part III: Operations |
| |
|
Availability and Scalability
|
| |
|
|
Transparent application failover |
| |
|
|
Load balancing |
| |
|
|
Maximum Availability |
| |
|
Migration
|
| |
|
|
Migration Steps |
| |
|
Backup and Recovery
|
| |
|
|
Configuring RMAN |
| |
|
|
Backup and Recovery steps |
| |
|
Performance Tuning – Tools and Utilities
|
| |
|
|
STATSPACK |
| |
|
|
OEM |
| |
|
Performance Tuning – A single instance
|
| |
|
|
Oracle Wait interface |
| |
|
|
Oracle Event interface |
| |
|
Performance Tuning – The cluster
|
| |
|
|
Tuning interconnect |
| |
|
|
Tuning the shared storage |
| |
|
Problem Diagnosis
|
| |
|
|
Working with Oracle Support |
| |
|
|
Common Errors |
| |
|
|
Other utilities |
|
|
