Transcript PowerPoint Template

High Availability
Group 08:
Võ Đức Vĩnh
Nguyễn Quang Vũ
50703006
50703033
Contents
1
Overview of High Availability
Đức Vĩnh
2
Oracle High Availability Solutions
3
High Availability Architectures
Quang Vũ
4
Summarize, References, Q&A
High Availability (cont)
Recoverability
Reliability
Timely and detection
Continuous operations
Causes of Downtime
Planned Downtime
System
changes
Data
changes.
Unplanned Downtime
Computer
failure
Storage
failure
Human
error
Data
corruption
Site
failure
Oracle Database HA Solutions
1
Oracle
Database
HA
Solutions
Oracle HA Features.
2
3
4
5
Oracle HA Solutions for Planned Downtime
Oracle HA Solutions for Unplanned Downtime
High Availability and Grid Computing.
High Availability Management.
Oracle HA Features
 Oracle Real Application Clusters.
 Oracle Data Guard.
 Oracle Stream.
 Oracle Flashback Technology.
 Automatic Storage Management.
 Recovery Manager.
 Flash Recovery Area.
 Oracle Security Features.
 Fast-Start Fault Recovery.
 LogMiner.
 Hardware Assisted Resilient Data (HARD) Initiative.
Oracle Flashback Technology
Includes 4 features:
Oracle Flashback Query.
Oracle Flashback Versions Query.
Oracle Flashback Transaction Query.
Oracle Flashback Table.
Oracle Flashback Drop.
Oracle Flashback Database.
Oracle Flashback Restore Points.
Automatic Storage Management
Provides file system and volume manager
directly in the Oracle Kernel.
There are many advantages: mirror across
drives and storage array, auto re-mirror...
Recovery Manager
To manage the backup, recovery of database.
It has also many benefits.
Flash Recovery Area
Provides:
1. Unified storage location of related recovery files.
2. Management of the disk space allocated.
3. Fast, reliable disk-based backup and restoration.
Oracle Security Features
Authentication control.
Access control.
Auditing control.
Security policy management using profiles.
Encryption, transferred data.
Fast-Start Fault Recovery
Predictable, bounded recovery from computer
failures.
Database checkpointing to maintain desired
recovery time objective.
LogMiner
LogMiner is a tool related to SQL query, can
used to:
1. Track or audit changes to data.
2. Provide supplemental information for turning
and capacity planning.
3. Retrieve critical information for debugging
complex applications.
4. Recover deleted data.
LogMiner (cont)
Includes:
1. Pinpoint.
2. Determine the necessary actions.
3. Performance turning and capacity planning.
4. Perform post-auditing.
Hardware Assisted
Resilient Data Initiative
HA Solution for
Unplanned Downtime
HA Solution for
Unplanned Downtime
HA Solution for
Unplanned Downtime
HA Solution for
Unplanned Downtime
HA Solution for
Planned Downtime
System changes:
- Dynamic Resource Provisioning.
- Rolling Upgrades.
Data changes:
- Online Reorganization and Redefinition.
HA and Grid Computing
High Availability Management
Oracle Enterprise Manager Grid Control (OEMGC)
is a HTML-based user interface supporting the
administrator.
Includes:
- Oracle Management Service (OMS).
- Oracle Management Agents.
- Oracle Management Repository.
High Availability Management
Some advantages of OEMGC:
- Monitor components and be alerted.
- View overall system status.
- View alerts aggregated across all instances.
- Set thresholds for alert generation.
- Monitor performance metric.
- Perform database cluster-wide operations.
- Viewing hardware and operating system
information.
- Interconnect monitor
HA
Architectures
Oracle
Database HA
Architectures
Choosing the
correct High
Availability
Architecture
www.themegallery.com
Oracle Database High Availability
Architectures
Oracle Database 10g
Oracle Database 10g with RAC
Oracle Database 10g with Data Guard
Oracle Database 10g with RAC and Data Guard
MAA
Oracle Database 10g with Streams
Oracle Database 10g
Stand-alone database on single computer
Using non-architecture high availability features:






Oracle Flashback Technology
Automatic Storage Management
Fast-Start Fault Recovery
Recovery Manager
Flash Recovery Area
Online Reorganization and Redefinition
Oracle Database HA Architectures
Oracle Database 10g
Oracle Database 10g with RAC
Oracle Database 10g with Data Guard
Oracle Database 10g with RAC and Data Guard
MAA
Oracle Database 10g with Streams
Oracle Database 10g with RAC
Real Application Cluster
Multiple Oracle instances running on multiple
computer
Cluster definition
Oracle Clusterware
Shared-everything database
Oracle Database 10g with RAC
Oracle Database 10g
with RAC benefits
Fault tolerance: Fast node and instance failover
Planned node, instance switchover and switchback
Patch upgrades and Oracle Clusterware upgrades
Instance availability and scalability in multiple
nodes
Allows database restart or relocated in case of
failures
Oracle Database HA Architectures
Oracle Database 10g
Oracle Database 10g with RAC
Oracle Database 10g with Data Guard
Oracle Database 10g with RAC and Data Guard
MAA
Oracle Database 10g with Streams
Oracle Database 10g with Data Guard
Production (primary) database
Standby database: a copy of production
database
 Physical standby database
 Logical standby database
Switch role of databases in case of failure
Oracle Database 10g with Data Guard
WAN Traffic
manager
Production
Database
Synchronization
Fix or maintenance
Standby
Database
Oracle Database 10g with Data Guard
Datafiles
Oracle redo logs
Physical standby database:directly applies redo
to its datafiles
Logical standby database: convert DML and
DDL operations to SQL statements
Oracle Database 10g with Data Guard
Data Guard Benefits
Physical standby database






User errors and logical corruption
Disasters and site failures
Fast failover and switchover
Reporting and testing purposes
Backup from standby database
Read-only capability
Logical standby database:
 Read-only and read/write capability
 Enable upgrades
Oracle Database HA Architectures
Oracle Database 10g
Oracle Database 10g with RAC
Oracle Database 10g with Data Guard
Oracle Database 10g with RAC and Data Guard
MAA
Oracle Database 10g with Streams
Oracle Database 10g with RAC
and Data Guard (MAA)
Maximum Availability Architecture
Combination of RAC and Data Guard
Having 2 identical sites:
 Primary site contains the RAC primary database
 Secondary site contains the RAC primary
database
Maximum Availability Architecture
Oracle Database HA Architectures
Oracle Database 10g
Oracle Database 10g with RAC
Oracle Database 10g with Data Guard
Oracle Database 10g with RAC and Data Guard
MAA
Oracle Database 10g with Streams
Oracle Database 10g with Streams
Main usage: information sharing and distribution
Also provide highly available architecture
Bidirectional replication by messages:
 LCR (Logical change record)
 User-defined messages
Messages are stored and processed in queue
Oracle Database 10g with Streams
Manual configurations:
 Rules determining which message to capture
 Rules determining how messages are processed
 Routing of change records
Support heterogeneous platforms.
Oracle Database 10g with Streams
Choosing HA Architecture
Oracle Database 10g with RAC if:
 Maximum Recovery Time Objective (RTO) for
instance or node failure is in seconds or minutes
 Database scalability beyond one instance or node
is required
Oracle Database 10g with Data Guard if:
 Maximum RTO for instance or node failure is in
seconds to minutes or more
 Maximum RTO for data corruption or site failure
is less than 1 minute to five minutes
Choosing HA Architecture
MAA if:
 Projected planned maintenance is in hours or
less for each year
 Both RAC and Data Guard are required
Oracle Database 10g with Steams if
 Heterogeneous solution is required
Recovery Times for
Unplanned Outages
Recovery Times for
Planned Outages
References, Q&A
[1] Oracle Database High Availability Overview
10g release 2 (10.2) B14210-02.
[2] http://www.google.com
Key word: High Availability.
[…].