Oracle Database 10g: RAC Administration

 Click here

Course Overview

This course offers students an introduction to the general features and capabilities in an Oracle RAC environment. Students learn how to install and manage Oracle Clusterware, Automatic Storage Management and Oracle Real Application Cluster components.

The students also learn how to configure and use database services, as well as the Load Balance Advisory. The course is designed to enhance a student ability to provide DBA support for Oracle RAC environments using Enterprise Manager Grid Control or by entering SVRCTL commands.

Course Goals

• To gain a solid understanding of Real Application Clusters and the benefits it can provide for Oracle database environments.
• To be able to use Oracle configuration and management tools to provide scalable workload management, accurate resources monitoring and timely connection failover.
• To be able to install, create, and manage an Oracle RAC database.

Prerequisites

• A solid understanding of single-instance Oracle database architecture is recommended

Who Should Attend?

• Database Administrators
• Data Warehouse Administrators
• Database Designers
• System Analysts
• Project Managers
• Technical Administrators
• Support Engineers
• Technical Consultants

Course Materials

• Student Handbook
• RAC Reference Book

Duration

• Five (5) days

Course Outline

• Concepts and Components
  • Understand Real Application Clusters
  • Clusters Scalability and High Availability
  • The Necessity of Global Resources
  • Parallel Execution with RAC
  • RAC Software and Database Principles
  • RAC and Shared Storage Technologies
  • Understand VIPs
  • Describe the benefits of Fast Application Notification
• Setup and Installation
  • Describe the installation of Oracle RAC 10g
  • Perform RAC pre-installation tasks
  • Perform cluster setup tasks
  • Install Oracle Clusterware
  • Install and configure Automatic Storage Management (ASM)
  • Install the Oracle database software
  • Create a cluster database
  • Install the Enterprise Manager agent on each cluster node
• Configuration and Management
  • Use Enterprise Manager cluster database pages
  • Define redo log files in a RAC environment
  • Define undo tablespaces in a RAC environment
  • Start and stop RAC databases and instances
  • Modify initialization parameters in a RAC environment
  • Manage ASM instances in a RAC environment
  • Determine RAC-specific wait events, global enqueues, and system statistics
  • Implement the most common RAC tuning tips
• Connectivity and Workload Management
  • Configure and manage services in a RAC environment
  • Set performance-metric thresholds on services
  • Configure services aggregation and tracing
  • Configure server-side connect-time load balancing
  • Use the Load Balancing Advisory
  • Configure server-side callouts
  • Configure the server- and client-side ONS
  • Configure Transparent Application Failover (TAF)
• Backup and Recovery
  • Configure database to use ARCHIVELOG mode and the flash recovery area
  • Configure RMAN for the RAC environment
• Configure and Monitor
  • Manually control the Oracle Clusterware stack
  • Change voting disk and OCR configuration
  • Back up or recover your voting disks and OCR files
  • Change VIP addresses
  • Use the CRS framework
  • Collect Oracle Clusterware diagnostic files
  • Enable Oracle Clusterware debugging
• High Availability Best Practices
  • Add a new node to your cluster database
  • Remove a node from your cluster database
  • Design a Maximum Availability Architecture in your environment
  • Decide on the best ASM configuration to use
  • Patch your RAC system in a rolling fashion