Selling the Database Edition for Oracle on HPUX

1
Selling the Database Edition for 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
Database Edition for OracleProduct Positioning
Database Edition for 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 Edition for Oracle
Raw Disks
Conventional File Systems
Disadvantages
Advantages
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
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
• HPs 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 DifferentiatorVERITAS 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 EditionBlock-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 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

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