Oracle Database 11g: RAC Administration (D75223) – Outline

Detailed Course Outline

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