Oracle RAC 11g

Home > Courses > Oracle RAC 11g

Course Duration: 40 Hours

Course Highlights:

  • Introduction to Oracle Real Application Cluster (RAC)
  • Install Oracle 11gR2 grid Software on both RAC Nodes on VMWare
  • Create database using DBCA on RAC
  • SRVCTL and CRSCTL tools
  • Single Instance to RAC migration
  • ASM (Automatic Storage Management)
  • Managing Backup and Recovery for RAC
  • High Availability of Connections
  • Administration activities on RAC

Required Prerequisites:

  • Basic Knowledge of Unix.
  • Oracle Database: Introduction to SQL
  • Good knowledge of Oracle Database Administrator 11g

Target Audience:

  • Oracle DBA who want to learn Oracle Real Application Cluster (RAC) which provide solution for High Availability and better Performance.

Download Oracle RAC 11g Brochure

Course Content

Section 1: Introduction

What Is a Cluster

What is Oracle Real Application Clusters

Benefits of Using RAC

Automatic Storage Management

ASM Key Features and Benefits

ASM and Grid Infrastructure in 11gR2

RAC One Node Single-Instance High Availability on 11gR2

Section 2: Grid Infrastructure: Overview

Oracle Clusterware

Oracle Clusterware Architecture and Services

Goals for Oracle Clusterware

Oracle Clusterware Networking

Oracle Grid Infrastructure for a Cluster

Grid Plug and Play

Grid Naming Service

Single Client Access Name

Section 3: Oracle RAC Installation

Oracle RAC 11g incorporates a two-phase installation process:

Oracle RAC 11g Installation: Outline

Pre installation Tasks

Network Requirements

Virtual IP Addresses and RAC

SCAN from 11gR2

Install VMware and one OEL server (Node 1)

Install OS pre-requisites

Add ASM disks to Node 1

Add two network adaptors

Complete the setup on Node 1

Clone Node 1 to Node 2

Modify the configuration on Node 2

Disable NTPD and test the setup(Network and ASM disks)

Copy GRID software to Node 1 and install CLUSTER on both nodes

Check cluster and ASM disks on both the servers

Install database software on both the servers from Node 1

Create diskgroups in ASM for database

Install database now using DBCA

Section 4: SRVCTL and CRSCTL tools

Check RAC and Cluster health

SRVCTL commands

SRVCTL RAC administration

CRSCTL commands

CRSCTL RAC administration

Section 5: Background processes

Background process and Components of cluster

Database Background Processes

Prerequisites for Converting to Oracle RAC Databases

Oracle Clusterware Initialization

Startup process of cluster

Section 6:RAC Database Administration

Redolog files in RAC

Automatic Undo Management in RAC

Start Stop RAC instances with SQLplus

Start Stop RAC instances with SRVCTL

Initialization parameters in RAC

SPFILE Parameter Values and RAC

Identical parameters between nodes

Distinct parameters between nodes

Quiecing RAC databases

Terminate sessions in RAC

SQLplus commands and Instances

Section 7:ASM (Automatic Storage Management)

Find the Thread numbers of instances

ASM general architecture

ASM instance and crash recovery in RAC

SPFILE Parameter Values and RAC

ASM initialization parameters


Section 8: Global Resource Management Concepts

Need for Global Concurrency Control

Global Resource Directory (GRD)

Global Resource Management

Global Resource Remastering

Global Resource Recovery

Global Resource Background Processes

Global Resource Access Coordination

Global Enqueues

Instance Locks

Global Cache Management: Overview

Global Cache Management Components

Global Cache Buffer States

Section 9:Managing Backup and Recovery for RAC

RAC and Instance Recovery

Instance Recovery and Database Availability

Instance Recovery and RAC

Protecting Against Media Failure

Media Recovery in Oracle RAC

Parallel Recovery in RAC

Archived Log File Configurations

RAC and the Fast Recovery Area

Archived Redo File Conventions in RAC

Oracle Recovery Manager

Configuring RMAN Snapshot Control File Location

Configuring Control File and SPFILE Autobackup

Crosschecking on Multiple RAC Clusters Nodes

Channel Connections to Cluster Instances

RMAN Channel Support for the Grid

RMAN Default Autolocation

Distribution of Backups

Shared Storage Backup Scheme: One Local Drive

Shared Storage Backup Scheme: Multiple Drives

Restoring and Recovering

Section 10: Administration Activities 1

RAC and Instance Recovery

Crash Node 1/Node 2 and check the availability of database

Setting Parallel_min_servers parameter

Enable and disable archivelog mode in RAC

Configure FRA to ASM disk group

Configure FRA to generate Archive logs

Configure proper naming convention to archive log files

Configure proper snapshot control file location

Configure Snapshot control file location

Configure AUTOBACKUP SPFILE and controlfile backups

Full database backup (No parallel slaves)

Full database backup with parallel slaves on same node

Full database backup with parallel slaves on other nodes(In run block)

Full database backup with parallel slaves on same node(Configured RMAN)

Full database backup with parallel slaves on other nodes(Configured RMAN)

Restore and recover a lost datafile.

Restore and recover database – With SPFILE

Restore and recover database – With LOST SPFILE

Section 11:High Availability of Connections

Crash Node 1/Node 2 and check the availability of database

Client-Side Connect-Time Load Balancing

Client-Side Connect-Time failover

Server-Side Connect-Time Load Balancing

Fast Application Notification: Overview

Fast Application Notification: Benefits

FAN-Supported Event Types

FAN Event Status

FAN Event Reasons

FAN Event Format

Connection Load Balancing in RAC

Transparent Application Failover: Overview

Example connection without TAF:

TAF Basic Configuration Without FAN: Example

Section 12:Administration Activities 2

Exercise demonstrating connection using service from windows

Relocating services

Bringing cluster down

Starting cluster

deleting services

Modifying services

Killing sessions

Monitoring blocks,LOCKS, DEADLOCKS

Starting cluster components

View number of nodes in cluster:

Check Cluster status:

identify OCR

Identify location of voting disk

OCR backups

adding additional voting disk
Shutting down all oracle services for any maintenance

Adding, Deleting, or Migrating Voting Disks

Locating the OCR Automatic Backups

Changing the Automatic OCR Backup Location

Adding, Replacing, and Repairing OCR Locations

Removing an Oracle Cluster Registry Location

Performing Manual OCR Backups
Recovering the OCR by Using Physical Backups

Recovering the OCR by Using Logical Backups

Oracle Local Registry

Determining the Current Network Settings

Section 13:Single Instance to RAC migration

Methods of migrating single instance database to RAC.

Migrate a single Instance to 2 node RAC setup.

Configuration Changes During Oracle RAC Conversion Using rconfig

Prerequisites for Converting to Oracle RAC Databases

Scenarios to Oracle RAC Using rconfig

Converting non-RAC database files to ASM

Converting Databases to Oracle RAC Using rconfig

Signup today and be the first to get notify on latest videos and upcoming batches.

Subscribe to our mailing list