Real Application Cluster (RAC) 12C

Real Application Cluster (RAC) 12C Course Content (40 HOURS)               


  1. Grid Infrastructure: Overview





Oracle Clusterware

Oracle Flex Clusters

Flex Cluster Scalability

Clusterware Architecture and Cluster Services

Features of Oracle Clusterware

Oracle Clusterware Networking

Oracle Clusterware Initialization

GPnP Architecture: Overview

How GPnP Works: Cluster Node Startup

Grid Naming Service (GNS)

Single-Client Access Name

Client Database Connections

Oracle ASM

ASM CloudFS and ACFS

Oracle Flex ASM

ASM Features and Benefits


  1. RAC Databases Overview and Architecture



Oracle RAC: Overview

Typical Oracle RAC Architecture

RAC One Node Single-Instance High Availability

Oracle RAC One Node

Oracle RAC One Node and Oracle Clusterware

Cluster-Aware Storage Solutions

Oracle Cluster File System

Oracle RAC and Network Connectivity

Benefits of Using RAC

Clusters and Scalability

Levels of Scalability

Oracle Internal & Oracle Academy Use Only

Scaleup and Speedup

Speedup/Scaleup and Workloads

I/O Throughput Balanced: Example

Necessity of Global Resources

Additional Memory Requirement for RAC

Parallel Execution with RAC


  1. Installing and Configuring Oracle RAC



Installing the Oracle Database Software

Creating the Cluster Database

Database Type Selection

Database Identification

Cluster Database Management Options

Passwords for Database Schema Owners

Storage Locations

Database Content

Initialization Parameters

Create the Database

Monitoring Progress

Postinstallation Tasks

Background Processes Specific to Oracle RAC

Single Instance–to-RAC Conversion

Considerations for Converting Single-Instance Databases to Oracle RAC

Single-Instance Conversion Using DBCA

Conversion Steps

Single-Instance Conversion Using rconfig


  1. Oracle RAC Administration


Enterprise Manager Cloud Control Cluster Database Home Page

Cluster Database Home Page

Cluster Database Instance Home Page

Cluster Home Page

Topology Viewer

Enterprise Manager Alerts and RAC

Enterprise Manager Metrics and RAC

Oracle Internal & Oracle Academy Use Only

Enterprise Manager Blackouts and RAC

Enterprise Manager Database Express

Redo Log Files and RAC

Automatic Undo Management and RAC

Starting and Stopping RAC Instances

Starting and Stopping RAC Instances with srvctl

Starting and Stopping RAC Instances with SQL*Plus

Starting and Stopping Pluggable Databases in Oracle RAC

Switch Between Automatic and Manual Policies

RAC Initialization Parameter Files

SPFILE Parameter Values and RAC

Parameter File Search Order in Oracle RAC

EM and SPFILE Parameter Values

RAC Initialization Parameters

Parameters That Require Identical Settings

Parameters That Require Unique Settings

Quiescing RAC Databases

Terminating Sessions on a Specific Instance

How SQL*Plus Commands Affect Instances

Transparent Data Encryption and Keystores in RAC


  1. Upgrading and Patching Oracle RAC



Patch and Patch Set: Overview

Types of Patches

Configuring the Software Library

Obtaining Oracle RAC Patches

Downloading Patches

Reduced Down-Time Patching for Cluster Environments

Rolling Patches

Out-of-Place Database Upgrades

Out-of-Place Database Upgrade with OUI

OPatch: Overview

OPatch: General Usage

Before Patching with OPatch

OPatch Automation

OPatch Automation: Examples

OPatch Log and Trace Files

Oracle Internal & Oracle Academy Use Only

Queryable Patch Inventory



  1. 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

RAC and the Fast Recovery Area

RAC Backup and Recovery Using EM

Configuring RAC Recovery Settings with EM

Archived Redo File Conventions in RAC

Configuring RAC Backup Settings with EM

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

Managing Archived Redo Logs Using RMAN

Noncluster File System Local Archiving Scheme

Configuring Non-Cluster, Local Archiving

ASM and Cluster File System Archiving Scheme

Configuring the CFS Archiving Scheme

Restoring and Recovering


  1. Global Resource Management Concepts



Need for Global Concurrency Control

Global Resource Directory (GRD)

Global Resource Management

Global Resource Remastering

Global Resource Recovery

Oracle Internal & Oracle Academy Use Only

Global Resource Background Processes

Global Resource Access Coordination

Global Enqueues

Instance Locks

Global Cache Management: Overview

Global Cache Management Components

Global Cache Buffer States

Global Cache Management Scenarios for Single Block Reads

Global Cache Scenarios: Overview

Scenario 1: Read from Disk

Scenario 2: Read-Write Cache Fusion

Scenario 3: Write-Write Cache Fusion

Scenario 4: Write-Read Cache Fusion

Global Cache Management Scenarios for Multi-Block Reads

Useful Global Resource Management Views


  1. RAC Database Monitoring and Tuning



CPU and Wait Time Tuning Dimensions

RAC-Specific Tuning

Analyzing Cache Fusion Impact in RAC

Typical Latencies for RAC Operations

Wait Events for RAC

Wait Event Views

Global Cache Wait Events: Overview

Global Enqueue Waits

Session and System Statistics

Most Common RAC Tuning Tips

Index Block Contention: Considerations

Oracle Sequences and Index Contention

Undo Block Considerations

High-Water Mark Considerations

Concurrent Cross-Instance Calls: Considerations

Monitoring RAC Database and Cluster Performance

Cluster Database Performance Page

Determining Cluster Host Load Average

Determining Global Cache Block Access Latency

Determining Average Active Sessions

Oracle Internal & Oracle Academy Use Only

Determining Database Throughput

Accessing the Cluster Cache Coherency

Viewing the Database Locks

AWR Snapshots in RAC

AWR Reports and RAC: Overview

Active Session History Reports for RAC

Automatic Database Diagnostic Monitor for RAC

What Does ADDM Diagnose for RAC?

EM Support for ADDM for RAC

EM Database Express Performance Hub


  1. Managing High Availability of Services



Oracle Services

Service Usage in an Oracle RAC Database

Parallel Operations and Services

Service Characteristics

Default Service Connections

Restricted Service Registration

Creating Service with Enterprise Manager

Creating Services with SRVCTL

Managing Services with Enterprise Manager

Managing Services with EM

Managing Services with srvctl

Using Services with Client Applications

Services and Connection Load Balancing

Services and Transparent Application Failover

Using Services with the Resource Manager

Services and Resource Manager with EM

Using Services with the Scheduler

Services and the Scheduler with EM

Using Distributed Transactions with RAC

Distributed Transactions and Services

Service Thresholds and Alerts

Services and Thresholds Alerts: Example

Service Aggregation and Tracing

Top Services Performance Page

Service Aggregation Configuration

Oracle Internal & Oracle Academy Use Only

Service, Module, and Action Monitoring

Service Performance Views





  1. High Availability for Connections and Applications



Types of Workload Distribution

Client-Side Connect-Time Load Balancing

Fast Application Notification (FAN): Overview

Fast Application Notification: Benefits

Implementing FAN Events

FAN and Oracle Integrated Clients

FAN-Supported Event Types

FAN Event Reasons

FAN Event Status

FAN Event Format

Load Balancing Advisory: FAN Event

Server-Side Callouts Implementation

Server-Side Callout Parse: Example

Server-Side Callout Filter: Example

Server-Side ONS

Optionally Configuring the Client-Side ONS

UCP JDBC Fast Connection Failover: Overview


Load Balancing Advisory

UCP JDBC/ODP.NET Runtime Connection Load Balancing: Overview

Connection Load Balancing in RAC

Monitoring LBA FAN Events

Transparent Application Failover: Overview

TAF Basic Configuration on Server-Side: Example

TAF Basic Configuration on a Client-Side: Example

TAF Preconnect Configuration: Example

TAF Verification

FAN Connection Pools and TAF Considerations

Introducing Transaction Guard and Application Continuity

What Is Transaction Guard?

Benefits of Transaction Guard

How Transaction Guard Works

Using Transaction Guard

Oracle Internal & Oracle Academy Use Only

Creating Services for Transaction Guard

What Is Application Continuity?

Benefits of Application Continuity

How Does Application Continuity Work?

RAC and Application Continuity

Using Application Continuity

Creating Services for Application Continuity



  1. Oracle RAC One Node



Oracle RAC One Node

Creating an Oracle RAC One Node Database

Verifying an Existing RAC One Node Database

Oracle RAC One Node Online Relocation

Online Relocation Considerations

Performing an Online Relocation

Online Relocation Illustration

Online Maintenance: Rolling Patches

Adding an Oracle RAC One Node Database to an Existing Cluster

Converting a RAC One Node Database to RAC

Converting a Single Instance Database to RAC One Node

Converting a RAC Database to RAC One Node


  1. Multitenant Architecture and RAC



Non-CDB Architecture

Multitenant Architecture: Benefits

CDB in a Non-RAC Environment



Data Dictionary Views

Connection to a Non-RAC CDB

Switching Connection

Oracle RAC and Multitenant Configuration

Oracle RAC and Multitenant Architecture

Oracle Internal & Oracle Academy Use Only

Creating a RAC CDB

Creating a RAC CDB Including PDBs

Hosting a RAC CDB in Server Pools

After CDB Creation

Connecting Using CDB/PDB Services

Opening a PDB in a RAC CDB

Closing a PDB in a RAC CDB

Types of Services

Managing Services

Affinitizing PDB Services to Server Pools

Adding a PDB to a RAC CDB

Dropping a PDB from a RAC CDB


  1. Quality of Service Management



QoS Management Background

QoS Management Overview

QoS Management and Exadata Database Machine

QoS Management Focus

QoS Management Benefits

QoS Management Functional Overview

QoS Management Policy Sets

Server Pools

Performance Classes

Classification and Tagging

Performance Policies

Performance Class Ranks

Performance Objectives

Performance Satisfaction Metrics

Server Pool Directive Overrides

Overview of Metrics

QoS Management Architecture

QoS Management Recommendations

Implementing Recommendations