Oracle RAC (Real Application Cluster)
In database computing, Oracle Real Application Clusters — an option for the Oracle Database software produced by Oracle Corporation and introduced in 2001 with Oracle9i — provides software for clustering and high availability in Oracle database environments.
Instructor: Tom Steven
- Lectures: 11
- Duration: 10 weeks
We have specialized Oracle trainers who are also working on real-time projects. In addition, course certificates and project certificates will be provided at the end of the course. We also have an association with major multinational companies and agents to place our candidates.
You can use Oracle Real Application Clusters (RACs) to cluster databases from different servers. This improves storage and provides high scalability, availability, and manageability. Students will learn how to install and manage Oracle Real Time Application Clusters and Automatic
The Dynamic Business Environment The Explosive Growth of Business Data
Online and Real-Time Access to Corporate Data Data Warehousing, Packaged Applications, E-Commerce Operations Dependence on Database Management Systems High Performance Systems Introduction to Cluster Technology Introduction to Cluster Technology Benefits of Real Application Clusters (RAC)
What is a DB Cluster? Architectures of DB Clusters What is a Cluster Interconnect? Problems with Other Architectures
The IBM Shared-Nothing Configuration Problems with Other Architectures
The IBM Shared-Nothing Configuration Microsoft Federated Servers Database Seeing the High Availability Spectrum Seeing the High Availability Spectrum Real Application Clusters
Processing Prior to Cache Fusion Oracle Real Application Clusters
Attributes of an Oracle RAC Cluster Oracle Real Application Clusters
Attributes of an Oracle RAC Cluster Building an Oracle RAC Cluster RAC Performance and Scalability RAC Performance and Scalability Growth of Powerful Processors Why Parallel Processing? Opportunities for Parallelism Scalability Parallel Databases
Types of Parallelism High Performance Computing Cluster – HPCC High Performance Computing Cluster – HPCC Clusterize Applications
How Do You Clusterize Applications? Highly Available Databases
Need for Highly Available Data Highly Available Databases
Need for Highly Available Data Failure Availability Reliability and Serviceability Fault-tolerant Systems Database Availability Clustered Systems Clustered Systems Databases Issues Oracle RAC – High Performance and Highly Available Database Oracle RAC – High Performance and Highly Available Database Overview of the Cluster Technology
How Clusters Differ from Distributed Systems Clusters are Different from Fault-tolerant Systems Database Clusters Why Clusters? Types of Clusters
Failover Clusters Types of Clusters
Failover Clusters Scalable High Performance Clusters Application Server Clusters Other Types of Clusters Components of a Cluster
Cluster Nodes Components of a Cluster
Cluster Nodes Emerging Server Cluster Architectures Cluster Interconnect Essentials for Parallel Database Clusters Cluster Interconnect Products Infiniband Interconnect ClusterWare Concurrent Database Access Failover Database Clusters
Resources, Resource Type Failover Database Clusters
Resources, Resource Type Resource Groups The Concept of a Virtual Server Failover Process Examples Failover Cluster Architecture Oracle Database Service in HA Cluster Issues with FO Clusters – Hidden Risks Parallel Database Clusters
Shared-Nothing Model Parallel Database Clusters
Shared-Nothing Model Shared-Disk Model Microsoft SQL Server Federated Database IBM Offerings Requirements for Parallel Clusters Oracle’s Instance Membership Recovery Cache Coherency and Lock Management Cache Coherency and Lock Management Overview of Oracle Real Application Clusters
RMAN for RAC RAC Workload Management RAC Scalability High Availability Architecture
Oracle11g Basic Processes Architecture
Oracle11g Basic Processes Oracle11g Basic Internal Structures Oracle11g RAC Additional Processes Oracle11g RAC Additional SGA Areas RAC Server Components
GCS Resource Modes and Roles RAC Server Components
GCS Resource Modes and Roles Accessing RAC Accessing RAC Overview Oracle11g RAC Disk System Understanding Disks, LUNs, Volumes
Raw Volumes File Systems Storage Technology and Redundancy
Disk Systems Storage Technology and Redundancy
Disk Systems Understanding I/O Path Host Bus Adapters (HBA) Storage Redundancy Components RAID and RAID Administration High Availability of Storage Logical Volume Managers Storage Areas
OCFS/OCFS2 Storage Areas
OCFS/OCFS2 RAW Volumes ASM Other CFS Solutions Redundancy
Understanding RAID Redundancy Redundancy
Understanding RAID Redundancy Capabilities
Server Redundancy Capabilities
Server Redundancy Redundancy Types Redundancy Types Architecture and Components
Servers and Operating System Cluster Interconnect and Public Switch Oracle Clusterware Shared Storage Subsystem Overview of Installation Steps
Installation of Oracle Clusterware Overview of Installation Steps
Installation of Oracle Clusterware Installation of Oracle for use with ASM Installation of Oracle for production database use Oracle RAC Tools
crs_stat Oracle RAC Tools
crs_stat olsnodes srvctl dbca netca netca Overview of Cache Fusion
Evolution of Cache Fusion Nature of Cache Fusion Benefits of Cache Fusion Concurrency and Consistency Cache Coherency Global Cache Service SGA Components and Locking
SGA – System Global Area SGA Components and Locking
SGA – System Global Area Program Global Area (PGA) Buffer Cache Management What is a Dirty Block? Multi – Version Consistency Model RAC Components
Global Cache Service RAC Components
Global Cache Service Global Enqueque Service Row-Level Locks Global Resource Directory RAC Processes Resource Coordination
Synchronization Resource Coordination
Synchronization GCS Resource Modes and Roles Concept of Past Image Lock Modes Block Access Modes and Buffer States Cache Fusion Scenarios Block transfers using Cache Fusion – Examples Block Access, Grants, and Interrupts Cache Fusion and Recovery
Recovery Features Cache Fusion and Recovery
Recovery Features Recovery Methodology and Steps Recovery Process – Re-mastering Resources Recovery Process – Re-mastering Resources Parameter Management
Overview RAC and Initialization Parameters UNDO Management
UNDO Management in RAC UNDO Management
UNDO Management in RAC UNDO Tablespace Features System Rollback Segment Concept of Thread
Thread Features Concept of Thread
Thread Features Redo Thread Maintenance Segment Space Management
Automatic Segment Space Management Segment Space Management
Automatic Segment Space Management Manual Space Management Oracle Managed Files Using SQL*Plus
Starting the Database in Cluster Mode Using SQL*Plus
Starting the Database in Cluster Mode Using Oracle DB Control for Clusters
Configuration of DB control w/RAC Using Oracle DB Control for Clusters
Configuration of DB control w/RAC Using Oracle DB Control for Clusters
Configuration of DB control w/RAC Overview of RAC backup and Recovery
Export Cold Backup using Scripts Hot Backups using Scripts RMAN (Recovery Manager) Third Party Solutions Backup of RAC Database
Using RMAN for Backups Backup of RAC Database
Using RMAN for Backups Backup Procedures RMAN and RAC Recovery in the RAC Environment
Media Recovery in RAC Instances Recovery in the RAC Environment
Media Recovery in RAC Instances Using RMAN to Recover a RAC Environment Recovery in an OCFS Environment Recovery in a Raw File System Environment Parallel Recovery Standby Databases in RAC Configuration
Setting up a Standby Database for a RAC Cluster to a Single-Instance (One Node) Standby Databases in RAC Configuration
Setting up a Standby Database for a RAC Cluster to a Single-Instance (One Node) Configuration when the Standby Database is a Single Node System Cross-Instance Archival Archive Log Gap Resolution and FAL ASM and RMAN
Performing advanced backup/ recovery techniques with ASM ASM and RMAN
Performing advanced backup/ recovery techniques with ASM SWITCH DATABASE TO COPY Keeping ASM Clean Keeping ASM Clean Services In-depth
Failover Load Balancing Planning and Configuration Connection Pools and Services Connection Pools and Services The Load Balancing Advisory Monitoring Services Monitoring Services Analysis of Performance Issues
Monitoring RAC Cluster Interconnect Using performance views Using AWR ADDM for RAC Using DB Control to Monitor RAC Using DB Control to Monitor RAC Using DB Control to Monitor RAC Designing equipment for RAC
Effects of component failure Redundancy at every level Choosing Service/Nodes for Work Sequences in RAC
Tablespace Design Considerations Sequences in RAC
Tablespace Design Considerations Solid State Disk Considerations Table Locks and Latch Waits Scalability and Unpredictable Loads Scalability and Unpredictable Loads Overview Migration Methodology
Moving from Single Instance to RAC Cloning Overview Migrating to Oracle 11g Rolling Upgrades Rolling Upgrades Oracle 11g RAC has a rolling upgrade features whereby RAC database can be upgraded without any downtime. Oracle 11g RAC has a rolling upgrade features whereby RAC database can be upgraded without any downtime. Oracle 11g RAC has the ability to apply patches on a node-by-node basis without service interruption. Oracle 11g RAC has the ability to apply patches on a node-by-node basis without service interruption. Starting in 10gr2 we see a RAC load balancing advisorutility. Oracle says that the 11g RAC load balancing advisor is only available with clients which use .NET, ODBC, or the Oracle Call Interface (OCI). Starting in 10gr2 we see a RAC load balancing advisorutility. Oracle says that the 11g RAC load balancing advisor is only available with clients which use .NET, ODBC, or the Oracle Call Interface (OCI). In Oracle 11g, ADDM has been extended to include RAC, and provides information on the entire cluster including latency issues on the cluster interconnect, global cache hot blocks (blocks with concurrency issues across multiple nodes), and general object usage information across multiple nodes. In Oracle 11g, ADDM has been extended to include RAC, and provides information on the entire cluster including latency issues on the cluster interconnect, global cache hot blocks (blocks with concurrency issues across multiple nodes), and general object usage information across multiple nodes. 11g RAC improves the cache fusion layer for faster and more efficient pinging between nodes 11g RAC ASMCA Oracle 11g offers an ASM configuration assistant allows you to install cluster file systems (ACFS), ASM instances, ASM volumes and disk groups. Oracle 11g offers an ASM configuration assistant allows you to install cluster file systems (ACFS), ASM instances, ASM volumes and disk groups. Extends the general cache fusion protocols in 10g to deal with specific scenarios where the protocols could be further optimized. Extends the general cache fusion protocols in 10g to deal with specific scenarios where the protocols could be further optimized. Content