1 / 8

Oracle Database High Availability

Oracle Database High Availability. Brandon Kuschel Jian Liu Source: Oracle Database 11g Release 2 High Availability An Oracle White Paper November 2010 http://www.oracle.com/technetwork/database/features/availability/twp-databaseha-11gr2-1-132255.pdf. Overview.

deepak
Download Presentation

Oracle Database 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. Oracle DatabaseHigh Availability Brandon Kuschel Jian Liu Source: Oracle Database 11g Release 2 High Availability An Oracle White Paper November 2010 http://www.oracle.com/technetwork/database/features/availability/twp-databaseha-11gr2-1-132255.pdf

  2. Overview

  3. Oracle Database's HA Solution Set

  4. Human Error Protection • Example: Bug in SQL statement • Isolation: Preventing errors via access control • Faster recovery with Flashback technologies • Undo: Query • Undo: Versions Query: SELECT * FROM emp VERSIONS BETWEEN TIMESTAMP time1 AND time2 WHERE… • Transaction Query: SELECT * FROM FLASHBACK_TRANSACTION_QUERY WHERE XID = transactionID • Undo Transaction - Atomicity • Full Table • Undo Drop • Entire Database

  5. Data Corruption Protection • Ex: Fault during single read/write operation • Two-Phase Commit • Prepare: Write to log and lock table • Commit: Write to disk if ready then log as committed • Prevent corruption by setting parameters • Wide range of backup options • RMAN (Oracle Recovery Manager) • Configure backup and recovery policy • Verify backups aren't corrupt • Fast recovery backup • Stored on disk onsite - secondary storage • Only the newest files are stored here • Tertiary (remote) backup • Backups are copied to tape or uploaded to Amazon S3 • Data Recovery Advisor • Identifies the available recovery options

  6. Storage Failure Protection Ex: Disk drive crash ASM (Automatic Storage Management) • Database-specific RAID • Block Repair • Automatically: relocate valid blocks from the mirrored copy • Manually: relocate specific blocks • Rolling Upgrades • Keeping application online while upgrading ASM • ACFS and ADVM • ASM Cluster File System • Extends ASM functionality to support all non-Oracle database files • ASM Dynamic Volume Manager • Provides a general purpose volume management platform for 3rd party file system

  7. Site Protection • Ex: fire, storm, power outage • Oracle Data Guard options: • Standby database up-to-date • Standby database is a snapshot • Use standby to perform planned • maintenance in a rolling fashion • Oracle GoldenGate – Distributed databases • All databases are active for reading/writing • Oracle Streams Standby database options Structure of distributed database

  8. References Oracle Database 11g Release 2 High Availability: http://www.oracle.com/technetwork/database/features/availability/twp-databaseha-11gr2-1-132255.pdf Using Oracle Flashback Transaction Query http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_flashback.htm#ADFNS01005 Oracle Recovery Manager http://www.oracle.com/technetwork/database/features/availability/rman-overview-096633.html Oracle Secure Backup http://www.oracle.com/technetwork/products/secure-backup/overview/index.html ASM in Oracle Database 10g http://www.oracle-base.com/articles/10g/automatic-storage-management-10g.php Oracle Data Guard 11g http://www.oracle.com/technetwork/database/features/availability/twp-dataguard-11gr2-1-131981.pdf Oracle GoldenGate 11g http://www.oracle.com/us/products/middleware/data-integration/goldengate11g-ds-168062.pdf?ssSourceSiteId=otnen Two-Phase Commit Mechanism http://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_txns003.htm

More Related