High Availability

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 !