Selling the Storage Edition for Oracle November 2000
The Need Key Customer Concerns Continuous availability (24 x 7) 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?
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 • Oracle 7. 3 or later (inclusive of Oracle 8 i) – Upgrading database – Database can withstand some downtime
Storage Edition 2. 1. 1 Architecture An integrated product suite, specifically engineered for Oracle environments Oracle Storage Edition for Oracle Vx. DBA Utility Storage Checkpoints & Quick I/O Online. JFS File System (fulfilled by HP)
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
Storage Edition for Oracle Product Positioning Storage Edition for Oracle Performance Raw Devices HFS/JFS Manageability
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
Product Description (cont. ) Unique, total storage foundation solution to deliver the best of both worlds Storage Edition for Oracle Raw Disks Conventional File Systems Advantages Disadvantages Performance Manageability Performance t Best OLTP performance Data Reliability t No potential for data loss with data written to disks directly “Invisible” locations for tablespaces t Difficult to grow tablespaces t t Tablespace t Lower database organization throughput System-wide (30 -90% of backup and raw disk) restore t Higher CPU policies overhead Easy to create Data Reliability and expand files for Oracle t Potential data loss
Raw Device Performance Quick I/O for Databases Breakthrough VERITAS File System interface technology Presents regular VERITAS File System files to Oracle as raw character devices Quick I/O regular raw file device RDBMS Server • 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
Quick I/O Performance Comparison to Raw I/O Storage Edition has equal to raw performance • 160% performance improvement over traditional file systems Tested configuration included: • HP K 570 (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
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-intime” recovery from on-disk images
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 for changed data blocks
Benefits of Storage Checkpoints Storage Rollback: • Vx. DBA utility manages Storage Checkpoints for faster database recoverability from on-disk backup image • Protects from logical errors • What-if analysis Block-Level Incremental Backup: • Net. Backup manages Storage Checkpoints and extracts only the changed blocks • Virtually eliminates database backup window
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
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
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 Net. Backup Server engine and database server to be backed up to be a Net. Backup client
Block-level Incremental Backup Changed Blocks Since Last Backup VERITAS File System with Storage Checkpoints Net. Backup Server Net. Backup BLI Extension Minimize Your Database Backup Window Previous Full Backup + Block Level Incrementals Full Restore
Product Description Hosts Supported • HP-UX 11. 0 • Passed MC/Service. Guard compatibility testing System Requirements • Oracle 7 and Oracle 8 i ORACLE CERTIFIED Physical Packaging • Enables license key for Online. JFS File System • Quick I/O • Vx. DBA utility to manage Storage Checkpoints and Storage Rollback
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 (5 x 12) • Premier Direct Assist Support (7 x 24)
Features & Benefits Quick I/O 3. 3. 2 Equal to raw performance with file system manageability Online database administration Reduces production database downtime Block-Level Incremental Backup Support Minimizes database backup window Storage Checkpoint & Rollback Faster database recoverability Automated file system growth Proactive system administration
Business Without Interruption
Скачать презентацию Selling the Storage Edition for Oracle November 2000
b8a09d16f35f578e4203d6d13413fc90.ppt