CITATION

Gopalakrishnan, K. Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition. US: McGraw-Hill Osborne Media, 2011.

Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition

Published:  August 2011

eISBN: 9780071752619 0071752617 | ISBN: 9780071752626
  • Contents
  • Foreword
  • Acknowledgments
  • Introduction
  • Part I: High Availability Architecture and Clusters
  • 1 Introduction to High Availability and Scalability
  • High Availability
  • Scalability
  • Oracle Real Application Clusters Solution
  • Emerging Trends
  • In a Nutshell
  • 2 Clustering Basics and History
  • Grid Computing with Clusters
  • Shared Storage in Clustering
  • History of Oracle RAC
  • Oracle Parallel Server Architecture
  • Components of an OPS Database
  • The Oracle RAC Solution
  • In a Nutshell
  • 3 Oracle RAC Architecture
  • Single-Instance vs. Oracle RAC Environment
  • Oracle RAC Components
  • Oracle Kernel Components
  • In a Nutshell
  • Part II: Installation, Configuration, and Storage
  • 4 Oracle Grid Infrastructure Installation
  • Preinstallation Tasks
  • In a Nutshell
  • 5 Oracle RAC Installation
  • Oracle Real Application Clusters Installation
  • In a Nutshell
  • 6 Automatic Storage Management
  • Facts about Automatic Storage Management
  • ASM Administration and Management
  • ASM Tools
  • ASMLib
  • In a Nutshell
  • Part III: Oracle RAC Administration and Management
  • 7 Oracle RAC Basic Administration
  • Initialization Parameters
  • Starting and Stopping Instances
  • Administering Undo
  • Administering a Temporary Tablespace
  • Administering Online Redo Logs
  • Enabling the Flashback Area
  • Managing Database Configuration with SRVCTL
  • Managing Database Objects
  • In a Nutshell
  • 8 Oracle RAC Advanced Administration
  • Understanding Services
  • Administering Services
  • Administering SCAN
  • Administering Cluster Ready Services
  • Administering OCR
  • Administering Oracle Local Registry
  • Administering the Voting Disk
  • In a Nutshell
  • 9 Oracle RAC Backup and Recovery
  • Introduction to Backups
  • Oracle Backup Basics
  • Instance Recovery in Oracle RAC
  • Crash Recovery
  • Instance Recovery
  • Crash Recovery and Media Recovery
  • Dynamic Reconfiguration and Affinity Remastering
  • Backup and Recovery of the Voting Disk and OCR
  • In a Nutshell
  • 10 Oracle RAC Performance Management
  • Oracle RAC Design Considerations
  • Partitioning the Workload
  • Scalability and Performance
  • Choosing the Block Size for an Oracle RAC Database
  • Using Automatic Segment Space Management
  • Introduction to the V$ and GV$ Views
  • Oracle RAC Wait Events
  • Global Cache Statistics
  • Global Cache Service Times
  • Enqueue Tuning in Oracle RAC
  • Oracle AWR Report
  • Tuning the Cluster Interconnect
  • In a Nutshell
  • Part IV: Advanced Concepts in Oracle RAC
  • 11 Global Resource Directory
  • Resources and Enqueues
  • Cache Coherency
  • Global Enqueue Services
  • Global Cache Services
  • In a Nutshell
  • 12 A Closer Look at Cache Fusion
  • Key Components in Cache Fusion
  • Cache Fusion I or Consistent Read Server
  • Cache Fusion II or Write/Write Cache Fusion
  • Background Process and Cache Fusion
  • In a Nutshell
  • 13 Workload and Connection Management
  • Workload Distribution and Load Balancing
  • Load Balancing and Oracle Net Services
  • Transparent Application Failover
  • Workload Management
  • In a Nutshell
  • 14 Oracle RAC Troubleshooting
  • Installation Log Files
  • Log Directory Structure in the Oracle RDBMS
  • Log Directory Structure in Oracle Grid Infrastructure
  • Troubleshooting a Failed Oracle Grid Infrastructure Installation
  • Inside the Database Alert Log
  • RAC ON and OFF
  • Database Performance Issues
  • Debugging Node Eviction Issues
  • Advanced Debugging for Oracle Clusterware Modules
  • Debugging Various Utilities in Oracle RAC
  • In a Nutshell
  • Part V: Deploying Oracle RAC
  • 15 Extending Oracle RAC for Maximum Availability
  • Extended Benefits
  • Design Considerations
  • Common Techniques for Data Mirroring
  • Extended Oracle RAC Limitations
  • Extended Oracle RAC vs. Oracle Data Guard
  • In a Nutshell
  • 16 Developing Applications for Oracle RAC
  • Application Partitioning
  • Data Partitioning
  • Buffer Busy Waits/Block Contention
  • Index Partitioning
  • Working with Sequences
  • Connection Management
  • Full Table Scans
  • Library Cache Effect in the Parsing
  • Commit Frequency
  • In a Nutshell
  • Part VI: Appendixes
  • A: Oracle RAC Reference
  • B: Adding and Removing Cluster Nodes
  • C: References
  • Index