1 / 21

Selling the Storage Edition for Oracle

Selling the Storage Edition for Oracle. November 2000. The Need Key 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, and poor customer service?

cissy
Télécharger la présentation

Selling the Storage Edition for Oracle

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 Storage Edition for Oracle 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, and poor customer service? • Faster access to data • Are you using file systems or raw disk partitions to store 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 Oracle 8i) • Upgrading database • Database can withstand some downtime

  4. Storage Edition 2.1.1 Architecture • An integrated product suite, specifically engineered for Oracle environments Oracle Storage Edition for Oracle VxDBA Utility Storage Checkpoints & Quick I/O OnlineJFS File System (fulfilled by HP)

  5. Product Positioning • For DBAs facing immense time pressure in an environment with ever-increasing data, the Storage Edition for Oracle offers file system manageability without sacrificing the performance or data integrity of raw devices. • 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. Storage Editionfor Oracle Raw Devices HFS/JFS Storage Edition for OracleProduct Positioning Performance Manageability

  7. Product Description • Raw disk performance with ease of file system administration using Quick I/O technology • Online administration of database storage • Minimize unplanned downtime with fast recovery • Proactive, automated monitoring of file system space • Point in time recovery from disk with Storage Rollback • Minimize database backup window with BLI Backup

  8. Product Description (cont.) • Unique, total storage foundation solution to deliver the best of both worlds Storage 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

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

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

  11. New Feature Overview • Support for Asynchronous I/O • Raw device performance • Up to 160% faster than buffered I/O file systems • Allows for parallel updates to datafiles • Storage Checkpoints • Enable Block-Level Incremental Backup • Enable Storage Rollback for immediate “point-in-time” recovery from on-disk images

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

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

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

  18. Product Description • Hosts Supported • HP-UX 11.0 • Passed MC/ServiceGuard compatibility testing • System Requirements • Oracle7 and Oracle8i ORACLE CERTIFIED • Physical Packaging • Enables license key for OnlineJFS File System • Quick I/O • VxDBA utility to manage Storage Checkpoints and Storage Rollback

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

  20. Features & Benefits • Quick I/O 3.3.2Equal 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

  21. Business Without Interruption

More Related