Oracle RAC Training

Cluster Overview

Grid Foundation Components and Architecture

Oracle Clusterware Components and RAC

Oracle Storage Subsystems

File Types used by a RAC Database

Methods used to Share Database Files across a Cluster

ASM Architecture

Create and Manage ASM Disk Groups

Create and Manage ASM Cluster Filesystems

An Overview of RAC Services

Network Configuration

Oracle RAC Pre-installation Tasks

Create Oracle Groups, User Accounts, and Directories

Validate and Prepare the Hardware and the Operating System

Network Configuration

Install the Oracle Grid Infrastructure

Cluster Verification Utility (CVU, CLUVFY)

Install Oracle Database Software and Create a Cluster Database

Verify the Installation

Post Installation Tasks

Configure Client Connections with Oracle Net Manager

Convert an Oracle Database to a RAC Database

Use the DBCA for Single Instance Conversion

Use rconfig for Single Instance Conversion

RAC Specific Background Processes

RAC Initialization Parameters

Manage Undo Tablespaces in a RAC Environment

Manage Redo Log Files and Groups in a RAC Environment

Oracle Enterprise Manager Cluster Database Pages

Start and Stop Oracle RAC Databases and Instances

Administer Database Storage

Transparent Data Encryption and Wallets in RAC

Manage CRS Commands

CRSCTL Commands to Stop, Start and Administer Clusterware

Backup and Recover Voting Disks

Add and Remove Voting Disks

The ocrcheck Utility

The ocrdump Command

Administer the Oracle Cluster Registry (OCR)

Backup and Restore OCR

Troubleshoot the OCR with ocrcheck

ASM Initialization Parameters

Create an ASM Instance using ASMCA

Start and Stop an ASM Instance using srvctl

Start and Stop an ASM Instance using ASMCMD

Start and Stop an ASM Instance Containing Cluster Files

Start and Stop the ASM Listener

Create and Delete ASM Disk Groups

ASM Disk Group Attributes

ASM Disk Group Maintenance Tasks

Preferred Read Failure Groups

ASM Disk Statistics

Manage ASM Volumes

Create an ASM Cluster File System (ACFS)

Manage an ACFS File System

ACFS Snapshots

Manage ACFS with Command Line Tools

RAC Management Commands

RAC Administration with SVRCTL

SVRCTL Cluster Database Configuration Tasks

SVRCTL Cluster Database Administration Tasks

Check the Current Configuration

SVRCTL Command Summary

Administer Databases and Instances

Administer Services and Node Applications

Bring a Cluster Database online and offline

Introduction to CRS

Cluster Services

Manage the Database Workload using Services

Create and Administer Services in a RAC Environment

Services and Client Applications

Manage Services with Enterprise Manager and from the Command Line

Configure Oracle Net to Support Services

Configure Service Level Thresholds

Configure Clients for Failover

RAC High Availability Framework

Failure Detection with Cluster Services

Oracle RAC and Hardware Failover

Connection Failover

Transparent Application Failover (TAF)

Server, Client And Runtime Load Balancing

Fast Application Notification (FAN)

Server and Client Side Oracle Notification Services

Configure a Fast Recovery Area for use with RAC

Tune Instance Recovery in RAC

Parallel Recovery in RAC

Initiate Archiving

Configure RMAN Backup and Recovery Settings

Backup a RAC Database using RMAN

Restore and Recover a RAC Database using RMAN

Display Backup Reports

Duplicate a RAC Database with RMAN

Standby Database in a RAC Configuration

Configure Data Guard for a RAC Environment

Possible Combinations of Instances in the RAC Primary and Standby Databases

Multi-Instance Primary with a Single Instance Standby

Set up a Primary in a RAC Environment

Set up a Single Instance Standby Database

Set up a Multiple Instance Primary and Cluster Standby

Configure RAC Primary and Standby Databases

Data Protection Modes

Role Transition Switchovers and Failovers

Switchover Failover in an Oracle RAC Configuration

Monitoring and Performance Guidelines

RAC Monitoring Tools

RAC Performance Recommendations

Analyze Performance Issues using OS Watcher and LTOM

Use the Automatic Workload Repository in RAC

Use the Automatic Database Diagnostic Monitor in RAC

Use Statspack with RAC

Global Cache Services (GCS) Monitoring

V$cache_transfer Views

Monitor the GES Processes

Monitor and Tune the RAC Cluster Environment using Enterprise Manage.

Prepare a New Node

Extend the Oracle Grid Infrastructure Home to the New Node

Extend the Oracle RAC Home Directory

Add the New Node to the Cluster

Create an Instance on the New Node

Delete an Instance from the Cluster Database

Remove a Node from the Cluster

Configure the EM Patch Interface

Obtain Patches

Apply Rolling Patches to a RAC System

Apply a Patchset with the opatch Utility

Apply a Patchset with OUI