1 / 23

VERITAS Database Edition for Oracle on HP-UX - Improve Performance, Manage Data Efficiently

Increase availability & performance of Oracle databases on HP-UX with VERITAS Database Edition. Learn how to optimize storage, boost speed, and enhance data management.

shawnnas
Download Presentation

VERITAS Database Edition for Oracle on HP-UX - Improve Performance, Manage Data Efficiently

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. Selling the Database Editionfor Oracle on HP-UX November 2000

  2. The NeedKey Customer Concerns • Continuous availability (24x7) of mission-critical Oracle databases • How much does downtime cost your business in regard to lost user productivity, reduced company revenue, poor customer service? • Faster access to data • Are you using file systems or raw disk partitions to Oracle data? • Easier management of increasing data • Do your DBAs have to learn how to manage raw disk partitions to gain database performance?

  3. Building the Solution • What is the customer using, and how does this product fit into their installation? • HP-UX 11.0 • New Installations • Upgrading OS • Oracle7.3 or later (inclusive of Oracle8i) • Upgrading database or • Database can withstand some downtime

  4. VERITAS Database Edition 2.1.1 • Integration of online and offline storage management for HP environments Oracle Database Edition for Oracle VxDBA Utility Building Blocks Storage Checkpoints & Quick I/O OnlineJFS File System (fulfilled by HP) VERITAS Volume Manager

  5. Product Positioning • For DBAs facing immense time pressure in an environment with ever-increasing data, VERITAS Database Edition for Oracle offers raw device performance with file system manageability. • Increases availability of Oracle databases • Offers equal to raw device performance • Offers ease of management of file systems • Virtually eliminates database backup window • Speeds database recovery

  6. Raw Devices HFS/JFS Database Edition for OracleProduct Positioning Database Editionfor Oracle Performance Manageability

  7. Feature Overview • Quick I/O • Raw device performance with file system manageability • Up to 200% performance improvement over traditional buffered file system • Cached Quick I/O not available • Protection from disk failures with fault-tolerant storage options • Online administration of database storage

  8. Feature Overview • Storage Checkpoints • Enables Block-Level Incremental Backup • Enables Storage Rollback for immediate “point-in-time” recovery from on-disk images • VxDBA utility • Manages Storage Checkpoints and Storage Rollback and monitors file system space • Java-based Storage Administrator GUI • Visual configuration from a single console

  9. Building Oracle Databases onRaw Disks vs. File Systems • Unique, total storage foundation solution to deliver the best of both worlds Database Editionfor Oracle Raw Disks Conventional File Systems Advantages Disadvantages Advantages Disadvantages • Manageability • Tablespace • organization • System-wide • backup and • restore • policies • Easy to create • and expand • files for Oracle • Manageability • “Invisible” • locations for • tablespaces • Difficult to • grow • tablespaces • Performance • Lower database • throughput • (30-90% of • raw disk) • Higher CPU • overhead • Data Reliability • Potential data loss • Performance • Best OLTP performance • Data • Reliability • No potential for data loss with data written to • disks directly

  10. Quick I/O raw device regular file Raw Device PerformanceQuick I/O for Databases • Breakthrough VERITAS File System interface technology • Presents regular VERITAS File System files to Oracle as raw character devices • Allows parallel updates to database files for increased throughput • Takes advantage of asynchronous I/O • Oracle handles locking for data integrity • HP’s Online JFS File System is a OEM version of VERITAS File System RDBMS Server

  11. Quick I/O PerformanceComparison to Raw I/O • Database Edition has equal to raw performance • Up to 200% performance improvement over traditional file systems • Tested configurationincluded: • HP N (4 CPUs and 1 GB of RAM) • HP-UX 11.0 (64-bit) • Database Edition 2.1 for Oracle • Oracle 8.0.5 (64-bit) • TPC-C scale factor of 100 warehouses

  12. Key Differentiator:VERITAS Storage Checkpoints • Point-in-time snapshot of database • Storage Checkpoints maintain changed data blocks as database is being updated • Uses efficient copy-on-write technique • No post-processing needed to scan forchanged data blocks

  13. Uses of Storage Checkpoints • Storage Rollback: • VxDBA utility manages Storage Checkpoints for faster database recoverability from on-disk backup image • Protects from logical errors • What-if analysis • Block-Level Incremental Backup: • NetBackup manages Storage Checkpoints and extracts only the changed blocks • Virtually eliminates database backup window

  14. Storage Rollback • Storage Checkpoints are on-disk backup images • Consistent, stable images of a file system at a particular point in time • Storage Rollback is “restore” from the on-disk backup images or Storage Checkpoints • Copies before-images of data blocks back to the live file system • Restores without going to tapes

  15. Storage Rollback Rollback from Storage Checkpoints = Simply write back changed (blue) blocks to previous state and then apply redo logs to bring database to desired point in time Managed by VxDBA utility

  16. Block-Level Incremental Backup NetBackup Server Changed BlocksSince LastBackup VERITAS File System with Storage Checkpoints NetBackup BLI BackupExtension Minimize Your Database Backup Window BlockLevelIncrementals PreviousFull Backup FullRestore +

  17. Database Edition:Block-Level Incremental Backups • Back up only changed data blocks! • Higher data availability • Virtually eliminates backup windows • Allows more frequent backup schedules • Backups contain up-to-date data • Enhanced performance • Significantly lowers CPU and network resource drain during backups • Faster recovery from backups (less redo logs to apply) • Requires NetBackup Server engine and database server to be a NetBackup client

  18. VERITAS Storage Administrator • Visual configuration management and performance analysis • Allows one-step graphical execution of common configuration management steps

  19. Product Description • Hosts Supported • HP-UX 11.0 • MC/ServiceGuard not supported • System Requirements • Oracle7.3 to 8i ORACLE VALIDATED • Physical Packaging • Enables the license key for OnlineJFS File System • VERITAS Quick I/O • VERITAS Volume Manager • VxDBA utility to manage Storage Checkpoints and Storage Rollback

  20. Product Description (cont.) • Educational Packages • Database Edition for Oracle class now available though Solaris specific • Consulting Packages • Any standard package if necessary • Support Packages • Direct Assist Support (5x12) • Premier Direct Assist Support (7x24)

  21. Features & Benefits • Quick I/O • Equal to raw performance with file system manageability • Online database administrationReduces production database downtime • Block-Level Incremental Backup Support Minimizes database backup window • Storage Checkpoint & RollbackFaster database recoverability • Automated file system growthProactive system administration

  22. When Selling on HP-UX • Up to 200% performance increase over running Oracle on traditional buffered file system • Enables HP OnlineJFS File System that is an OEM version of VERITAS File System • Storage Edition assumes LVM running underneath; Database Edition runs on VxVM • Storage Edition supports MC/ServiceGuard; • Database Edition does not

  23. Business Without Interruption

More Related