SUMMARY:   This course offers students an introduction to the general features and capabilities of Oracle Database 10g for Oracle Real Application Clusters (RAC). Students will learn how to configure and administer a database for use with Real Application Clusters. The course also explains how to setup and use Automatic Storage Management (ASM) in a Real Application Clusters environment. Lectures are reinforced with hands-on practices designed to walk the student through the RAC administration. PREREQUISITES:   Database Administrators, with sound Oracle knowledge in a production environment or completion of training equivalent to: Oracle Database 10g: New Features for Administrators Oracle Database 10g: Administration Workshop I DURATION:   5 Days APPROACH:   Instructor-Led, interactive hands-on training. OBJECTIVES:   Identify Real Application Clusters components Install, create, administer, and monitor a Real Application Cluster/Database. Migrate their 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. Understand high availability best practices. COURSE CONTENT:   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 Outline Oracle 10g RAC Installation Pre-installation Tasks Cluster Setup Tasks Installing OCFS and Cluster Ready Services Launching VIPCA with root.sh Database Pre-creation Tasks Creating the Cluster Database Database Post-installation 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 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 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 AI/2007