Database 10g R2: RAC for Administrators

Course Overview

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC). Students learn how to install and administer OracleClusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control. Increase your efficiency by learning how to configure and use database services as well as the Load Balancing Advisory in a RAC environment. Learn how to add and remove nodes in clusters and how to patch both Oracle Clusterware and Real Application Clusters software in a rolling fashion.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator certification.

• Install Oracle Clusterware and Real Application Clusters
• Administer a RAC Database
• Administer Database Services in a RAC environment
• Administer Oracle Clusterware
• Add/Remove a node to/from a cluster
• Patch Oracle Clusterware and RAC software in a rolling fashion

Audience

• Data Warehouse Administrator
• Database Administrators
• Database Designers
• Project Manager
• Support Engineer
• System Analysts
• Technical Administrator
• Technical Consultant

Prerequisites

• Single-instance Oracle Database 10g Architecture and Experience
• Oracle Database 10g: Administration Workshop I Release 2
• Oracle Enterprise Manager 10g Grid Control Release 2NEW
• Oracle Database 10g: Administration Workshop II Rel 2

Skills Gained

• 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
• Setup services for workloads management, and applications high availability
• Develop a backup and recovery strategy for Real Application Clusters databases
• Configure and monitor Oracle Clusterware resources
• Review high availability best practices

Course Outline

Identify Real Application Clusters 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

Install, create, administer, and monitor a Real Application Clusters database

• 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

Use configuration and management tools for Real Application Clusters databases

• 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

Setup services for workloads management, and applications high availability

• 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)

Develop a backup and recovery strategy for Real Application Clusters databases

• Configure the RAC database to use ARCHIVELOG mode and the flash recovery area
• Configure RMAN for the RAC environment

Configure and monitor Oracle Clusterware resources

• 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

Review 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

Database 10g R2: RAC for Administrators / D47380GC20