Oracle RAC

posted Feb 24, 2011, 7:19 AM by Sachchida Ojha

Failover Cluster

? Detecting failure by monitoring the heartbeat and checking status of resources
? Reorganizing Cluster membership in the cluster manager
? Transferring Disk ownership from primary node to secondary node
? Mounting theFS on secondary node
? Starting DB instance
? Recovering the Database and rollback of uncommitted data
? Reestablishing the client connections to the failover node

FAILOVER CLUSTER OFFERINGS

? Veritas cluster server
? HP Service Guard
? Microsoft Cluster Service with OracleFailsafe
? RedHat Linux Advanced Server 2.1
? Sun Cluster Oracle Agent
? Compaq, now HP, Segregated Cluster
? HACMP

RAC ScalableRAC Real Application Cluster

? Many instances of Oracle running on many nodes
? Multiple instances share a single physical database
? All instances have common data, control, and initialization files
? Each instances has individual, shared log files and rollback segments or undo tablespaces
? All instances can simultaneously execute transactions against the single database
? Caches are synchronized using Oracle¶s Global Cache Management technology (CacheFusion)

RAC Building Blocks

? Instance and Database files
? Shared storage with OCFS, CFS or raw devices
? Redundant HBA cards per HOST
? Redundant NIC cards per HOST, one for cluster interconnect and one for LAN connectivity
? Local RAID protected drives for ORACLE_HOMES ( OCFS does not support ORACLE_HOME install)

CLUSTERINTER CONNECT FUNCTION

? - Monitoring Health, status and message synchronization
? - Transporting Distributed Lock manager messages
? - Accessing remoteFile system
? - Moving application specific traffic
? - providing cluster alias routing Interconnect Requirements
? - Low latency for short messages
? - High speed and sustained data rates for large messages
? - LOW Host CPU utilization
? -Flow Control, Error Control and heart beat continuity monitoring
? - switched network that scale well

INTERCONNECT PRODUCTS

? Memory Channel
? SMP Bus
? Myrinet
? Sun SCI
? Gigabit Ethernet
? Infiband Interconnect

INTERCONNECT PROTOCOL
? TCP/IP
? UDP
? VIA
? RDG
? HMP
Comments