Database Edition for Oracle

1. Database Edition for Oracle Sales Presentation

2. Market Drivers • Faster access to data • Are you using file systems or raw disk partitions to Oracle data? • 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? • Easier management of increasing data • Do your DBAs have to learn how to manage raw disk partitions to gain database performance?

3. What are the Database Editions? • Integrated storage management solutions optimized for specific application areas • Database Edition for Oracle • Database Edition for Sybase

4. Software Stack QuickLog HA Agent HA Edition Oracle Database HA Agent VERITAS Cluster Server VxDBA Administration Utility QuickLog for File System Standard Edition (Cached) Quick I/O for Databases File System with Storage Checkpoints Volume Manager

5. Product Positioning • VERITAS Database Edition for Oracle offers raw device performance with file system manageability. • Increases availability of Oracle databases • Offers equal to raw performance and for high-memory systems up to 150% performance improvement • Offers ease of management of file systems • Integrated online and offline storage management solution

6. Raw Devices UFS Positioning Matrix Database Editionfor Oracle Performance Manageability

7. Customer Target • Oracle Database Administrator • What is the customer using, and how does this product fit into their installation? • Solaris 2.6, 7, or 8 • New Installations • Upgrading OS • Oracle Enterprise Server Release 7.3 to 8i • Upgrading database or • Database can withstand some downtime

8. Feature Overview • Quick I/O & Cached quick I/O • Raw device performance with file system manageability • Cached Quick I/O for up to 150% performance improvement over raw devices • VERITAS Volume Manager & VERITAS File System • Online disk & file management • Stripped / Mirrored arrays • Java-based Storage Administrator GUI

9. Feature Overview (cont’d) • Storage Checkpoints • Block-Level Incremental Backup (w/ NetBackup) • Storage Rollback for immediate “point-in-time” recovery from “logical errors” • QuickLog for File System • Automatic monitoring and recovery of Oracle(HA Edition) • Vendor Certification – Oracle OSCP

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

11. Quick I/O raw device regular file Quick I/O • 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 kernel async I/O (Solaris’ KAIO) • Oracle handles locking for data integrity • Simple scripts convert existing files to Quick I/O and create new database files as Quick I/O files Eliminates traditional UNIX file system overhead RDBMS Server

12. Cached Quick I/O Overview • Implemented as a buffered read, direct write solution • Retains data reliability advantage of direct write • Gains read-ahead at the File System and memory-to-memory copy performance advantage • Easy online management to turn Cache on/off for Quick I/O files • Like Quick I/O, enabled on a per-file basis • Multiple database instances can co-exist with selective caching for specific datafiles

13. Cached Quick I/O Outperforms UFS on 64-bit Solaris 7 Database Edition 2.2 with Cached Quick I/O delivers up toSix times the performance of UFS using Direct I/O • Tested configurationincluded: • Sun UE 10000 (10 CPUs and 6 GB of RAM) • Solaris 7 (64-bit) • DB Edition 2.2 for Oracle • Oracle 8.1.5 (64-bit) • TPC-C scale factor of 200 warehouses

14. VERITAS QuickLog • Improves VERITAS File System Write performance by exporting intent log • Updates intent log in parallel with accessing file data • Eliminates the seek time between intent log area and file system data area • Transparent to end users • Minimal system administration setup • Database Edition/HA provides automated QuickLog failover

15. Standard VERITAS File System VERITAS File System with QuickLog log volume fs1 fs2 intent log Data Data VERITAS QuickLog Boost File System Write Performance fs1 fs2 intent log intent log Data Data

16. Storage Checkpoints • Point-in-time image 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 • Changed data blocks are stored on disk • Take only seconds to complete • Take as many as you like!

17. A B C D E Create a Storage Checkpoint Simplified illustration of creating a Storage Checkpoint Primary File System Storage Checkpoint (empty) The Storage Checkpoint presents an exact image of the primary file system.

18. A B C D E File System is Updated... Simplified illustration of a Storage Checkpoint Primary File System Storage Checkpoint Update E1 E As the primary file system is updated, the original data is copied to the Storage Checkpoint before the new data is written. As the primary file system continues to change, the Storage Checkpoint accumulates the original data blocks.

19. A B C D E and updated again.. Simplified illustration of a Storage Checkpoint Primary File System Storage Checkpoint Update C C1 E1 E And so the process continues until the next Storage Checkpoint is created.

20. Uses of Storage Checkpoints • Storage Rollback • Faster database recoverability from on-disk backup image managed by VxDBA utility • Block-Level Incremental Backup • NetBackup manages Storage Checkpoints and extracts only the changed blocks • Database Replication Option (available separately) • Storage Checkpoints allow for database replication to secondary system to offload primary server of maintenance tasks

21. Storage Rollback • Recover Quickly from Logical Errors • On disk point-in-time image of data • Simply write back changed (blue) blocks to previous state

22. Block-Level Incremental Backup • Back up only changed data blocks • Virtually eliminates backup windows • Allows more frequent backup schedules • Enhanced performance • Significantly lowers CPU and network resource drain during backups • Faster recovery from backups (vs. applying changes in logs)

23. 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 +

24. Full Increm 1 Increm 2 RestoreVxFS BLI - tape 138:24 5:01 5:02 16:11 • RMAN - tape 103:33 15:10 15:24 34:09 • VxFS BLI - disk 31:01 1:42 1:54 1:04 • RMAN - disk 25:00 12:17 11:59 4:48 Block-Level Incremental Backup / Restore Performance • 5.9 GB Oracle Database on SUN UE3000 • 8 tables, about 15M records total • Increment 1 updates 12000 records • Increment 2 updates 80000 records • Restore of all updated records • Source: Boeing Corporation

25. Database Edition/HAVERITAS Cluster Server • Sophisticated availability configuration management • Clustered HA solution allowing 2-32 server scalability • 1:1, Any:1 and 1:Any policy-based failover • Application level cascading failover • Fast Kernel-to-Kernel communication & failover • Certified 3rd party support for SCSI, SAN & NAS storage • Centralized Cluster Manager console for HP-UX, Solaris and Windows NT

26. Product Description • Hosts Supported • Solaris 2.6, 7, and 8 • System Requirements • Oracle 7.3 to 8i • Software Components • VERITAS Volume Manager 3.1 • VERITAS File System 3.4 with Quick I/O • Database Edition/HA (VCS) for Oracle • VERITAS Cluster Server 1.2.1 and VCS Agent for Oracle • Intelligent installation script requires only single key

27. Product Description • Educational Packages • Database Edition for Oracle course by VES • Prerequisites are Volume Manager and File System courses • Consulting Packages • Any standard package if necessary • VCS standard or accelerated package for HA Edition • NetBackup package to help implement BLI Backup • UFS to VxFS and SDS to VM conversion tools • Support Packages • Direct Assist Support (5x12) • Premier Direct Assist Support (7x24)

28. Benefits Summary • Increase performance up to 600% over UFS with file system manageability Quick I/O & Cached Quick I/O • Reduce production database downtime Online volume and file system administration with VxVM and VxFS • Minimize database backup windowBlock-Level Incremental Backup • Recover quickly from logical errorsStorage Rollback • Off-Host Processing • Database Replication Option

29. Final Message • VERITAS Database Editions for Oracle is the foundation for any customer running a large Oracle “business critical” database. • “ We believe that those installing new databases should seriously consider using VERITAS Database Edition for Oracle for the combination or performance and manageability it provides. ” • Oracle Large Systems Support Group