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 SRVCTL to Configure TAF 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