210 likes | 336 Views
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?
E N D
Selling the Storage Edition for Oracle November 2000
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?
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
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)
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 Editionfor Oracle Raw Devices HFS/JFS Storage Edition for OracleProduct Positioning Performance 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 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
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
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
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
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
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
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 NetBackup Server engine and database server to be backed up to be a NetBackup client
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 +
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
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)
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