Oracle 10g RAC for Administrator

Audience:

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

Required Prerequisites:

• Single-instance Oracle Database 10g Architecture and Experience

Suggested Prerequisites:

• Oracle Enterprise Manager 10g Grid Control Release 2
• Oracle Database 10g: Administration Workshop I Release 2
• Oracle Database 10g: Administration Workshop II Release 2

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
• 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 Topics:

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