Oracle Real Application Cluster ( Oracle RAC )

Objectives

• Understand Oracle cluster Architecture
• Install an Oracle cluster
• Create a Oracle RAC database
• Manage Oracle RAC instances
• Use Oracle RAC utilities
• Set up failover
• Set up Backup and Recovery
• Manage clusters
• Troubleshoot Oracle RAC

Course Topics of Oracle RAC

Cluster Architectural

• cluster Architecture
• Shared Storage
• Nodes and Interconnects
• Virtual IP Addresses
• Oracle Software
• Oracle Cluster Registry (OCR)
• The RAC Voting Disk

Oracle Clusterware

• What is Oracle Clusterware ?
• Oracle Clusterware Components
• Oracle Clusterware Processes
• Oracle Clusterware and Shared Storage
• Oracle Clusterware Preinstallation Steps
• Node Preparation
• Configuraing SSH User Equivalency
• Installing Oracle Clusterware
• cluvfy – The Cluster Varification Utility
• Oracle Clusterware Postinstallation

 Installing DB Software and Creating a RAC Database

• Installation Overview
• Configuring the OS Envirionment
• Verifying System REadiness with the CVU
• Installing the Database Software
• Troubleshooting Installation Setup
• Recommended Postinstallation Tasks
• Running the VIPCA
• Creating a Cluster Database Using DBCA
• Database Pre-Creation Tasks
• Initialization Parameter

RAC Database Architecture

• Oracle Single-Instance Architecture
• Overview of RAC
• RAC Architecture
• RAC Instance and Parameter Files
• RAC Database Components
• RAC Instance Background Processes
• Global Resource Direcotry
• Overview of Cache Fusion
• Cache Fusion Components – GES and GCS
• Cache Fusion Background processes
• Application Connection to RAC

Managing Oracle Clusterware

• About Oracle Clusterware
• Backing Up and Recovering Voting Disks
• Adding and Removing Voting Disks
• The OCR
• Changing the OCR Configuration
• Adding and Removing an OCR Location
• backing Up and Recovering the OCR
• Resotring from Automatic OCR Backups
• Moving or Replacing the OCR
• Repairing the OCR Configuration
• Troubleshooting the OCR

RAC Instance Management

• Overview of RAC Instance Management
• Starting and Stoping a RAC Database
• RAC Database Identical Parameters
• RAC Database Unique Parameters
• Changing Parameter Values
• Administering Undeo Tablespaces in RAC
• Administering Redo Logs in RAC

RAC Utilities

• The ocrcheck Utilitiy
• The ocrdump Utility
• The crs_stat Utility
• The crsctl Utility
• The Server Control (SRVCTl) Utility
• SRVCTL ADD
• SRVCTL CONFIG
• SRVCTL ENABLE and DISABLE
• SRVCTL GETENV
• SRVCTL MODIFY
• SRVCTL RELOCATE
• SRVCTL REMOVE
• SRVCTL START
• SRVCTL STOP

Services

• Overview or Services
• Types of Servicers
• Creating Services with DBCA
• Creating SErvices with SRVCTL
• Preferred and Available Instances for Services
• Using Services
• Managing Services
• Service Views
• Tracing with Services

 Failover

• Transparent Application Failover (TAF)
• Client-Side vs. Server-Side TAF
• configuring TAF on the client
• Configuring TAF on the Server
• Using OEM to Configure TAF
• Using SRVCTL to Configure TAF
• Using DBCA to Configure TAF
• The DBMS_SERVICE Package
• Connecting to the Database with TAF
• Monitoring TAF Connection

RAC Backup and Recovery

• Overview of RAC Backup and Recovery
• Log Archiving in RAC
• Undo Tablespaces in RAC
• Using Flashback Features in RAC
• Deploying a Flash Recovery Area in RAC
• Performing RMAN Backups of a RAC Database
• Performing Non-RMAN Backups
• Preparing to Restore and Recover with RMAN
• Recover the RAC Database with RMAN
• Recovering Without RMA

 Cluster Management

• Overview of Cluster Management Tasks
• Extending the Clusterware Home Directory
• Extending the ASK Home directory
• Extending the Database Software Home Direcotory
• Creating a Listener on the New Node
• Creating the New Instance
• Verifying the New Instance
• Removing a Node

 RAC Troubleshooting

• The Oracle Clusterware Alert Log
• Clusterware Component Log Files
• Using crsctl to Diagonose Cluster Issues
• Using diagcollection
• Checking Interconnect Setting
• cluvfy – Verifying clusterware Component Integrity
• cluvfy – verifying Cluster Registry Integrity
• cluvfy – Verifying Cluster Integrity
• RAC Database Aletrts
• The racdiag.sql Script
• The oradebug Utility

RAC Tuning

• RAC Tuning Methodology
• Using Performance Views in RAC
• Monitoring Cache Fusion
• Global Cache Latencies
• Monitoring Cache Transfers

Upcoming Batches Schedule

Contact – Call us at 9372005897/ 8956930899 or fill out this form, and we will be happy to contact you back.