Selling the Database Edition for Oracle on HP-UX

1. Selling the Database Editionfor Oracle on HP-UX 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, 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?

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 Oracle8i) • Upgrading database or • Database can withstand some downtime

4. VERITAS Database Edition 2.1.1 • Integration of online and offline storage management for HP environments Oracle Database Edition for Oracle VxDBA Utility Building Blocks Storage Checkpoints & Quick I/O OnlineJFS File System (fulfilled by HP) VERITAS Volume Manager

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

6. Raw Devices HFS/JFS Database Edition for OracleProduct Positioning Database Editionfor Oracle Performance Manageability

7. 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 fault-tolerant storage options • Online administration of database storage

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

9. Building Oracle Databases onRaw Disks vs. File Systems • Unique, total storage foundation solution to deliver the best of both worlds Database 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

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

11. Quick I/O PerformanceComparison to Raw I/O • Database Edition has equal to raw performance • Up to 200% performance improvement over traditional file systems • Tested configurationincluded: • 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

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. Uses 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 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 VxDBA utility

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

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

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

19. Product Description • Hosts Supported • HP-UX 11.0 • MC/ServiceGuard not supported • System Requirements • Oracle7.3 to 8i ORACLE VALIDATED • Physical Packaging • Enables the license key for OnlineJFS File System • VERITAS Quick I/O • VERITAS Volume Manager • VxDBA utility to manage Storage Checkpoints and Storage Rollback

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

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

22. When Selling on HP-UX • Up to 200% performance increase over running Oracle on traditional buffered file system • Enables HP OnlineJFS File System that is an OEM version of VERITAS File System • Storage Edition assumes LVM running underneath; Database Edition runs on VxVM • Storage Edition supports MC/ServiceGuard; • Database Edition does not

23. Business Without Interruption