As you know, the Oracle Database with the Oracle Real Application Clusters (RAC) option allows running multiple database instances on different servers in the cluster against a shared set of data files, also known as the database. The database spans multiple hardware systems and yet appears as a single unified database to the application. This enables the utilization of commodity hardware to reduce total cost of ownership and to provide a scalable computing environment that supports various application workloads. Oracle RAC is Oracle's premier shared disk database clustering technology.
I finished review of the book about Oracle RAC technology - "Expert Oracle RAC 12c" by authors Syed Jaffar Hussain (Oracle ACED, DBA of the Year for 2011), Tariq Farooq (Oracle ACED), Riyaj Shamsudeen (Oracle ACED, Member of OakTable Network) and Kai Yu (Oracle ACED, Technologist of the Year for 2012) published by APRESS.
The book "Expert Oracle RAC 12c" is covered every aspect of Oracle Real Application Clusters. It means, the book do not covered only new features of Oracle RAC 12c, but every chapter assumed the latest version of Oracle RAC 12cR1. You can find everything of about Oracle RAC in this book. If you want learn deep Oracle RAC 12c, then you must start read this book. You can read my review of each chapter at below, so every chapter is detailed and you can read valuable explanations, in other words experience of authors in each chapter. As you know each author of this book is famous expert on Oracle.
Please, see the content of the book at below:
Chapter 1: Overview of Oracle RAC by Kai Yu
This chapter covered explanation of High Availability, Database Scalability, also Oracle RAC architecture, so RAC: Cache Fusion and background processes. Achieving the benefits of Oracle RAC is covered TAF, FCF and AC (Application Continuity in 12c) configurations. And you find "RAC or Not" question's answer in this chapter.
Chapter 2: Clusterware Stack Management and Troubleshooting by Syed Jaffar Hussain and Kai Yu
This chapter described the architecture and complex technical stack of Oracle Clusterware and explains how those components works. This chapter also discussed some new features Oracle Clusterware features intrduced in Oracle 12cR1. You can find examples for diagnose, debug, trace clusterware and explanation solution for RAC issues, so this chapter discussed trobleshooting and monitoring tools and utilities.
Chapter 3: RAC Operational Practices by Riyaj Shamsudeen
As you see name of chapter, this chapter covered very nice explanation of services. Also explained how to using services for application workloads, load balancing. This chapter described SCAN IP, SCAN Listeners and says don't allow an application to connect to VIP listeners directly. In this chapter you can find answers "how to configure TAF, FCF ?"and "what is Transactional Guard (12c) and Application Continuity (12c) ?" questions. Also this chapter covered practical information about RAC Database Management.
Chapter 4: New Features in RAC 12c by Syed Jaffar Hussain, Kai Yu and Tariq Farooq
It is very interesting chapter for me, because this chapter is covered new features in RAC 12c. In this chapter you can read very good explanation Flex Cluster Architecture, Oracle Flex Automatic Storage Management (Flex ASM) mechanism. Also you can read other new features of Flex ASM, such as Scrubbing ASM disk groups, EXPLAIN WORK (for tuning rebalance operation), how to using PDB's on RAC and etc..
Chapter 5: Storage and ASM Practices by Kai Yu
This chapter, discussed storage - one of the key in Oracle RAC database. You can read deep information about storage architecture and configuration for RAC, also RAID configurations and Storage protocols. This chapter also explained Oracle Automatic Storage Management (ASM), ASM Instance, ASM Storage Architecture and Management ASM Disk groups with SQL*Plus and ASMCA and ASM Cloud File System. You can find answer for "How to store ORC and VOTE files in ASM Disk group?" question in this chapter.
Chapter 6: Application Design Issue by Riyaj Shamsudeen
As you know bad design of application is decrease performance of database. This chapter discussed design patterns, methods to troubleshoot these issue and possible strategies for resolving them. So, this chapter discussed localized inserts, sequence cache, excessive commits, and index design in Oracle RAC databases.
Chapter 7: Managing and Optimizing a Complex RAC Environment by Syed Jaffar Hussain and Tariq Farooq
This chapter starting "Shared vs Non-Shared Database home" and continue with very good explanation of Server pools in RAC. Also you can read about Policy-Managed databases. I sure "Understanding, Debugging and Preventing Node Evictions" will very interesting for you in this chapter.
Chapter 8: Backup and Recovery in RAC by Syed Jaffar Hussain
This chapter covered Backup and Recovery on Oracle RAC databases. You can read about best database backup strategies, RAC standby databases, Management RMAN with OEM 12c and OCR backups, recovery scenarios in this chapter.
Chapter 9: Network Practices by Riyaj Shamsudeen and Kai Yu
As you know, the network is important part of RAC infrastructure. This chapter covered all aspect of network for RAC. You can read valuable explanations network protocols, VIPs, cluster interconnects, SCAN VIP and Listeners, load balancing and failover on network, name resolution on DNS and etc. in this chapter.
Chapter 10: RAC Database Optimization by Riyaj Shamsudeen
This chapter covered with explanation of Global Cache Fusion processing, also Performance Analysis on Oracle RAC database using ADDM, AWR and ASH reports. You can read about all RAC wait events and DRM processing and troubleshooting DRM in this chapter.
Chapter 11: Locks and Deadlocks by Riyaj Shamsudeen
Resources and locks are maintained in GRD by GES layer of RAC code. This chapter covered Resources and Locks in RAC database. In addition, you can read the LMD process prints essential details in a trace file, and the analysis of LMD trace files.
Chapter 12: Parallel Query in RAC by Riyaj Shamsudeen
This chapter covered Parallel Execution (PX ) of SQL statement in RAC database. Also explained PX and Cache Fusion dependencies, so Parallelism features (In-Memory parallelism and Auto DOP) and RAC in this chapter
Chapter 13: Clusterware and Database Upgrades by Syed Jaffar Hussain
As you know, every time upgrade is important and difficult task for RAC databases. You can read every steps of Clusterware and RAC Database upgrade task in this chapter.
Chapter 14: RAC One Node by Syed Jaffar Hussain
RAC One Node (RON) as "the always-on single-server database" typically provides a traditionally cold failover solution. This chapter explained RON and covered deployment, management RON database. Also relocations RON database with Cloud Control 12c.
Expert Oracle RAC 12c is a hands-on book will help you understand and implement Oracle Real Application Clusters (RAC). I want thank to all authors for this book. I finished read this book, but I'll read this book again. I think this book must be read two or more time.
Mahir M. Quluzade
Oracle Certified Expert,
Oracle Real Application Clusters 11g and Grid Infrastructure