high availability & oracle rac 18 aug 2005 john sheaffer platform solution specialist...
TRANSCRIPT
High Availability &Oracle RAC
18 Aug 2005
John Sheaffer
Platform Solution Specialist
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
Availability Defined
The degree to which an application or service is available when, and with the functionality, users expect.
HA Components
Application
Middleware & Utilities
Database Software
Networking Software
Operating System
Hardware
0.99
0.99
0.10
0.99
0.99
0.99====0.10
0.10
1.00
1.00
1.00
1.00
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
Hardware Failures– RAC, Data Guard
Software Failures– RAC, Data Guard
Corruption– Data Guard, RMAN
User Errors– Flashback Technology– Export/Import/Data
Pump– RMAN
Which technology to use?
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
WAN Traffic Manager
Dedicated Network
Primary Site Secondary Site
Data Guard- Flashback- RMAN- Grid Control
RAC RAC
10g AS 10g AS
- Flashback- RMAN- Grid Control
Q: What is RAC?
A: Oracle’s clustered database for real (i.e. everyday) applications
Oracle Oracle RACClustered it
becomes…
Database
Instance
Database
Instances
Database Cluster Types
Shared Everything– Shared Disk/Cache– Oracle and IBM Mainframes– More Reliable As You
Add Computers– No Data Partitioning Required
Shared Nothing– Private Disk/Cache– Microsoft and IBM Unix/NT– Less Reliable As You
Add Computers– Static Data Partitioning
DataDataA-ZA-Z
DataDataA-EA-E
DataDataF-KF-K
DataDataL-SL-S
DataDataT-ZT-Z
Server 1Server 1 Server 2Server 2 Server NServer N
• • •
ClusterWareClusterWare ClusterWareClusterWare ClusterWareClusterWare
Key Software Components
Server 3Server 3
ClusterWareClusterWare
OSOS OSOS OSOSOSOS
Raw / CFS / NAS / ASM
Oracle RACOracle RAC
Listener
Oracle RACOracle RAC
Listener
Oracle RACOracle RAC
Listener
Oracle RACOracle RAC
Listener
Clusterware Options
Linux– Oracle Clusterware
Windows– Oracle Clusterware
Solaris– Oracle Clusterware– Veritas SFOR– Sun Cluster– Fujitsu-Siemens
PrimeCluster
HP-UX– Oracle Clusterware– ServiceGuard
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
A B C D
1) Read block from disk 4) Write block to disk
2) Copy block acrossinterconnect
3) Update block across interconnect
Shared Cache
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)