RAC (Real Application Cluster 11g)

 

Introduction

 

Course Duration 60 HRS which Includes practical exposure and discussion on day to day RAC DBA activity 
along with RAC 2 Node Installation on Oracle Enterprise Linux.
Overview  

•	Course Objectives  
•	Typical Schedule  
•	A History of Innovation 
•	What Is a Cluster?  
•	Oracle Real Application Clusters  
•	Benefits of Using RAC   
•	Clusters and Scalability  
•	Levels of Scalability  
•	Scaleup and Speedup  
•	Speedup/Scaleup and Workloads  
•	I/O Throughput Balanced: Example  
•	Performance of Typical Components  
•	Complete Integrated Cluster ware  
•	Necessity of Global Resources  
•	Global Resources Coordination  
•	Global Cache Coordination: Example  
•	Write to Disk Coordination: Example  
•	Dynamic Reconfiguration  
•	Object Affinity and Dynamic Remastering  
•	Global Dynamic Performance Views  
•	Additional Memory Requirement for RAC  
•	Efficient Internode Row-Level Locking  
•	Parallel Execution with RAC  
•	RAC Software Principles  
•	RAC Software Storage Principles  
•	RAC Database Storage Principles  
•	RAC and Shared Storage Technologies  
•	Oracle Cluster File System  
•	Automatic Storage Management  
•	CFS or Raw?  
•	Typical Cluster Stack with RAC  
•	RAC Certification Matrix  
•	Oracle Internal & Oracle Academy Use Only
•	RAC and Services  
•	Available Demonstrations  

 

Oracle Cluster ware Installation and Configuration

 

Objectives  

•	Oracle RAC 11g Installation  
•	Oracle RAC 11g Installation: Outline  
•	Windows and UNIX Installation Differences  
•	Preinstallation Tasks  
•	Hardware Requirements  
•	Network Requirements  
•	Virtual IP Addresses and RAC  
•	RAC Network Software Requirements  
•	Package Requirements  
•	Required UNIX Groups and Users  
•	oracle User Environment  
•	User Shell Limits  
•	Configuring for Remote Installation  
•	Required Directories for the Oracle Database Software  
•	Linux Operating System Parameters  
•	Cluster Setup Tasks   
•	Verifying Cluster Setup with cluvfy  
•	Installing Oracle Clusterware  
•	Specifying the Inventory Directory 
•	Specify Home Details  
•	Product-Specific Prerequisite Checks  
•	Cluster Configuration  
•	Private Interconnect Enforcement  
•	Oracle Cluster Registry File  
•	Voting Disk File  
•	Summary and Install  
•	Run Configuration Scripts on All Nodes  
•	End of Installation  
•	Verifying the Oracle Clusterware Installation

 

RAC Software Installation

 

Objectives  

•	Installing Automatic Storage Management  
•	Installation Type  
•	Oracle Internal & Oracle Academy Use Only
•	Install Location  
•	Hardware Cluster Installation Mode  
•	Product-Specific Prerequisite Checks  
•	Select Configuration Option  
•	Privileged Operating System Groups  
•	Execute Configuration Scripts  
•	End of Installation  
•	ASM Configuration 
•	Creating ASM Disk Groups  
•	Select a Product to Install  
•	Select Installation Type  
•	Install Location  
•	Specify Cluster Installation  
•	Products Prerequisite Check  
•	Select Configuration Option  
•	Privileged Operating System Groups  
•	Check Summary  
•	root.sh Script  
•	Required Tasks Prior to Database Creation  
•	Checks Before Database Creation  

 

RAC Database Creation

 

Objectives  

•	Management Agent Installation: Specify Installation Type  
•	Specify Installation Location  
•	Specify Cluster Installation Mode  
•	Prerequisite Check and OMS Location  
•	Agent Registration Password  
•	Management Agent Installation Finish  
•	Executing the root.sh Script  
•	Creating the Cluster Database  
•	Node Selection  
•	Select Database Type  
•	Database Identification  
•	Cluster Database Management Method  
•	Passwords for Database Schema Owners  
•	Storage Options for Database Files  
•	ASM Disk Groups  
•	Oracle Internal & Oracle Academy Use Only
•	Database File Locations  
•	Recovery Configuration  
•	Database Content  
•	Initialization Parameters  
•	Security Settings and Maintenance Tasks  
•	Database Storage Options  
•	Create the Database  
•	Monitor Progress  
•	Post installation Tasks  
•	Check Managed Targets  
•	Single Instance to RAC Conversion  
•	Single-Instance Conversion Using the DBCA  
•	Conversion Steps  
•	Single-Instance Conversion Using rconfig  
•	Single-Instance Conversion Using Grid Control

 

 

RAC Database Administration

 

Objectives  

•	Cluster Database Home Page  
•	Cluster Database Instance Home Page 4-5
•	Cluster Database Instance Administration Page  
•	Cluster Home Page  
•	The Configuration Section  
•	Topology Viewer  
•	Enterprise Manager Alerts and RAC  
•	Enterprise Manager Metrics and RAC  
•	Enterprise Manager Alert History and RAC  
•	Enterprise Manager Blackouts and RAC  
•	Redo Log Files and RAC  
•	Automatic Undo Management and RAC  
•	Starting and Stopping RAC Instances  
•	Starting and Stopping RAC Instances with SQL*Plus  
•	Starting and Stopping RAC Instances with SRVCTL  
•	Switch Between the Automatic and Manual Policies 
•	RAC Initialization Parameter Files  
•	SPFILE Parameter Values and RAC  
•	EM and SPFILE Parameter Values  
•	RAC Initialization Parameters  
•	Parameters That Require Identical Settings  
•	Oracle Internal & Oracle Academy Use Only
•	Parameters That Require Unique Settings  
•	Quiescing RAC Databases  
•	Terminating Sessions on a Specific Instance  
•	How SQL*Plus Commands Affect Instances  
•	Transparent Data Encryption and Wallets in RAC  
•	ASM: General Architecture  
•	ASM Instance and Crash Recovery in RAC  
•	ASM Instance Initialization Parameters and RAC  
•	ASM and SRVCTL with RAC 
•	ASM and SRVCTL with RAC: Examples  
•	ASM Disk Groups with EM in RAC  
•	Disk Group Performance Page and RAC  

 

Managing Backup and Recovery in RAC

 

Objectives  

•	Protecting Against Media Failure  
•	Archived Log File Configurations  
•	RAC and the Flash Recovery Area  
•	RAC Backup and Recovery Using EM  
•	Configure RAC Recovery Settings with EM  
•	Archived Redo File Conventions in RAC  
•	Configure RAC Backup Settings with EM  
•	Oracle Recovery Manager  
•	Configure RMAN Snapshot Control File Location  
•	Configure Control File and SPFILE Autobackup  
•	Crosschecking on Multiple RAC Clusters Nodes  
•	Channel Connections to Cluster Instances  
•	RMAN Channel Support for the Grid  
•	RMAN Default Autolocation  
•	Distribution of Backups  
•	One Local Drive CFS Backup Scheme  
•	Multiple Drives CFS Backup Scheme  
•	Non-CFS Backup Scheme 
•	Restoring and Recovering

 

RAC Performance Tuning

 

Objectives  

•	CPU and Wait Time Tuning Dimensions  
•	RAC-Specific Tuning  
•	RAC and Instance or Crash Recovery  
•	Instance Recovery and Database Availability  
•	Instance Recovery and RAC 
•	Analyzing Cache Fusion Impact in RAC  
•	Typical Latencies for RAC Operations  
•	Wait Events for RAC  
•	Wait Event Views  
•	Global Cache Wait Events: Overview  
•	2-way Block Request: Example  
•	3-way Block Request: Example  
•	2-way Grant: Example  
•	Global Enqueue Waits: Overview  
•	Session and System Statistics  
•	Most Common RAC Tuning Tips  
•	Index Block Contention: Considerations  
•	Undo Block Considerations  
•	High-Water Mark Considerations  
•	Concurrent Cross-Instance Calls: Considerations  
•	Monitoring RAC Database and Cluster Performance  
•	Cluster Database Performance Page  
•	Determining Cluster Host Load Average  
•	Determining Global Cache Block Access Latency  
•	Determining Average Active Sessions  
•	Determining Database Throughput  
•	Accessing the Cluster Cache Coherency Page  
•	Viewing Cluster Interconnects Page  
•	Viewing the Database Locks Page  
•	AWR Snapshots in RAC  
•	AWR Reports and RAC: Overview  
•	Automatic Database Diagnostic Monitor for RAC  
•	What Does ADDM Diagnose for RAC?  
•	EM Support for ADDM for RAC  

 

Services

 

Objectives  

•	Traditional Workload Dispatching  
•	Grid Workload Dispatching  
•	Data Warehouse: Example  
•	RAC and Data Warehouse: An Optimal Solution  
•	Next Step  
•	What Is a Service?  
•	High Availability of Services in RAC  
•	Possible Service Configuration with RAC  
•	Service Attributes  
•	Service Types  
•	Service Goodness  
•	Create Services with Enterprise Manager  
•	Create Services with SRVCTL  
•	Preferred and Available Instances  
•	Modify Services with the DBMS_SERVICE Package  
•	Everything Switches to Services  
•	Use Services with Client Applications  
•	Use Services with the Resource Manager  
•	Services and Resource Manager with EM  
•	Services and the Resource Manager: Example  
•	Use Services with the Scheduler  
•	Services and the Scheduler with EM  
•	Services and the Scheduler: Example  
•	Use Services with Parallel Operations  
•	Use Services with Metric Thresholds  
•	Change Service Thresholds by Using EM  
•	Services and Metric Thresholds: Example  
•	Service Aggregation and Tracing  
•	Top Services Performance Page  
•	Service Aggregation Configuration  
•	Service Aggregation: Example  
•	strcsess Utility  
•	Service Performance Views  
•	Generalized Trace Enabling  
•	Manage Services  
•	Manage Services with Enterprise Manager  
•	Manage Services with EM  
•	Manage Services: Example  
•	Manage Services: Scenario  
•	Oracle Internal & Oracle Academy Use Only
•	Using Distributed Transactions with RAC  
•	Restricted Session and Services  

 

High Availability of Connections

 

Objectives  

•	Types of Workload Distribution 8-3
•	Client-Side Connect-Time Load Balancing  
•	Client-Side Connect-Time Failover  
•	Server-Side Connect-Time Load Balancing  
•	Fast Application Notification: Overview  
•	Fast Application Notification: Benefits  
•	FAN-Supported Event Types 8-9
•	FAN Event Status 8-10
•	FAN Event Reasons 8-11
•	FAN Event Format 8-12
•	Load Balancing Advisory: FAN Event  
•	Server-Side Callouts Implementation  
•	Server-Side Callout Parse: Example  
•	Server-Side Callout Filter: Example  
•	Configuring the Server-Side ONS 
•	Optionally Configure the Client-Side ONS 
•	JDBC Fast Connection Failover: Overview 
•	Using Oracle Streams Advanced Queuing for FAN 
•	JDBC/ODP.NET FCF Benefits 
•	Load Balancing Advisory 
•	JDBC/ODP.NET Runtime Connection Load Balancing: Overview 
•	Connection Load Balancing in RAC 
•	Load Balancing Advisory: Summary 
•	Monitor LBA FAN Events 
•	FAN Release Map 
•	Transparent Application Failover: Overview 
•	TAF Basic Configuration Without FAN: Example 
•	TAF Basic Configuration with FAN: Example 
•	TAF Preconnect Configuration: Example 
•	TAF Verification 
•	FAN Connection Pools and TAF Considerations 

 

Oracle Clusterware Administration

 

Objectives 

•	Oracle Clusterware: Overview 
•	Oracle Clusterware Run-Time View 
•	Manually Control Oracle Clusterware Stack 
•	CRS Resources 9-7
•	RAC Resources 
•	Resource Attributes: Example 
•	Main Voting Disk Function 
•	Important CSS Parameters 
•	Multiplexing Voting Disks 
•	Change Voting Disk Configuration 
•	Back Up and Recover Your Voting Disks 
•	OCR Architecture 
•	OCR Contents and Organization  
•	Managing OCR Files and Locations: Overview  
•	Automatic OCR Backups  
•	Back Up OCR Manually  
•	Recover OCR Using Physical Backups  
•	Recover OCR Using Logical Backups  
•	Replace an OCR Mirror: Example  
•	Repair OCR Configuration: Example  
•	OCR Considerations  
•	Change VIP Addresses  
•	Change Public/Interconnect IP Subnet Configuration: Example  
•	Third-Party Application Protection: Overview  
•	Application VIP and RAC VIP Differences  
•	Use CRS Framework: Overview  
•	Use CRS Framework: Example

 

Diagnosing Oracle Clusterware and RAC Components

 

Objectives  

•	One Golden Rule in RAC Debugging  
•	Oracle Clusterware Main Log Files 10-4
•	Diagnostics Collection Script  
•	Managing Diagnostic Data in RAC  
•	Cluster Verify: Overview  
•	Cluster Verify Stages  
•	Cluster Verify Components  
•	Oracle Internal & Oracle Academy Use Only
•	Cluster Verify Locations  
•	Cluster Verify Configuration File  
•	Cluster Verify: Examples  
•	Cluster Verify Output: Example 

 

Node Addition and Removal

 

Objectives  

•	Add and Delete Nodes and Instances: Overview  
•	Main Steps to Add a Node to a RAC Cluster  
•	Check Prerequisites Before Oracle Clusterware Installation  
•	Add Oracle Clusterware to the New Node  
•	Configure the New ONS  
•	Add ASM Home to the New Node  
•	Add RAC Home to the New Node  
•	Add a Listener to the New Node  
•	Add an ASM Instance to the New Node  
•	Add a Database Instance to the New Node  
•	Add an Instance to Your RAC Database Using EM  
•	Main Steps to Delete a Node from a RAC Cluster  
•	Delete the Instance on the Node to Be Deleted  
•	Clean Up the ASM Instance  
•	Remove the Listener from the Node to Be Deleted  
•	Remove the Node from the Database  
•	Remove the Node from ASM  
•	Remove the Node from the Oracle Clusterware  
•	Node Addition and Deletion and the SYSAUX Table space

 

Design for High Availability

 

Objectives  

•	Causes of Unplanned Down Time  
•	Causes of Planned Down Time  
•	Oracle’s Solution to Down Time  
•	RAC and Data Guard Complementarity  
•	Maximum Availability Architecture  
•	RAC and Data Guard Topologies  
•	RAC and Data Guard Architecture  
•	Data Guard Broker (DGB) and Oracle Clusterware (OC) Integration  
•	Oracle Internal & Oracle Academy Use Only
•	Fast-Start Failover: Overview  
•	Data Guard Broker Configuration Files  
•	Real-Time Query Physical Standby Database  
•	Hardware Assisted Resilient Data  
•	Oracle Clusterware Rolling Upgrade  
•	Clustered ASM Rolling Upgrade  
•	Patches and the RAC Environment  
•	Inventory List Locks  
•	OPatch Support for RAC: Overview  
•	Rolling Patch Upgrade Using RAC  
•	Download and Install Patch Updates  
•	Rolling Release Upgrade Using SQL Apply  
•	Database High Availability: Best Practices  
•	How Many ASM Disk Groups per Database  
•	Database Storage Consolidation  
•	Which RAID Configuration for Best Availability?  
•	Should You Use RAID 1 or RAID 5?  
•	Should You Use ASM Mirroring Protection?  
•	What Type of Striping Works Best?  
•	ASM Striping Only  
•	Hardware RAID–Striped LUNs  
•	Hardware RAID–Striped LUNs HA  
•	It Is Real Simple  
•	Extended RAC: Overview  
•	Extended RAC Connectivity  
•	Extended RAC Disk Mirroring  
•	Achieving Quorum with Extended RAC  
•	ASM Preferred Mirror Read: Overview  
•	ASM Preferred Mirror Read: Setup  
•	Enterprise Manager ASM Configuration Page  
•	ASM Preferred Mirror Read: Best Practice  
•	Additional Data Guard Benefits  
•	Using a Test Environment