Data Guard Technology Overview

1
High Availability Oracle RAC 18 Aug 2005
John Sheaffer Platform Solution
Specialist john.sheaffer_at_oracle.com
2
Agenda

• Session 1 (1100 - 1200)
• HA Defined
• MAA Defined
• Oracle RAC Overview
• Session 2 (100 - 200)
• CRS Overview
• RAC Demonstration
• QA

3
High Availability Defined
4
Availability Defined

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

5
HA Components
6
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

7
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

8
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

9
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

10
Which technology to use?

• Hardware Failures
• RAC, Data Guard
• Software Failures
• RAC, Data Guard
• Corruption
• Data Guard, RMAN

• User Errors
• Flashback Technology
• Export/Import/Data Pump
• RMAN

11
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

12
Maximum Availability Architecture
10g AS
10g AS
WAN Traffic Manager
RAC
RAC
Data Guard

• - Flashback
• - RMAN
• Grid Control

• - Flashback
• - RMAN
• Grid Control

Primary Site
Secondary Site
13
OracleReal Application Clusters
14
Q What is RAC?
A Oracles clustered database for real (i.e.
everyday) applications
15
What RAC provides

• Increased Availability
• A server failure does not interrupt surviving
  nodes
• Increased Scalability
• Scale outside the box
• Increased Flexibility
• Grow as your demand grows
• Reduced Cost
• No idle servers better server utilization
• Leverage cost savings of smaller servers
• Lower initial cost
• Lower support cost
• Consolidation

16
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

17
Key Hardware Components
WAN

18
Key Software Components
Server 1
Server 3
Server 2
Server N

ClusterWare
ClusterWare
ClusterWare
ClusterWare
OS
OS
OS
OS
Raw / CFS / NAS / ASM
19
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

20
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

21
Oracles Cache Fusion
A
B
C
D
Shared Cache
22
How do you use a DB cluster?
23
Using RAC Different Ways
App A
24
Using RAC Different Ways
App A
App A
App A
25
Using RAC Different Ways
App A
App B
App C
26
Using RAC Different Ways
App A
App B
App C
27
Using RAC Different Ways
App A
App B
App C
28
Using RAC Different Ways
App A
App B
App C
29
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)

30
Thank You

• john.sheaffer_at_oracle.com