Victoria Education Group

Advanced Oracle DBA Certificate Course

 

 

Class Schedule: Every Sat 9:00am-1:00pm
Please come to try the class one time for free!!!
Please call 416-665-1888, 647-290-5809 or email at davidli@viccollege.com for further inquiry and reservation

 

Oracle Database 11g: RAC Administration
 
What you will learn:

This course offers students an introduction to the general features and capabilities of Oracle Database 11g Release 1 for Oracle Real Application Clusters (RAC). Students learn how to install and administer Oracle Clusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control. Increase your efficiency by learning how to configure and use database services as well as the Load Balancing Advisory in a RAC environment. Learn how to add and remove nodes in clusters and how to patch both Oracle Clusterware and Real Application Clusters software in a rolling fashion.

Learn To:
Install Oracle Clusterware and Real Application Clusters
Administer a RAC Database
Administer Database Services in a RAC environment
Administer Oracle Clusterware
Add/Remove a node to/from a cluster
Patch Oracle Clusterware and RAC software

Audience

Data Warehouse Administrator
Database Administrators
Support Engineer
Technical Administrator

Prerequisites
General understanding of database administration
 
Course Objectives
Identify Real Application Clusters components
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

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

Last update:. Visits --