Oracle Database 10g: Real Application Clusters

What you will learn:

Audience:

• Database Administrators

Prerequisites:

Required Prerequisites:

• Oracle Database 10g : Administration Workshop II

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

Course Topics:

Introduction

• Define a cluster
• Define Oracle Real Application Clusters
• List the advantages of using RAC
• Define scalability
• High availability and RAC

Architecture and Concepts

• List the various components of Cluster Ready Services (CRS) and Real Application Clusters (RAC)
• Describe the various types of files used by a RAC database
• Describe the various techniques used to share database files across a cluster
• Describe the purpose of using services with RAC

RAC Installation and Configuration Part I

• Outline Oracle 10g RAC Installation
• Preinstallation Tasks
• Cluster Setup Tasks
• Installing OCFS
• Installing Cluster Ready Services

RAC Installation and Configuration Part II

• Install Database Software
• Launching VIPCA with root.sh
• Database Precreation Tasks
• Creating the Cluster Database
• Database Postinstallation Tasks
• Administering Enterprise Manager Jobs in Real Application Clusters
• Node Addition and Deletion and the SYSAUX Tablespace
• AWR snapshots in RAC

RAC Database Instances Administration

• Understand the EM Cluster Database Home Page
• Starting and Stopping RAC Instances
• RAC Initialization Parameter Files
• Adding a Node to a Cluster
• Deleting Instances from a RAC Database
• Quiescing RAC Databases
• Administering Alerts with Enterprise Manager

Administering Storage in RAC Part I

• Describe automatic storage management (ASM)
• Install the ASM software
• Set up initialization parameter files for ASM and database instances
• Start up and shut down ASM instances
• Add ASM instances to the target list of Database Control
• Use Database Control to administer ASM in a RAC environment

Administering Storage in RAC Part II

• Manage redo log groups in a RAC environment
• Manage undo tablespaces in a RAC environment
• Use SRVCTL to manage ASM instances
• Migrate database files to ASM
• Manage and recover the OCR file and voting disk

Services

• Configure and manage services in a RAC environment
• Use services with client applications
• Use services with the Database Resource Manager
• Use services with the Scheduler
• Set performance-metric thresholds on services
• Configure services aggregation and tracing

High Availability of Connections

• Configure client side connect-time load balancing
• Configure client side connect-time failover
• Configure server side connect-time load balancing
• Benefit from Fast Application Notification (FAN)
• Configure server-side callouts
• Configure the server and client-side ONS
• Configure Transparent Application Failover (TAF)

Managing Backup and Recovery in RAC

• Configure RAC Recovery Settings with EM
• Configure RAC Backup Settings with EM
• Initiate Archiving
• Configuring RMAN
• RAC Backup and Recovery Using EM

RAC Performance Tuning

• Determine RAC specific tuning components
• Tune instance recovery in RAC
• Determine RAC specific wait events, global enqueues, and system statistics
• Implement most common RAC tuning tips
• Use the Cluster Database Performance pages
• Use Automatic Workload Repository and Automatic Database Diagnostic Monitor in RAC

Design for High Availability

• Design a Maximum Availability Architecture in your environment
• Determine the best RAC and Data Guard topologies for your environment
• Configure the Data Guard Broker configuration files in a RAC environment
• Patch your RAC system in a rolling fashion