Jerry Held

1
(No Transcript)
2
Oracle Database 10gHigh AvailabilitySolutions
Ed MickaSenior Sales ConsultantPublic
SectorOracle Corporation
3
Oracle Handles Causes of Downtime
System Failure
Real Application Clusters Fast Restart
Data Failure Disaster
Recovery Manager Data Guard
Unplanned Downtime
Human Error
Flashback Log Miner, Data Guard
System Maintenance
Dynamic Reconfiguration Data Guard, RAC
Planned Downtime
Database Maintenance
Online Redefinition Partitioning, Parallel SQL
4
System Failure
System Failure
Power Outage System Crash
Unplanned Downtime
5
Single Instance Failure
Server presents a single point of failure
Server 1 Single Instance DB1
Database A
6
Oracle10g RAC - hot Failover
TAF Pre-connect
Server 1 Primary Instance DB1
Server 2 Secondary Instance DB3
Database A
Enhanced configuration of Oracle10g RAC for
availability
7
Oracle10g RAC - hot Failover
TAF continues queries
Server 2 Secondary Instance DB3
Database A
Fastest recovery from system faults in the
industry
8
Whats Good about RAC?

• Availability
• Scalability
• Performance
• Reduced Hardware Costs

9
RAC Availability
10
Shared Nothing Databases

• Maintenance problems
• Availability problems

Data A-E
Data F-K
Data L-S
Data T-Z
11
Shared Cache Databases

• Availability AND scalability
• Maintained like a single database

Data A-Z
12
RAC Scaleability
13
Oracle10g Database Clusters

• Start small, grow incrementally
• Scalable AND highly available
• NO downtime to add servers and disk

14
Scalability
100 190 270 360
15
RAC Performance
16
Real Applications Clusters - Cache Fusion
1. User1 queries data
2. User2 queries same data - via
interconnect with no disc I/O
3. User1 updates a row of data and
commits
4. User2 wants to update same block of data
10g keeps data concurrency via
interconnect
Fast!
17
RAC Reduced Hardware Costs
18
Pay-as-you-grow scalability

• Quantifying application workload

W o r k l o a d
300
200
100
19
Pay-as-you-grow scalability

• Workload growth

20
Pay-as-you-grow scalability

• Planning to handle workload

21
Pay-as-you-grow scalability

• Initial workload with RAC

22
Pay-as-you-grow scalability

• Scaling out with RAC

23
Pay-as-you-grow scalability

• Scaling again

24
RAC Demo
25
Data Failure and Disaster
System Failure
Power Outage System Crash
Data Failure Disaster
Data Corruption Flood, Fire, Etc.
Unplanned Downtime
26
Highest Data Protection Lowest Cost
Dramatic Advances in Ease of Use
Data Guard Site Failure Protection
Flash Recovery Area Corruption Protection
Flashback Human Error Protection
Combine the Features to Achieve Any Level of
Data Protection
ASM Mirroring Storage Failure Protection
27
Automatic Storage Management

• Database file system providing clustered volume
  management
• Integrated into the Oracle kernel
• Simplifies and automates disk management

28
ASM How it Works

• No volumes just a pool of storage
• Partitions total disk space into uniform sized
  megabyte units

Automatic Storage Management
29
ASM How it Works

• No volumes just a pool of storage
• Partitions total disk space into uniform sized
  megabyte units
• Efficient, online add/remove of disk with
  automatic rebalancing

Automatic Storage Management
30
ASM How it Works

• No volumes just a pool of storage
• Partitions total disk space into uniform sized
  megabyte units
• Efficient, online add/remove of disk with
  automatic rebalancing

Automatic Storage Management
31
Oracle10g Data Guard
Primary Server
Standby Server
Clients
Log Data
Production Database
Standby Database
Oracles primary solution for data protection
32
Oracle Data Guard Architecture
Physical Standby Database
Sync or Async Redo Shipping
Backup
Redo Apply
Optional Delay
33
Standby Databases Are Not Idle
Standby Server
Standby database can be used to offload the
primary database, increasing the ROI
34
Human Error
System Failure
Power Outage System Crash
Data Failure Disaster
Data Corruption Flood, Fire, Etc.
Unplanned Downtime
Human Error
Drop Tables Sys Admin Error
35
Human Error
Single Biggest Cause of Downtime

• Goal is to quickly analyze and repair
• For Localized damage
• Need surgical analysis and repair
• Example deleted wrong order
• For Widespread damage
• Need complete back-out to avoid long downtime
• Example batch job deletes this months orders

36
Flashback Time Navigation

• Flashback Query
• Query all data at point in time
• Flashback Versions Query
• See all versions of a row between two times
• See transactions that changed the row
• Flashback Transaction Query
• See all changes made by a transaction

Select from Emp AS OF 200 P.M. where
Tx 3
Select from Emp VERSIONS BETWEEN 200 PM and
300 PM where
Tx 2
Tx 1
Select from DBA_TRANSACTION_QUERY where xid
000200030000002D
37
Flashback Database

• A new strategy for point in time recovery
• Flashback Log captures old versions of changed
  blocks
• Think of it as a continuous backup
• Replay log to restore DB to time
• Restores just changed blocks
• Its fast - recover in minutes, not hours
• Its easy - single command restore
• Flashback Database to 205 PM

Rewind button for the Database
38
Flashback Database versus Classic Point-In-Time
RecoveryRecovery is 100 times faster with
Flashback
39
Flashback Error Correction

• Recovery at all levels
• Database Level
• Flashback Database restores the whole database to
  time
• Uses Flashback Logs
• Table Level
• Flashback Table restores rows in a set of tables
  to time
• Uses UNDO in database
• Flashback Drop restores a dropped table or a
  index
• Recycle bin for DROPs
• Row Level
• Restore individual rows
• Uses Flashback Query

Database
Customer
Order
40
Flashback for All Users

• END USER
• Flashback Query
• Flashback Row History

• DEVELOPER
• Flashback Row History
• Flashback Transaction History
• Flashback Table

• DATABASE ADMIN
• Flashback Database
• Flashback Drop

• SYSTEM ADMIN
• Data Guard

41
FlashbackDemo
42
System Maintenance
System Failure
Power Outage System Crash
Data Failure Disaster
Data Corruption Flood, Fire, Etc.
Unplanned Downtime
Human Error
Drop Tables Sys Admin Error
System Maintenance
O/S Upgrades
Planned Downtime
Hardware Upgrades
Hardware Maintenance
43
Rolling Patch Upgrade using RAC
Oracle Patch Upgrades
Operating System Upgrades
Hardware Upgrades
44
Rolling Release Upgrade using Data Guard
Patch Set Upgrades
Major Release Upgrades
Cluster Software Hardware Upgrades
45
Summary Oracle10g architected for Continuous
Data Availability
System Failure
Real Application Clusters Fast Restart, Data Guard
Data Failure Disaster
Recovery Manager Data Guard
Unplanned Downtime
Human Error
Flashback Log Miner, Data Guard
System Maintenance
Partitioning, Data Guard Dynamic Reconfiguration
Planned Downtime
Database Maintenance
Online Redefinition Data Guard
46
(No Transcript)