Selling the Database Edition for Oracle on HP-UX

Selling the Database Edition for Oracle on HP-UX November 2000

The Need Key Customer Concerns Continuous availability (24 x 7) of missioncritical 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?

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 or – Database can withstand some downtime

VERITAS Database Edition 2. 1. 1 Integration of online and offline storage management for HP environments Oracle Database Edition for Oracle Vx. DBA Utility Building Blocks Storage Checkpoints & Quick I/O Online. JFS File System (fulfilled by HP) VERITAS Volume Manager

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

Performance Database Edition for Oracle Product Positioning Raw Devices Database Edition for Oracle HFS/JFS Manageability

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 faulttolerant storage options Online administration of database storage

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

Building Oracle Databases on Raw Disks vs. File Systems Unique, total storage foundation solution to deliver the best of both worlds Database 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 Database Edition has equal to raw performance • Up to 200% performance improvement over traditional file systems Tested configuration included: • 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

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

Uses 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 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 Vx. DBA utility

Block-Level Incremental Backup Changed Blocks Since Last Backup VERITAS File System with Storage Checkpoints Net. Backup Server Net. Backup BLI Backup Extension Minimize Your Database Backup Window Previous Full Backup + Block Level Incrementals Full Restore

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 Net. Backup Server engine and database server to be a Net. Backup client

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

Product Description Hosts Supported • HP-UX 11. 0 • MC/Service. Guard not supported System Requirements • Oracle 7. 3 to 8 i ORACLE VALIDATED Physical Packaging • • Enables the license key for Online. JFS File System VERITAS Quick I/O VERITAS Volume Manager 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 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

When Selling on HP-UX Up to 200% performance increase over running Oracle on traditional buffered file system Enables HP Online. JFS File System that is an OEM version of VERITAS File System Storage Edition assumes LVM running underneath; Database Edition runs on Vx. VM Storage Edition supports MC/Service. Guard; Database Edition does not

Business Without Interruption