ORACLE RAC DBA

Oracle 11g RAC
About the Course

Oracle Real Application Clusters (Oracle RAC) course prepares the students to successfully
Administer and manage Multi-Instance Oracle Databases. Oracle RAC is the foundation for Oracle’s
Grid computing and provides Scalability and High Availability to Mission critical 24x7 databases. In
today’s database world, Oracle RAC has become one of the most sought after skill from Oracle
Database Administrators. The demand for Oracle RAC professionals is ever increasing than before.

Many companies across the world hire Oracle DBAs with good knowledge of Oracle RAC.

In this course, students will gain thorough knowledge about Oracle RAC Concepts & Architecture.
Students will also have hands-on exposure to RAC Installation, Configuration and Administration.
The focus is more on practical setup and configuration so that students will gain thorough hands-on
Knowledge required to manage Oracle RAC databases in real time. Students will also be exposed to

Real time scenarios that will be implemented in typical RAC Projects.

The course will be implemented on Linux operating system platform.

Course Pre-requisites
·         Prior knowledge on Oracle Database Administration (Oracle DBA)
·         Hands-on exposure to basic Linux commands ,Basic SQL

1. Introduction to Oracle RAC
 Introduction to Clusters
 About Clusterware
 What is RAC?
 Overview of Oracle Clusterware
 Overview of Storage in RAC
 Overview of Oracle ASM
 Benefits of RAC
 Tools for Managing RAC
 ASM Concepts
 ASM Instances
 ASM Disk Groups

2. Preparing the Cluster
 Verifying System Requirements
 Preparing the Server
 Configuring the Network
 Preparing the Operating System
 Configuring Users & Groups
 Configuring Installation Directories
 Configuring Shared Storage



3. Installing Oracle Grid Infrastructure
 Installing the Oracle Grid Infrastructure
 Verifying the Oracle Clusterware Installation

4. Installing & Creating RAC Database
 Installing Oracle Software
 Creating Additional Disk Groups
 Creating RAC Database
 Verifying RAC Database Installation

5. Oracle RAC Architecture
 Instance in RAC
 Cache Fusion in RAC
 Database in RAC
 Global Dynamic Performance Views

6. Administering Oracle Clusterware Components
 Starting & Stopping Clusterware
 Enabling & Disabling Clusterware
 Checking the Integrity of OCR & Voting Disks
 Adding & Removing OCR & Voting disks
 Backup & Recovery of OCR & Voting disks
 Troubleshooting Oracle Clusterware
 Oracle Clusterware Log files
 Maintaining Oracle Local Registry

7. Administering ASM Instances
 Initialization Parameters for ASM Instances
 Parameter Files for ASM Instances
 Starting & Stopping ASM Instances

8. Administering ASM Disk Groups
 Creating Disk groups
 Altering Disk groups
 Adding & Removing Disks
 Mounting & Dismounting Disk Groups
 Dropping Disk Groups


10. Administering RAC Instances & Database
 Overview of RAC DB Administration
 Starting and Stopping RAC Instances and Databases
 Terminating Sessions
 Initialization Parameters for RAC
 Quiescing RAC Database
 Administering Storage in RAC

11. High Availability of Connections
 Client-side Connect-time Load Balancing
 Client-side Connect-time Failover
 Server-side Connect-time Load Balancing
 Transparent Application Failover (TAF)
 TAF Configuration
 TAF Verification

12. Backup & Recovery of RAC Database
 Overview of RAC Database Backup & Recovery
 Fast Recovery Area in RAC
 Archiving in RAC
 Performing RAC Backups
 Performing Recovery in RAC
 Displaying Backup Reports for RAC

13. Adding Nodes and Instances in RAC
 Preparing the new node
 Extending Oracle Grid Infrastructure Home & Oracle RAC Home to the new node
 Creating new Instance
 Verifying new Instance

14. Converting Single Instance Database to RAC Database
 Considerations for Conversion
 Using DBCA for Conversion
 Post Conversion Considerations

15. Troubleshooting RAC Issues
 Diagnosing Cluster Issues
 Using Cluster Verification Utility
 RAC Alerts & Alert Log messages

16. Patching RAC Environments
 Overview of Oracle Patches
 Downloading the Patches
 Patch Analysis
 Applying Patches
 Verifying Patches










No comments:

Post a Comment