ORACLE RAC DBA Training

Course Objectives
  • Identify Real Application Clusters components
  • Install, create, administer, and monitor a Real Application Clusters database
  • Use configuration and management tools for Real Application Clusters databases
  • Migrate your database storage to Automatic Storage Management
  • Setup services for workloads management, and applications high availability
  • Develop a backup and recovery strategy for Real Application Clusters databases
  • Review high availability best practices
Architecture and Concepts:

  • RAC Database Storage Principles
  • Oracle Cluster File System
  • Automatic Storage Management
  • RAC and Services
  • Virtual IP Addresses and RAC
  • Database Control and RAC
RAC Installation and Configuration:

  • Preinstallation Tasks
  • Hardware Requirements
  • Network Requirements
  • Package Requirements
  • Preparing the Disks
  • Cluster Configuration
RAC Database Instances Administration:

  • The Configuration Section
  • RAC Initialization Parameters
  • Adding a Node to a Cluster
  • Reconfigure the Listeners
  • Add an Instance by Using DBCA
  • Deleting Instances from a RAC Database
  • Quiescing RAC Databases
  • Administering Alerts with Enterprise Manager
Administering Storage in RAC (Part I):

  • What Is Automatic Storage Management?
  • ASM: General Architecture
  • ASM Configuration
  • ASM Administration
  • SQL Commands and File Naming
  • DBCA and Storage Options
  • Database Instance Parameter Changes
Administering Storage in RAC (Part II):

  • ASM and SRVCTL with RAC
  • Migrating to ASM: Overview
  • Tablespace Migration: Example
  • ASM Disk Metadata Requirements
  • ASM and Transportable Tablespaces
Services:

  • High Availability of Services in RAC
  • Possible Service Configuration with RAC
  • Creating Services
  • Using Services with Client Applications
  • Using Services with Resource Manager
  • Using Services with Scheduler
  • Using Services with Parallel Operations
  • Service Aggregation and Tracing
  • Service Performance Views
  • Managing Services
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:
  • Server-Side Callouts Implementation
  • Transparent Application Failover
Managing Backup and Recovery in RAC:

  • Configure RAC Recovery Settings with EM
  • Oracle Recovery Manager
  • Configuring RMAN
  • RAC Backup and Recovery Using EM
  • Restoring and Recovering
  • Managing OCR: Overview
  • Recovering the OCR
  • Recovering the Voting Disk
RAC Performance Tuning:

  • CPU and Wait Time Tuning Dimensions
  • RAC-Specific Tuning
  • Analyzing Cache Fusion Impact in RAC
  • Wait Events for RAC
  • Session and System Statistics
  • Most Common RAC Tuning Tips
  • Automatic Workload Repository
  • Statspack and AWR
  • Automatic Database Diagnostic Monitor
Design for High Availability:

  • Causes of Unplanned Down Time
  • Causes of Planned Down Time
  • Oracle’s Solution to Down Time
  • RAC and Data Guard
  • Maximum Availability Architecture
  • Rolling Patch Upgrade Using RAC
  • Rolling Release Upgrade Using SQL Apply
  • Extended RAC 1
  • Using Distributed Transactions with RAC

Comments are closed.