Oracle Real Application Cluster (RAC)

Oracle Real Application Cluster (RAC)

Oracle Clustering Overview
Our Oracle RAC courses will help you become a seasoned Oracle Clustering DBA (Oracle RAC Expert). Our oracle RAC courses are intended for students wishing to upgrade or acquire new skills in the fields of cluster administration, real application cluster design, and database management systems. These courses of study include a strong foundation and skill in oracle real application cluster administration up to the industry standards. BCC’s certification and training courses in “Oracle Cluster Administration” includes the coursework for the exams one needs to take for the Hands-on Cluster Technology (Oracle RAC Expert) Oracle Cluster Administrator credential. Our oracle courses are lead by instructors who have undergone rigorous Oracle training themselves and have years of experience working and consulting in various corporations in London, UK.

Oracle Real Application Cluster (RAC)
Course Contents

Course Overview:
Introduction to Oracle Real Application Cluster (RAC)
Oracle Real Application Clusters (RAC) Concepts
Benefits of Real Application Clusters(RAC)

Oracle Real Application Cluster (RAC) Architecture
Oracle Cluster architecture: nodes, interconnect, shared disks
Oracle Real Application Clusters architecture
Shared files
Global Resource Directory
Services and background processes
Global Enqueue Service
Enqueue Resources
Global Cache Service

Oracle Cluster Management and Configuration Tools
Installation Issues
Configuration Issues
Upgrade Issues
Modifying a single-instance database to support multiple instances
SRVCTL Commands
OEM Interface
Parameter Files and Shared Parameter Files (SPFILE)
Cache Fusion

High Availability Considerations for Oracle Clustering (RAC)
High Availability Features
Fast Problem Detection and Instance Reconfiguration
Fast Real Application Clusters Reconfiguration
Dynamic Resource Remastering
Dynamic Resource Remastering: Example
Instance Transition and Recovery Domains
Global Resource Directory Reconfiguration and Cache Recovery
Overview of Fusion Resource States

Online Transaction Processing Considerations for Oracle RAC
Tablespace Management
Dictionary Management and Mapping Extents to Instances
Local Management and Automatic Extent Management
Segment Free Space Management
Free Lists and Free List Groups
Automatic Segment Free Space Management

Online Analytical Processing, DSS, and Data for Oracle RAC
Warehousing Considerations
Temporary Tablespaces
Intra- and Inter- Instance Parallelism
Performing Data Extract, Load, and Transformation

Oracle RAC Scalability Considerations
Speedup and Scaleup
Automatic Resource Remastering
Load Balancing

Backup and Recovery
Archiving in a Real Application Clusters Database
Archive Log File Destinations
Recovery Manager
Operating System Backup and Recovery Issues

Oracle Cluster(RAC) Monitoring and Tuning
Collecting Performance Statistics
Evaluating Performance Statistics
Dynamic Performance Tables
Statspack
OEM
Tuning Strategy