Oracle Database 11g: Real Application Clusters (RAC) Administration Training

  • Overview
  • Course Content
  • Drop us a Query

Oracle Database 11g: Real Application Clusters (RAC) Administration training course develops the skills to explore the features of Oracle Real Application Clusters (RAC) database administration in the Oracle Grid Infrastructure environment. This training imparts the skills about the installation and administration of Oracle cluster and RAC using Enterprise Manager Grid Control and command-line utilities such as SQL*Plus, CRSCTL and SRVCTL. This training increases your proficiency in various tasks like optimizing the database workloads, resolving backup and recovery issues and providing quality of service.

After completing this course, the students will be able to:

  • Understand Grid Infrastructure and RAC concepts.
  • Install, configure, admin, and manage RAC databases.
  • Plan a backup and recovery strategy for RAC databases.
  • Describe Global Resource Management concepts.
  • Manage workloads and high availability of services and connections.
  • Upgrade and patch Oracle RAC databases.
  • Perform online migration.
  • Demonstrate Quality of Service (QoS) Management.
Target audience
  • Database administrators
  • Data Warehouse Administrator
  • Technical Administrator
  • Support Engineer
  • Consultants
Prerequisites

The candidates with sound understanding of Oracle Grid Infrastructure components and database administration are the ideal participants for this course. The professionals who had attended Oracle's Database 11g: Administration Workshop I and Workshop II, or with equivalent experience are also the deserving attendees of this training.

Exams
Exam Name Exam Code
Oracle Real Application Clusters 11gR2 & Grid Infrastructure Admin 1Z0-058

Grid Infrastructure: Overview

  • Oracle Grid Infrastructure
  • What Is a Cluster?
  • What Is Clusterware?
  • Oracle Clusterware
  • Oracle Clusterware Architecture and Services
  • Goals for Oracle Clusterware
  • Oracle Clusterware Networking
  • Oracle Grid Infrastructure for a Cluster

RAC Concepts

  • Overview of Oracle RAC
  • 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
  • Benefits of Using RAC
  • Clusters and Scalability

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
  • Database File Locations
  • Recovery Configuration

Oracle RAC Administration

  • Oracle RAC Administration
  • Cluster Database Instance Home Page
  • Cluster Home Page
  • Configuration Section
  • Topology Viewer
  • Enterprise Manager Alerts and RAC
  • Enterprise Manager Metrics and RAC
  • Enterprise Manager Alert History and RAC

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

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

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

Managing High Availability of Services

  • Oracle Services
  • Services for Policy- and Administrator-Managed Databases
  • Default Service Connections
  • Creating Service with Enterprise Manager
  • Creating Services with SRVCTL
  • Managing Services with Enterprise Manager
  • Managing Services with EM
  • Managing Services with srvctl

High Availability of Connections

  • Types of Workload Distribution
  • 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

Upgrading and Patching Oracle RAC

  • Types of Patches
  • Patch Properties
  • Configuring the Software Library
  • Setting Up Patching
  • Obtaining Oracle RAC Patches
  • Downloading Patches
  • Reduced Down-Time Patching for Cluster Environments
  • Rolling Patches

Oracle RAC One Node

  • Verifying an Existing RAC One Node Database
  • Oracle RAC One Node Online Migration
  • Online Migration Considerations
  • Performing an Online Migration
  • Online Migration Illustration
  • Online Maintenance: Rolling Patches
  • Adding an Oracle RAC One Node Database to an Existing Cluster
  • Converting a RAC One Node Database to RAC

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

Design for High Availability

  • Causes of Unplanned Down Time
  • Causes of Planned Down Time
  • Oracle’s Solution to Down Time
  • RAC and Data Guard Complementarity
  • Maximum Availability Architecture
  • RAC and Data Guard Topologies
  • RAC and Data Guard Architecture
  • Data Guard Broker (DGB) and Oracle Clusterware (OC) Integration

Partners

A Few Things You'll Love!

What our Students Speak

+