Oracle RAC Configuration & Administration

Course Description:

This course provides an introduction to the general features and capabilities of Oracle Real Application Clusters (RAC). Delegates will learn how to install, create, configure and administer a database for use with RAC. Delegates will learn how to setup and use Automatic Storage Management (ASM) in a RAC environment.

This course is designed for experienced database administrators who are required to plan, implement and administer Oracle Real Application Clusters configurations for Oracle databases.

The delegate will practice:

• Installing, creating, administering and monitoring a RAC database
• Using configuration and management tools for RAC databases
• Setting up services for workload management and application high availability
• Backing up, restoring and recovering a RAC database
• Creating duplicate and standby databases in a RAC Environment
• Monitoring and tuning the performance of a RAC database

This course includes the following modules:

Oracle Real Application Clusters Overview

• Oracle RAC Features
• Oracle RAC Technology Hierarchy
• Oracle RAC Capabilities
• Oracle RAC Components
• Tools for Installing, Configuring and Managing Oracle RAC

Oracle RAC Architecture and Concepts

• Oracle RAC 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
• An Overview of RAC Services
• Configure the Network
• Configure iSCSI Volumes

RAC Installation and Configuration

• Oracle RAC Pre-installation Tasks
• Create Oracle Groups, User Accounts and Directories
• Validate and Prepare the Hardware and the Operating System
• Cluster Setup Tasks
• Install and Configure OCFS2
• Install Cluster Ready Services
• Network Configuration

Oracle Clusterware

• Oracle Clusterware Pre-installation Steps
• Oracle Clusterware Installation
• Cluster Verification Utility (CVU, CLUVFY)
• Install Oracle Database Software
• Oracle Net Listener Configuration and Management
• Create the Oracle Cluster Database
• Configure Client Connections with Oracle Net Manager
• Post Installation Tasks

RAC Database Instances Administration

• RAC Initialization Parameter Files
• Manage Undo Tablespaces in a RAC Environment
• Manage Redo Log Files and Groups in a RAC Environment
• Oracle Enterprise Manager Cluster Database Pages
• Database Storage

Administer Oracle Clusterware

• 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

Automatic Storage Management Administration

• Automatic Storage Management (ASM) Components in RAC
• Modify Disk Group Configurations for ASM in RAC
• ASM Files
• Administer ASM Instances and Disk Groups with Enterprise Manager in RAC
• Administer ASM Instances with SRVCTL in RAC
• Use the ASM Command Line Tool (ASMCMD)
• Startup and Shutdown ASM Instances
• Add ASM Instances to the Target List of Database Control
• Administer ASM with RAC using Database Control

RAC Management Commands

• 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

Services

• Manage the Database Workload using Services
• Create and Administer Services in a RAC Environment
• Services and Client Applications
• Configure Oracle Net to Support Services
• Configure Service Level Thresholds
• Configure Clients for Failover

High Availability of Connections

• 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

Backuo and Recover a RAC Database

• Configure a Flash Recovery Area for use with RAC
• Tune Instance 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

Create Duplicate and Standby Databases with RAC

• 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

RAC Performing Tuning

• Monitoring and Performance Guidelines
• RAC Monitoring Tools
• RAC Performance Recommendations
• Analyze Performance Issues using OS Watcher and LTOM
• 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 Manager

High Availability Design

• Design a System for Maximum Availability
• The Optimal RAC and Data Guard Design for an Environment
• Apply Rolling Patches to a RAC System