Transcript Selling the Database Edition for Oracle on HP

Selling the Database Edition
for Oracle on HP-UX
November 2000
The Need
Key Customer Concerns
Continuous availability (24x7) 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
• Oracle7.3 or later (inclusive of Oracle8i)
– 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
VxDBA Utility
Building
Blocks
Storage Checkpoints & Quick I/O
OnlineJFS 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
Database Edition for Oracle
Product Positioning
Raw Devices
Performance
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
VxDBA 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
Advantages Disadvantages
Performance Manageability
Manageability Performance

Best OLTP
performance
Data
Reliability

No potential
for data loss
with data
written to
disks directly
“Invisible”
locations for
tablespaces
 Difficult to
grow
tablespaces




Tablespace

Lower database
organization
throughput
System-wide
(30-90% of
backup and
raw disk)
restore

Higher CPU
policies
overhead
Easy to create
Data Reliability
and expand
files for Oracle  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
Raw I/O
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
Percenta ge of Raw I/O Performance
Raw = 100%
100%
Quick I/O
Buffered I/O
Direct I/O
80%
60%
40%
20%
0%
100 MB
200 MB
300 MB
400 MB
500 MB
Oracle Buffer Cache Size
600 MB
700 MB
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:
• 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
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
Block-Level Incremental Backup
Changed Blocks
Since Last
Backup
VERITAS File
System
with Storage
Checkpoints
NetBackup Server
NetBackup
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 NetBackup Server engine and
database server to be a NetBackup 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/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
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
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 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
Business Without Interruption