Contents
Chapter 1: Overview of Oracle RAC
High Availability and Scalability
Database Clustering Architecture
Achieving the Benefits of Oracle RAC
High AvailabilityAgainst Unplanned Downtime
High Availability Against Planned Downtime
Oracle RAC One Node to Achieve HA
Consolidating Database Services with Oracle RAC
Considerations for Deploying RAC
High Availability Considerations
Chapter 2: Clusterware Stack Management and Troubleshooting
Clusterware 12cR1 and Its Components
Storage Components of Oracle Clusterware
ASM and Clusterware: Which One is Started First?
Clusterware Management Tools and Utilities
Managing OCR and the Voting Disk
Adding and Removing Cluster Nodes
Troubleshooting common Clusterware Stack Start-Up Failures
Diagnose, Debug, Trace Clusterware and RAC Issues
Debugging Clusterware Components and Resources
Grid Infrastructure Component Directory Structure
Oracle Clusterware Troubleshooting - Tools and Utilities
Chapter 3: RAC Operational Practices
SCAN Listener in Second Network (12c)
Global Database Services (12c)
Performance Metrics Collection
Managing Databases and Instances
Chapter 4: New Features in RAC 12c
Oracle Flex Cluster Architecture
Scalability and Availability of Flex Clusters
Replacing ASM Disk in Disk Group
Scrubbing ASM Disk Groups and Files
Reading Data Evenly in ASM Disk Group
Measure and Tune Rebalance Operation
12cR1: Miscellaneous New Features for RAC
Public Networks for RAC: IPv6 Support Added
Online Resource Attribute Modification
RAC 12cR1: Policy-Based Management and Administration
ASM Disk Group: Shared ASM Password File
Valid Node Checking: Restricting Service Registration
RAC 12cR1: Restricting Service Registration
Oracle ASM, ACFS, and ADVM: Improvements and New Features
Windows: Support for Oracle Home User
OUI: Enhancements and Improvements
12cR1: Installations/Upgrades—Running Scripts Automatically
12cR1: Introducing Application Continuity
Transaction Idempotence and Java Transaction Guard
Deprecated and Desupported Features
Chapter 5: Storage and ASM Practices
Storage Architecture and Configuration for Oracle RAC
Storage Architecture and I/O for RAC
Multipath Device Configuration
Manage ASM Using SQL Command and V$ASM Views
Store OCR and Voting Disk in ASM
Choose ASM for OCR and Voting Disk at GI Installation
Move OCR and Voting Disk Files to a New ASM Diskgroup
Create ACFS for Oracle RAC Home with ASMCA
Chapter 6: Application Design Issues
Excessive TRUNCATE or DROP Statements
Chapter 7: Managing and Optimizing a Complex RAC Environment
Shared vs. Non-Shared Oracle Homes
Creating and Managing Server Pools
Planning and Designing RAC Databases
Small- vs. Large-Scale Cluster Setups
Split-Brain Scenarios and How to Avoid Them
Understanding, Debugging, and Preventing Node Evictions
Node Evictions—Synopsis and Overview
Extended Distance (Stretch) Clusters—Synopsis, Overview, and Best Practices
Extended Distance (Stretch) Clusters: Setup/Configuration Best Practices
Setup and Configuration—Learning the New Way of Things
Oracle Enterprise Manager Cloud Control 12c
RAC Installation and Setup—Considerations and Tips for OS Families: Linux, Solaris, and Windows
RAC Database Performance Tuning: A Quick n’ Easy Approach
The 3 A’s of Performance Tuning
Chapter 8: Backup and Recovery in RAC
Online Backup and Recovery Prerequisites
Shared Location for Redo and Archive Logs
Snapshot Control File Configuration
Multiple Channels Configuration for RAC
Instance/Crash Recovery in RAC
Manage RMAN with OEM Cloud Control 12c
Configuring Network for Oracle RAC and Clusterware
Establishing IP Address and Name Resolution
Network Specification in Grid Infrastructure Installation
Network Configuration in Clusterware
Chapter 10: RAC Database Optimization
Analysis of the Receiving Side
GC CR Grant 2-Way/Gc Current Grant 2-Way
GC CR Block Busy/GC Current Block Busy
GC CR Block Congested/GC Current Block Congested
GC Buffer Busy Acquire/Release
Chapter 11: Locks and Deadlocks
Troubleshooting Locking Contention
Troubleshooting Library Cache Lock Contention
Chapter 12: Parallel Query in RAC
Concurrent Union Processing (12c)
Chapter 13: Clusterware and Database Upgrades
Initiating an Oracle Clusterware Upgrade
The Importance of the Rootupgrade.sh Script
Deploying Manual Database Upgrade
Database Upgrade Using the DBUA
Upgrading to 11.2.0.2 or Higher
Deploying RAC One Node Binaries
Deploying a RAC One Node Database
Initiating DBCA’s Creation Process
Parameters Specific to RAC One Node
Managing RAC One Node Database
Verifying Configuration Details
Verifying the Online Relocation Status
Performing Online Database Relocation
Handling Unplanned Node and Cluster Reboots
Converting Between RAC One Node and Standard RAC
Managing RAC One Node with Cloud Control 12c
Database Relocation with Cloud Control 12c