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
Positioning Matrix
Database Edition for 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 (contd)

• 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 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

11
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
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
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
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
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
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
• 11, Any1 and 1Any 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