1 / 49

High Availability

High Availability. Group 08: Võ Đức Vĩnh 50703006 Nguyễn Quang Vũ 50703033. Contents. Overview of High Availability. 1. Đức Vĩnh. 2. Oracle High Availability Solutions. 3. High Availability Architectures. Quang Vũ. 4. Summarize, References, Q&A. High Availability ( cont ).

brie
Download Presentation

High Availability

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. High Availability Group 08: VõĐứcVĩnh 50703006 NguyễnQuangVũ 50703033

  2. Contents Overview of High Availability 1 Đức Vĩnh 2 Oracle High Availability Solutions 3 High Availability Architectures Quang Vũ 4 Summarize, References, Q&A

  3. High Availability (cont) Recoverability Reliability Timely and detection Continuous operations

  4. Causes of Downtime Planned Downtime Unplanned Downtime Computer failure System changes Storage failure Site failure Data changes. Human error Data corruption

  5. 1 Oracle HA Features. Oracle Database HA Solutions 2 Oracle HA Solutions for Planned Downtime Oracle HA Solutions for Unplanned Downtime 3 High Availability and Grid Computing. 4 5 High Availability Management. Oracle Database HA Solutions

  6. 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.

  7. 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.

  8. 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...

  9. Recovery Manager • To manage the backup, recovery of database. • It has also many benefits.

  10. Flash Recovery Area • Provides: • Unified storage location of related recovery files. • Management of the disk space allocated. • Fast, reliable disk-based backup and restoration.

  11. Oracle Security Features • Authentication control. • Access control. • Auditing control. • Security policy management using profiles. • Encryption, transferred data.

  12. Fast-Start Fault Recovery • Predictable, bounded recovery from computer failures. • Database checkpointing to maintain desired recovery time objective.

  13. 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.

  14. LogMiner (cont) Includes: 1. Pinpoint. 2. Determine the necessary actions. 3. Performance turning and capacity planning. 4. Perform post-auditing.

  15. Hardware Assisted Resilient Data Initiative

  16. HA Solution for Unplanned Downtime

  17. HA Solution for Unplanned Downtime

  18. HA Solution for Unplanned Downtime

  19. HA Solution for Unplanned Downtime

  20. HA Solution for Planned Downtime • System changes: - Dynamic Resource Provisioning. • Rolling Upgrades. • Data changes: • Online Reorganization and Redefinition.

  21. HA and Grid Computing

  22. 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.

  23. 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

  24. HA Architectures Oracle Database HA Architectures Choosing the correct High Availability Architecture www.themegallery.com

  25. 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

  26. 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

  27. 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

  28. Oracle Database 10g with RAC • Real Application Cluster • Multiple Oracle instances running on multiple computer • Cluster definition • Oracle Clusterware • Shared-everything database

  29. Oracle Database 10g with RAC

  30. 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

  31. 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

  32. 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

  33. Oracle Database 10g with Data Guard WAN Traffic manager Production Database Standby Database Synchronization Fix or maintenance

  34. 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

  35. Oracle Database 10g with Data Guard

  36. 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

  37. 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

  38. 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

  39. Maximum Availability Architecture

  40. 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

  41. 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

  42. 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.

  43. Oracle Database 10g with Streams

  44. 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

  45. 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

  46. Recovery Times for Unplanned Outages

  47. Recovery Times for Planned Outages

  48. 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. • […].

  49. Thank You !

More Related