Overview of Cache Fusion

• Evolution of Cache Fusion & Nature of Cache Fusion

• Benefits of Cache Fusion & Concurrency and Consistency

• Cache Coherency & Global Cache Service

SGA Components and Locking

• SGA - System Global Area & Program Global Area

• Buffer Cache Management & What is a Dirty Block

• Multi – Version Consistency Model

RAC Components

• Global Cache Service & Global Enqueque Service

• Row-Level Locks & Global Resource Directory

• RAC Processes

Resource Coordination

• Synchronization & GCS Resource Modes and Roles

• Concept of Past Image & Lock Modes

• Block Access Modes and Buffer States

• Cache Fusion Scenarios & Block transfers using Cache Fusion – Examples

• Block Access, Grants, and Interrupts

Cache Fusion and Recovery

• Recovery Features

• Recovery Methodology and Steps

• Recovery Process – Re-mastering Resources

Parameter Management

• Overview

• RAC and Initialization Parameters

UNDO Management

• UNDO Management in RAC

• UNDO Tablespace Features

• System Rollback Segment

Concept of Thread

• Thread Features

• Redo Thread Maintenance

Segment Space Management

• Automatic Segment Space Management

• Manual Space Management

• Oracle Managed Files

Using SQL*Plus

• Starting the Database in Cluster Mode

Using Oracle DB Control for Clusters

• Configuration of DB Control w/Rac

Overview of RAC backup and Recovery

• Export & Cold Backup using Scripts and Hot Backups using Scripts

• RMAN(Recovery Manager) & Third Party Solutions

Backup of RAC Database

• Using RMAN for Backups

• Backup Procedures RMAN and RAC

Recovery in the RAC Environment

• Media Recovery in RAC Instances

• Using RMAN to Recover a RAC Environment

• Recovery in an OCFS Environment

• Recovery in a Raw File System Environment & Parallel Recovery

Standby Databases in RAC Configuration

• Setting up a Standby Database for a RAC Cluster to a Single-Instance (One Node)

• Configuration when the Standby Database is a Single Node System

• Cross-Instance Archival

• Archive Log Gap Resolution and FAL

ASM and RMAN

• Performing advanced backup/ recovery techniques with ASM

• Switch Database To Copy & Keeping ASM Clean

Services In-depth

• Failover & Load Balancing

• Planning and Configuration

Connection Pools and Services

The Load Balancing Advisory

Monitoring Services

Analysis of Performance Issues

• Monitoring RAC Cluster Interconnect

• Using performance views

• Using AWR & ADDM for RAC

Using DB Control to Monitor RAC

RAC Design Consideration

Designing equipment for RAC

• Effects of component failure

• Redundancy at every level

• Choosing Service/Nodes for Work

Sequences in RAC

• Table space Design Considerations

• Solid State Disk Considerations

• Table Locks and Latch Waits

• Scalability and Unpredictable Loads

Overview

Migration Methodology

• Moving from Single Instance to RAC

• Cloning Overview

• Migrating to Oracle 11g

• Rolling Upgrades

Oracle 11g RAC has a rolling upgrade features whereby RAC database can be upgraded without any downtime

Oracle 11g RAC has the ability to apply patches on a node-by-node basis without service interruption.

Starting in 10gr2 we see a RAC load balancing advisorutility. Oracle says that the 11g RAC load balancing advisor is only available with clients who use .NET, ODBC, or the Oracle Call Interface(OCI).

In Oracle 11g, ADDM has been extended to include RAC, and provides information on the entire cluster including latency issues on the cluster interconnect, global cache hot blocks (blocks with concurrency issues across multiple nodes), and general object usage information across multiple nodes.

11g RAC improves the cache fusion layer for faster and more efficient pinging between nodes

11g RAC ASMCA

Oracle 11g offers an ASM configuration assistant allows you to install cluster file systems(ACFS),ASM instances, ASM volumes and disk groups

Extends the general cache fusion protocols in 10g to deal with specific scenarios where the protocols could be further optimized.

The Oracle 11g grid control provisioning pack allows you to "blow-out" a RAC node without the time-consuming install, using a pre-installed "footprint"