Book Review: Expert Oracle RAC 12c
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.
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.
I want share little
information about the authors:
Syed Jaffar Hussain has over 20 years I.T. experience that includes
more than 12 years of production Oracle database administration. Oracle
has honored him with the prestigious Oracle ACE Director role, and named him
DBA of the Year for 2011, both for his excellent knowledge and
contributions to the Oracle community. He is an Oracle Certified Master (OCM).
Syed Jaffar is coauthor of Oracle 11g R1/R2 Real Application Clusters
Essentials, and he blogs regularly at: http://jaffardba.blogspot.com
Tariq Farooq is an Oracle
Technologist/Architect/Problem-Solver and has been working with various Oracle
Technologies for 20+ years in very complex environments at some of the world's
largest organizations. He is the founding President of the IOUG Virtualization
& Cloud Computing Special Interest Group. He is an active Community
Leader/Organizer, Speaker, Author, Forum contributor, and Blogger. He is the
founder of www.brainSurface.com, a Social Networking & IT
Collaboration site for the various Oracle Communities with thousands of
signed-up users. Tariq is an Oracle RAC Certified Expert, holds a total of 14
professional Oracle Certifications and, is the author of 100+ articles,
whitepapers & other publications. Tariq has been awarded the Oracle ACE and
ACE Director awards from 2010 - 2013.
Riyaj Shamsudeen is an industry-recognized RAC expert and performance tuning
specialist with 19+ years of experience in implementing, using, and tuning RAC
and Oracle products. He is an Oracle ACE Director and proud member of the OakTable
network. Riyaj has co-authored many books about Oracle Database. He is an
active blogger (at http://orainternals.wordpress.com) and frequent
international speaker in major conferences such as UKOUG, HOTSOS, Open World,
and RMOUG.
Kai Yu is a Senior Principal Engineer and technologist in Dell’s Oracle Solutions Engineering Lab specializing in Oracle RAC, Oracle Virtualization, and Cloud. With 18+ years of experience working on Oracle technology, he has implemented and managed many large, mission-critical Oracle RAC databases, including those in his tenure with an IT organization having more than two thousand RAC databases. He has also keynoted at Oracle Architect Day. ... He was awarded the Oracle ACE Director title in 2010, given the Oracle ACE Spotlight in 2011 by Oracle Technology Network (OTN), and named the 2011 OAUG Innovator of Year Award by the Oracle Applications User Group (OAUG). In 2012, Oracle Magazine awarded him the Oracle Excellence Award: Technologist of the Year: Cloud Architect. Kai has been active in sharing his Oracle knowledge on his Oracle blog at http://kyuoracleblog.wordpress.com/.
Kai Yu is a Senior Principal Engineer and technologist in Dell’s Oracle Solutions Engineering Lab specializing in Oracle RAC, Oracle Virtualization, and Cloud. With 18+ years of experience working on Oracle technology, he has implemented and managed many large, mission-critical Oracle RAC databases, including those in his tenure with an IT organization having more than two thousand RAC databases. He has also keynoted at Oracle Architect Day. ... He was awarded the Oracle ACE Director title in 2010, given the Oracle ACE Spotlight in 2011 by Oracle Technology Network (OTN), and named the 2011 OAUG Innovator of Year Award by the Oracle Applications User Group (OAUG). In 2012, Oracle Magazine awarded him the Oracle Excellence Award: Technologist of the Year: Cloud Architect. Kai has been active in sharing his Oracle knowledge on his Oracle blog at http://kyuoracleblog.wordpress.com/.
Conclusion: 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.
p.s. I
want share links of this book with you, I bought this book from Amazon.
Regards
Mahir M. Quluzade
Oracle Certified Expert,
Oracle Real Application Clusters 11g and Grid Infrastructure
Mahir M. Quluzade
Oracle Certified Expert,
Oracle Real Application Clusters 11g and Grid Infrastructure
Comments
Post a Comment