Unit-1

Introduction - Introduction of Clusters - Types of Clusters - Components of Cluster - Hardware Requirement for Cluster - Define Oracle Real Application Cluster - Advantages of using RAC - RAC Architecture and Concepts - RAC �design considerations - *Shared and local oracle home - *Archived log configurations - SGA Structures - Cache Fusion - Background Processes - Various high availability architecture with RAC (overview) - *Data guard configuration - *Extended clusters - Operating System preparation for RAC - Practicals - Installing Operating System - Configuring Network.

Unit-2

10g RAC Installation - About cluster ware - Benefits of cluster ware - Cluster ware components (ocr and voting disk) - About CRS - CRS Daemons - CRS Services/Nodeapps - Background processes - About Shared Storage and configure - About VIP - Kernel Parameters - Groups and Users - Validating Pre installation steps - Using CLUVFY - Secure Shell - Install Cluster ware - Post installation checks.

Unit-3

About Storage Types - File system, Raw Devices, ASM, OCFS, OCFS2 - ASM advantages - Striping and mirroring using ASM - ASM initialization parameters - ASM Background Processes - Preparing Storage for ASM SPFILE - Pre installation check for database installation - Installation Oracle Database Software - Creating Oracle Database.

Unit-4

Creating one more Instance - Modifying necessary parameters - Adding redo thread and undo table space for new instance - Changing a particular instances parameter in RAC - Using asmcmd utility - Switching RAC instance to archivelog - Managing Voting and OCR - Taking backups of Voting and OCR Disks - Restoring backups of Voting and OCR - Automated backups of OCR.

Unit-5

Creating one more Instance - Modifying necessary parameters - Adding redo thread and undo table space for new instance - Changing a particular instances parameter in RAC - Using asmcmd utility - Switching RAC instance to archivelog - Managing Voting and OCR - Taking backups of Voting and OCR Disks - Restoring backups of Voting and OCR - Automated backups of OCR.

 

Unit-6

Switch the RAC Database with Flashback - About OCFS2 - Performance enhancements in ocfs2 - Configure OCFS2 - Installing the OCFS2 at the os level - Configuring the ocfs2 using ocfs2console in the nodes - formatting the shared file system in ocfs2 and mounting in the nodes - Creating Database in OCFS2.

Unit-7

Load Balancing - Types of Load Balancing - Configuring Server Side Load Balancing - Configuring Client Side Load Balancing - Testing different Load balancing parameters - About database services - Dbms_services package - Server side Load balancing using services - Administering instances work policy using services - TAF using services - Testing TAF using services (dbca).

Unit-8

Consideration of Logical Backup - Consideration of Flash Recovery Area in RAC - Creating RMAN Catalogs - Backing up Spfile - Physical Backup and Recovery in RAC through RMAN.

Unit-9

Non-ASM to ASM - Backing up the Non-ASM database in RMAN - Moving the database to ASM using RMAN Cloning - Migration to RAC (single instance to multi-instance) - Modifying the initialization parameters and adding the Parameter for RAC - Creating the redo thread and undo table space for adding the instance - Registering in the OCR for administration of the database.

Unit-10
Adding a Node to an Existing RAC environment - Removing an Instance from RAC - Overview of using AWR and ADDM - Overview of common manageability framework - Creating AWR snapshots and about baselines - Generating AWR report - Interpreting the rac specific sections of AWR (overview) -Global cache load profile -Global cache efficiency profile -Global cache and Enqueue services - work load characteristics -SQL statement ( Specific to RAC) -Global CR server statistics -Global enqueue statistics -Global current served