Скачать презентацию Selling the Storage Edition for Oracle November 2000 Скачать презентацию Selling the Storage Edition for Oracle November 2000

b8a09d16f35f578e4203d6d13413fc90.ppt

  • Количество слайдов: 21

Selling the Storage Edition for Oracle November 2000 Selling the Storage Edition for Oracle November 2000

The Need Key Customer Concerns Continuous availability (24 x 7) of mission-critical Oracle databases 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 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 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, 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Business Without Interruption