High Availability Oracle RAC 18 Aug 2005 John

High Availability & Oracle RAC 18 Aug 2005 John Sheaffer Platform Solution Specialist john. sheaffer@oracle. com

Agenda Ÿ Session 1 (11: 00 - 12: 00) – – – HA Defined MAA Defined Oracle RAC Overview Ÿ Session 2 (1: 00 - 2: 00) – – – CRS Overview RAC Demonstration Q&A

High Availability Defined

Availability Defined The degree to which an application or service is available when, and with the functionality, users expect.

HA Components 0. 99 Application 0. 10 0. 99 Middleware & Utilities 1. 00 0. 10 Database Software 1. 00 0. 99 Networking Software 1. 00 0. 99 Operating System 1. 00 0. 99 ==== 0. 10 Hardware 1. 00 ==== 0. 10

Key HA Questions Ÿ What is the cost of downtime? Ÿ What data needs to be protected? Ÿ What disasters/downtimes should you protect against? Ÿ What is your Recovery Time Objective (RTO)? – Max time system may be unavailable Ÿ What is your Recovery Point Objective (RPO)? – Max data that may be lost

Sources of Outages Ÿ Hardware Failures – – – Server failures Network failures Storage failures Ÿ Software Failures – – – Database Instance Crash (ORA-00600, -7445) O/S crash (kernel panic, BSOD) Database, O/S, Driver hangs

Sources of Outages Ÿ Corruptions – – – File system corruptions (O/S or FS driver bug) HBA failure (lost or corrupt writes) Disk media failure Ÿ User Errors – – – Full table updates/deletes (no WHERE clause) Dropped tables Updates/Inserts with bad data

Sources of Outages Ÿ Regional Disasters – – – Typhoon, flooding, earthquake, volcano Damaged to Data Center building Loss of Network or Power Ÿ Planned Maintenance – – – Reorganizing tables, rebuilding indexes Firmware, O/S, or Database patches Proactive hardware upgrade / replacement

Which technology to use? Ÿ Hardware Failures – RAC, Data Guard Ÿ User Errors – – Ÿ Software Failures – RAC, Data Guard Ÿ Corruption – Data Guard, RMAN – Flashback Technology Export/Import/Data Pump RMAN

Which technology to use? Ÿ Regional Disasters – Data Guard, RMAN Ÿ Planned Maintenance – – – RAC, Data Guard – Rolling Upgrades Online Reorganization, Online Redefinition Grid Control - Monitoring and proactive maintenance

Maximum Availability Architecture 10 g AS WAN Traffic Manager RAC Dedicated Network - Flashback - RMAN - Grid Control Primary Site Data Guard RAC - Flashback - RMAN - Grid Control Secondary Site

Oracle Real Application Clusters

Q: What is RAC? A: Oracle’s clustered database for real (i. e. everyday) applications Oracle Instance Database Clustered it becomes… Oracle RAC Instances Database

Database Cluster Types Ÿ Shared Everything – – Ÿ Shared Nothing Shared Disk/Cache Oracle and IBM Mainframes More Reliable As You Add Computers No Data Partitioning Required Data A-Z – – Data A-E Private Disk/Cache Microsoft and IBM Unix/NT Less Reliable As You Add Computers Static Data Partitioning Data F-K Data L-S Data T-Z

Key Hardware Components WAN • • • Shared Storag e High-Speed Cluster Interconnect

Key Software Components Server 1 Server 2 Server 3 Server N Listener Oracle RAC Cluster. Ware OS OS Raw / CFS / NAS / ASM Listener • • • Oracle RAC

Clusterware Options Ÿ Linux – Oracle Clusterware Ÿ Windows – Oracle Clusterware Ÿ Solaris – – Oracle Clusterware Veritas SFOR Sun Cluster Fujitsu-Siemens Prime. Cluster Ÿ HP-UX – – Oracle Clusterware Service. Guard Ÿ AIX – – – Oracle Clusterware HACMP Veritas SFOR

Storage Options Ÿ Raw Files – All platforms Ÿ Clustered File System – – Windows & Linux - OCFS Solaris & AIX – Veritas CFS Ÿ Automatic Storage Management (ASM) – All platforms Ÿ NAS (via NFS) – Linux & Solaris

Oracle’s Cache Fusion 3) Update block across interconnect 2) Copy block across interconnect A B C Shared Cache 1) Read block from disk D 4) Write block to disk

How do you use a DB cluster?

Using RAC – Different Ways App A

Using RAC – Different Ways App A App B App C

Oracle RAC Deployment Ÿ 5, 253 distinct customers Ÿ 272 production customer references Ÿ 56 countries w/ production customers Ÿ 16% of new DB customers are RAC customers (As of 17 Aug 2005)

Thank You john. sheaffer@oracle. com