11gR2: RAC Administration - NEW

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. Students will learn about Oracle RAC One Node and online migration. Students will learn about Quality of Service concepts. Finally,students will learn how to upgrade and path Oracle RAC databases. New materials and labs have been added to enhance customer experience with the latest information.

This course counts toward the Hands-on course requirement for the following certifications
Oracle Database 11g Administrator Certification
Oracle Database 10g: Real Application Clusters Administrator Certified Expert
Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-onRequirement.

Learn To:
Install Oracle Clusterware and Real Application Clusters.
Administer a RAC Database.
Administer database services in an RAC environment.
Administer Oracle Clusterware.
Add/Remove a node to/from a cluster.
Patch Oracle Clusterware and RAC software.
Upgrade and path Oracle RAC databases.
Study the new connection architecture and how to make those connections highly available.

Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Backup and Recovery
You'll also study backup and recovery issues relative to cluster database environments. Explore Oracle RAC One Node, online migration and quality of service concepts. New materials and labs have been added to enhance the customer experience with the latest information.

Data Warehouse Administrator
Database Administrators
Support Engineer
Technical Administrator

General understanding of database administration,Oracle Database, Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2 NEW

Oracle Certified Expert

Grid Infrastructure 11gR2: Manage Clusterware & ASM

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 Identify Real Application Clusters components

Grid Infrastructure: Overview
Oracle Grid Infrastructure
What Is a Cluster?
What Is Clusterware?
Oracle Clusterware
Oracle Clusterware Architecture and Services
Goals for Oracle Clusterware
Oracle Clusterware Networking
Oracle Grid Infrastructure for a Cluster

RAC Concepts
Overview of Oracle RAC
RAC One Node Single-Instance High Availability
Oracle RAC One Node
Oracle RAC One Node and Oracle Clusterware
Cluster-Aware Storage Solutions
Oracle Cluster File System
Benefits of Using RAC
Clusters and Scalability

Installing and Configuring Oracle RAC
Installing the Oracle Database Software
Creating the Cluster Database
Database Type Selection
Database Identification
Cluster Database Management Options
Passwords for Database Schema Owners
Database File Locations
Recovery Configuration

Oracle RAC Administration
Oracle RAC Administration
Cluster Database Instance Home Page
Cluster Home Page
Configuration Section
Topology Viewer
Enterprise Manager Alerts and RAC
Enterprise Manager Metrics and RAC
Enterprise Manager Alert History and RAC

Managing Backup and Recovery for RAC
RAC and Instance Recovery
Instance Recovery and Database Availability
Instance Recovery and RAC
Protecting Against Media Failure
Media Recovery in Oracle RAC
Parallel Recovery in RAC
Archived Log File Configurations
RAC and the Fast Recovery Area

Global Resource Management Concepts
Need for Global Concurrency Control
Global Resource Directory (GRD)
Global Resource Management
Global Resource Remastering
Global Resource Recovery
Global Resource Background Processes
Global Resource Access Coordination
Global Enqueues

RAC Database Monitoring and Tuning
CPU and Wait Time Tuning Dimensions
RAC-Specific Tuning
Analyzing Cache Fusion Impact in RAC
Typical Latencies for RAC Operations
Wait Events for RAC
Wait Event Views
Global Cache Wait Events: Overview
Global Enqueue Waits

Managing High Availability of Services
Oracle Services
Services for Policy- and Administrator-Managed Databases
Default Service Connections
Creating Service with Enterprise Manager
Creating Services with SRVCTL
Managing Services with Enterprise Manager
Managing Services with EM
Managing Services with srvctl

High Availability of Connections
Types of Workload Distribution
Client-Side Connect-Time Load Balancing
Client-Side Connect-Time Failover
Server-Side Connect-Time Load Balancing
Fast Application Notification: Overview
Fast Application Notification: Benefits
FAN-Supported Event Types
FAN Event Status

Upgrading and Patching Oracle RAC
Types of Patches
Patch Properties
Configuring the Software Library
Setting Up Patching
Obtaining Oracle RAC Patches
Downloading Patches
Reduced Down-Time Patching for Cluster Environments
Rolling Patches

Oracle RAC One Node
Verifying an Existing RAC One Node Database
Oracle RAC One Node Online Migration
Online Migration Considerations
Performing an Online Migration
Online Migration Illustration
Online Maintenance: Rolling Patches
Adding an Oracle RAC One Node Database to an Existing Cluster
Converting a RAC One Node Database to RAC

Quality of Service Management
QoS Management Background
QoS Management Overview
QoS Management and Exadata Database Machine
QoS Management Focus
QoS Management Benefits
QoS Management Functional Overview
QoS Management Policy Sets
Server Pools

Design for High Availability
Causes of Unplanned Down Time
Causes of Planned Down Time
Oracle’s Solution to Down Time
RAC and Data Guard Complementarity
Maximum Availability Architecture
RAC and Data Guard Topologies
RAC and Data Guard Architecture
Data Guard Broker (DGB) and Oracle Clusterware (OC) Integration