Oracle Database 11g: RAC Administration Release 2 NEW

In this course, you'll learn about RAC database administration in the Oracle Grid Infrastructure environment. Develop the skills to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL and SQL*Plus.

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.

Counts as Hands-On Certification Requirement

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

Please Note:

Only Classroom Training, Live Virtual Class or Training On Demand formats of this course will meet the Certification rands-on requirement.

Audience

• Support Engineer
• Technical Administrator
• Data Warehouse Administrator
• Database Administrators

Course Topics Oracle Clusterware Installation

• Oracle RAC 11g Installation
• Cluster Setup Tasks
• Using Raw Partitions
• Cluster Configuration

RAC Installation

• Installing Automatic Storage Management
• Configure ASM Storage
• Install the Database Software

Database Creation

• Management Agent Installation
• Storage Options for Database Files
• Create the Database
• Single Instance to RAC Conversion

RAC DB Administration

• Cluster Database Instance Administration
• Topology Viewer
• Automatic Undo Management and RAC
• Quiescing RAC Databases
• Transparent Data Encryption and Wallets in RAC
• ASM Instance and Crash Recovery in RAC

Backup and Recover a RAC DB

• Protecting Against Media Failure
• Oracle Recovery Manager

RAC DB Monitoring and Tuning

• CPU and Wait Time Tuning Dimensions
• Dynamic Reconfiguration
• ADDM Analysis

Services

• Workload Dispatching
• High Availability of Services in RAC
• Services and Resource Manager with EM
• Change Service Thresholds
• Using Distributed Transactions with RAC

High Availability of Connections

• Fast Application Notification
• Load Balancing Advisory
• Transparent Application Failover

Oracle Clusterware Administration

• Controlling the Oracle Clusterware Stack
• Back Up and Recover Your Voting Disks
• Back Up and Recover Oracle Cluster Registry
• Prevent Automatic Instance Restarts

Diagnosing the Oracle Clusterware components

• Oracle Clusterware Main Log Files
• RAC Diagnostic Infrastructure

Node Addition/Removal

• Add and Delete Nodes and Instances
• Clone Oracle Clusterware

Design for High Availability

• Maximum Availability Architecture
• RAC and Data Guard Topologies
• Extended RAC Connectivity
• Extended RAC disk mirroring
• Patch your RAC system in a rolling fashion

Workshop

• Extend your cluster using Grid Control
• Patch Oracle Clusterware

Oracle RAC One Node

• Online database migration
• Add a RAC One Node database to an existing cluster
• Convert a RAC One Node Database to a RAC database
• Convert a single instance database to a RAC One Node database

Quality of Service Management (QoS)

• QoS concepts
• QoS components
• Oracle database QoS management

Course Objectives

• 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