Oracle Database 11g: RAC Administration Release 2

Oracle University
Oracle Database 11g: RAC Administration Release 2

Duration: 3 Days
What you will learn
In this course, students will learn about RAC database administration in the Oracle Grid Infrastructure environment.
Students will learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL,
CRSCTL, and SQL*Plus. Students will study the new connection architecture and how to make those connections highly
available. Backup and recovery issues relative to cluster database environments will also be studied.
This course is based on Oracle Database 11g Release 2.
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
Data Warehouse Administrator
Database Administrators
Database Designers
Functional Implementer
Support Engineer
System Analysts
Technical Administrator
Technical Consultant
Required Prerequisites
Oracle Database Administrator
Suggested Prerequisites
Oracle Database 11g: Administration Workshop II Release 2
Oracle Database 11g: Introduction to SQL Release 2
Oracle Database 11g: Administration Workshop I Release 2
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.
Describe how Grid Plug and Play affects Clusterware
Copyright © 2010, Oracle. All rights reserved. Page 1
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
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
Copyright © 2010, Oracle. All rights reserved. Page 2




pearson vueISO 9001