Oracle Database 11g RAC Administration Release 2 NEW training

  • Overview
  • Course Content
  • Drop us a Query

Learning Oracle Database 11g RAC Administration release 2 training course can help in understanding RAC database administration in the environment of Grid Infrastructure. A proper training can help in efficiently manage cluster databases with the aid of Enterprise Manager and command-line utilities: SRVCTL, SQL Plus and CRSCTL.

The following are the things that one can learn through the training:

  • Set up Oracle Clusterware and Real Application Clusters
  • Manage a RAC Database
  • Learn how to make new connection architecture highly available
  • Manage database services in an RAC environment
Target audience
  • Database Administrators
  • Data Warehouse Administrators
  • Technical Administrators
  • Support Engineers
Prerequisites
  • General understanding of database administration
  • Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2 NEW
  • Oracle Database 11g: Administration Workshop I Release 2
  • Oracle Database 11g: New Features for Administrators DBA Release 2

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

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

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

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

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

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

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

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

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

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

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

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

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

+