Oracle Database 11g: RAC Administration Release 2

This Oracle Database 11g: RAC Administration course deep dives into RAC database administration in the Oracle Grid Infrastructure environment. You'll learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, and SQL*Plus.

Learn To:

• Administer both policy and administrator-managed RAC databases.
• Install and configure 11gR2 RAC software.
• Describe backup and recovery in a RAC environment.
• Create and configure a RAC database.
• Use services.
• Describe Oracle Database 11gR2 RAC enhancements and new features.
• Study the new connection architecture and how to make those connections highly available.

Explore Backup and Recovery Issues

Expert Oracle University instructors will also help you develop an understanding of backup and recovery issues relative to cluster database environments. It's recommended that you attend the prerequisite Oracle Grid Infrastructure 11g: Manage Clusterware and ASM course before this RAC Administration course. This course is based on Oracle Database 11g Release 2.

Fulfills Oracle Certification Requirements

This course fulfills the training requirement for an Oracle Certification Path. Only Live Virtual Class, Classroom Training or Training On Demand courses will fulfill the requirement. Self-Study Courses and Knowledge Center courses do not fulfill the training requirement.

Audience

• Database Designers
• Functional Implementer
• Support Engineer
• System Analysts
• Technical Administrator
• Data Warehouse Administrator
• Technical Consultant
• Database Administrators

Course Topics Real Application Clusters Database Installation

• Installing The Oracle Database Software
• Creating A Cluster Database
• Post–database Creation Tasks
• Single-Instance Conversion Using the DBCA
• Single-Instance Conversion Using rconfig
• Background Processes Specific to Oracle RAC

Oracle RAC Administration

• Enterprise Manager Cluster Database Pages
• Redo Log Files In A RAC Environment
• Undo Tablespaces In A RAC Environment
• Starting And Stopping RAC Databases And Instances
• Initialization Parameters In A RAC Environment
• Transparent Data Encryption and Wallets in RAC
• Quiescing RAC Databases

Managing Backup and Recovery for RAC

• Protecting Against Media Failure
• Parallel Recovery in RAC
• Archived Log File Configurations
• RAC Backup and Recovery Using EM
• Archived Redo File Conventions in RAC
• Channel Connections to Cluster Instances
• Distribution of Backups

Monitoring and Tuning the RAC Database

• Determining RAC-Specific Tuning Components
• Tuning Instance Recovery in RAC
• RAC-Specific Wait Events, Global Enqueues, and System Statistics
• Implementing the Most Common RAC Tuning Tips
• Using the Cluster Database Performance Pages
• Using the Automatic Workload Repository in RAC
• Using Automatic Database Diagnostic Monitor in RAC

Services

• Configure and Manage Services in a RAC environment
• Using Services with Client Applications
• Using Services with the Database Resource Manager
• Use Services with the Scheduler
• Configuring Services Aggregation and Tracing
• Managing Services From the Command Line
• Managing Services With Enterprise Manager

Design for High Availability

• Designing a Maximum Availability Architecture
• Determine the Best RAC and Data Guard Topologies
• Data Guard Broker Configuration files in a RAC Environment
• Identifying Successful Disk I/O strategies

Course Objectives

• Install Oracle 11gR2 software and create RAC database
• Manage RAC databases
• Manage backup and recovery for RAC
• Determine RAC-specific tuning components
• Configure and manage services in a RAC environment
• Describe high availability architectures