Master Complexity Symantec Veritas and Oracle Together 1

Master Complexity Symantec/Veritas and Oracle Together 1

Symantec/Veritas and Oracle Together Presented to UNYOUG 10/11/2007

Agenda 1 Symantec/Veritas – Oracle History 2 Symantec/Veritas – Oracle : Single Instance 3 Symantec/Veritas – Oracle : Single Instance - HA 4 Symantec/Veritas – Oracle : RAC 5 Comparison of Single Instance, HA, and RAC 6 A word or two about Symantec/Veritas and ASM 7 Summary Symantec/Veritas and Oracle Together 3

Symantec/Veritas – Oracle History A Decade of Partnership Symantec/Veritas and Oracle Together 4

Symantec/Veritas Position • Oracle is a great database company • We have, a rich history of partnership in the Enterprise Data Center market • Symantec/Veritas is clustering/infra-structure experts that address the entire IT environment: – Strong Support: Vast repository of cluster configurations/Volume Manager/File System & knowledge base covering both large and small organizations – We’ve been making cluster software/VM/FS for over 12 years • Customers have freedom of choice • We make Oracle even better! Symantec/Veritas and Oracle Together 5

History • • • Vx. VM Resilvering /Mirror for Oracle (Smart. Sync for RAW, now CFS) VXFS Snapshots (For quick, consistent, Oracle backups) QIO (Quick IO for Asynchronous writes) Cached QIO ( For satisfying File System read-cache requests) ODM (Asynchronous writes without File System locking) CVM (Developed by VERITAS for Oracle Parallel Server 8 i) VOS (VERITAS ORACLE SUN, JEC- Joint Escalation Center) SFRAC for Solaris, AIX, HP-UX RMAN (Net. Backup) APM (Indepth for Oracle) Today: Widespread adoption in Oracle deployments on open systems Ongoing development & integration (Symantec Engineers onsite at Oracle’s corporate office) • SFCFS for RAC on LINUX (RH, Suse & Oracle Enterprise Linux) Symantec/Veritas and Oracle Together 6

ODM Time Line Oracle develops initial spec of ODM Pre-1999 Prototyping & early development establish ODM’s viability 1999 Oracle and VERITAS sign ODM agreement Oracle 9 i ships 2000 2001 VERITAS releases DB Edition 3. 0 w/ODM support Oracle 10 g prevalent 2007 VERITAS SFORA/SFRAC 5. 0 w/ODM prevalent Symantec/Veritas and Oracle Together 7

Recent activities with Oracle • Platform partner – Onsite, part of Oracle release process – On-going certifications of SFRAC for Solaris, HP-UX, AIX – SFCFS for RAC on LINUX (RH, Suse & Oracle Enterprise Linux) • Includes coverage of Oracle 11 g • Support for ASM with Storage Foundation – Includes VCS agent for HA ASM failovers (Oracle single instance) • Symantec will develop a Storage Foundation plug-in for Oracle Enterprise Manager – to be available by OOW – 11/14/2007 and FREE! • Oracle supports VCS control of RAC resources – Mostly for control of the Database instance, Listener and other resources should still be under CRS control, but can be under VCS if customer really wants it that way. Symantec/Veritas and Oracle Together 8

RAC certifications Oracle 9 i Oracle 10 g Oracle 11 g (1 Q 08) Part of Oracle release process AIX HP-UX Itanium Part of Oracle release process HP-UX PA-RISC Part of Oracle release process Solaris SPARC Part of Oracle release process Linux Solaris Opteron SFCFS ONLY ? ? Part of Oracle release process Symantec/Veritas and Oracle Together 9

Symantec/Veritas – Oracle: Single Instance Symantec/Veritas and Oracle Together 10

Storage Foundation for Oracle (SFOR) Oracle • Use same infrastructure software across enterprise datacenter – Supports many brands and versions of Operating Systems, storage arrays, and databases – Standardize environment to improve operational efficiencies RAC Extensins Cluster Server Database Accelerator (ODM) Veritas File System Veritas Volume Manager Hardware • Based on core VERITAS technologies – VM/FS 15+ years of customer successes – Robust features & stability – Reuse VERITAS knowledge • Storage Foundation Manager (SFM) • Hundreds of successful customer installs in production Oracle environments Symantec/Veritas and Oracle Together 11

SFOR Benefits in a Oracle environment Oracle RAC • Enterprise-ready File System (Vx. FS) – File system ease of use – Oracle Disk Manager provides raw-like performance – Supports all data types • RAC Extensions Cluster Server Database Accelerator (ODM) Cluster File System Cluster Volume Manager Data files, logs, binaries, OS, app data, etc. . . • Enterprise-ready Volume Manager (Vx. VM) – – – – Dynamic Multi-Pathing Snapshot technology for off-host processing 100 s of tested OS/array combinations Granular I/O separation/tuning capabilities Simplified device naming and mgmt Dynamic Storage Tiering Deep Mapping Hardware Symantec/Veritas and Oracle Together 12

ODM - Performance with Manageability • Eliminates traditional UNIX file system overhead – Allows parallel updates to database files for increased throughput – Has asynchronous I/O built-in – Oracle handles locking for data integrity – Avoids duplicate opening of files per Oracle instance – save memory and CPU – Fewer system calls and context switches – Reduced CPU utilization – Efficient file creation and disk allocation Symantec/Veritas and Oracle Together 13

Symantec/Veritas – Oracle: Single Instance High Availability Symantec/Veritas and Oracle Together 14

Storage Foundation for Oracle (SFOR -HA) Oracle • Use same infrastructure software across enterprise datacenter – Supports many brands and versions of Operating Systems, storage arrays, and databases – Standardize environment to improve operational efficiencies RAC Extensins Cluster Server Database Accelerator (ODM) Cluster File System Cluster Volume Manager • Based on core VERITAS technologies – – VCS 12+ years of customer success VM/FS 15+ years of customer successes Robust features & stability Reuse VERITAS knowledge • Storage Foundation Manager (SFM) Hardware • Hundreds of successful customer installs in production Oracle environments Symantec/Veritas and Oracle Together 15

SFOR-HA Benefits in a Oracle environment Oracle RAC Extensions • Enterprise-ready Cluster File System – File system ease of use – Oracle Disk Manager provides raw-like performance – Supports all data types • Data files, logs, binaries, OS, app data, etc. . . – Same look and feel as Vx. FS Cluster Server Database Accelerator (ODM) Cluster File System Cluster Volume Manager Hardware • Enterprise-ready Cluster Volume Manager – – – – Dynamic Multi-Pathing Snapshot technology for off-host processing 100 s of tested OS/array combinations Granular I/O separation/tuning capabilities Simplified device naming and mgmt Dynamic Storage Tiering Deep Mapping Same look and feel as Vx. VM Symantec/Veritas and Oracle Together 16

SFOR-HA - Veritas Cluster Server Benefits in a Oracle environment Oracle RAC Extensions Cluster Server Database Accelerator (ODM) Cluster File System Cluster Volume Manager • Enterprise-ready Cluster Server – Robust I/O Fencing – Dozens of pre-built agents for enterprise applications, well known adopted clustering API – Support for many Disaster Recovery configurations • Campus Clusters • Remote DR sites • Heterogeneous replication support • Integrated with O/S kernel Hardware Symantec/Veritas and Oracle Together 17

Standardization: VCS Support for Apps & DBs Databases Version Oracle 7. 1 -8. 2(+EEE) Sybase 2000, 2005 HP/UX Windows Linux (RH) 11. x-12. 5 , 15 SQL AIX 8 i-9 i, 10 g. R 2 DB 2 Solaris N/A (+SLES) N/A N/A Applications Exchange 2000, 2003 Oracle e. Bus Apps 11. 5. 7 -. 9 , . 10 Oracle App Srvr 9. 0. 4 -10. 1. 2 People. Soft 8. 1, 8. 4, 8. 8 SAP 4. 6, 4. 7, 6. 2 Net. Weaver Siebel Sun ONE (Sun JES) 6. x-7. 7, 7. 8 5. 0 -6. 1 Tuxedo 6. 5 -8. 1 Web. Logic Server 6. 1 -8. x Web. Sphere App Srvr 5. x, 6. 0 Web. Sphere MQ N/A 5. 3 N/A , 9. 0 N/A Symantec/Veritas and Oracle Together 18

Symantec/Veritas – Oracle: RAC Symantec/Veritas and Oracle Together 19

Storage Foundation for Oracle RAC (SFRAC) • Oracle RAC Use same infrastructure software across enterprise datacenter – – • Based on core VERITAS technologies – – RAC Extensions Cluster Server Supports many brands and versions of Operating Systems, storage arrays, and databases Standardize environment to improve operational efficiencies VCS 10+ years of customer success SF 15+ years of customers success Robust features & stability Reuse VERITAS knowledge Database Accelerator (ODM) Cluster Volume Manager Hardware • Storage Foundation Manager (SFM) • Specific enhancements for the RAC environment • Cluster File System Hundreds of successful installs and production customers in Oracle RAC environments Symantec/Veritas and Oracle Together 20

SFRAC Benefits in a Oracle environment Oracle RAC • Enterprise-ready Cluster File System – File system ease of use – Oracle Disk Manager provides raw-like performance – Supports all data types • RAC Extensions Cluster Server Database Accelerator (ODM) Cluster File System Cluster Volume Manager Hardware Data files, logs, binaries, OS, app data, etc. . . – Same look and feel as Vx. FS • Enterprise-ready Cluster Volume Manager – – – – Dynamic Multi-Pathing Snapshot technology for off-host processing 100 s of tested OS/array combinations Granular I/O separation/tuning capabilities Simplified device naming and mgmt Dynamic Storage Tiering Deep Mapping Same look and feel as Vx. VM Symantec/Veritas and Oracle Together 21

SFRAC - Veritas Cluster Server Benefits in a Oracle environment • Enterprise-ready Cluster Server Oracle RAC Extensions – Robust I/O Fencing – Dozens of pre-built agents for enterprise applications, well known adopted clustering API – Support for many Disaster Recovery configurations • • • Campus Clusters Remote DR sites Heterogeneous replication support Cluster Server Database Accelerator (ODM) Cluster File System Cluster Volume Manager • Specific extensions for Oracle RAC – Cluster membership coordinated across all software tiers - Robust I/O Fencing to handle Split-Brain – Robust performance and availability for cluster interconnects • Integrated with O/S kernel Hardware Symantec/Veritas and Oracle Together 22

Comparison of Single Instance, HA, and RAC Symantec/Veritas and Oracle Together 23

Three Levels of Availability for Oracle SINGLE INSTANCE HA /CLUSTERING RAC ARCHITECTURES • Manual fail-over • Automated fail-over • Highest availability • Simple set-up • Active/passive or N+1 • Shared resources • Hours to restore • Minutes for fail-over • Fastest fail-over Recommended Architectures Symantec/Veritas and Oracle Together 24

Database Fail-over: What to Expect SF HA for Oracle (single instance Oracle) SF CFS HA w/ (single instance Oracle) SF RAC (Oracle RAC) • Import disk group • Mount file system • Start database • Resolve transactions (replay logs) • Update IP • Clients Reconnect Resolving database transactions (replaying redo logs) to recover failed transactions during fail-over is a necessary step in any HA architecture. Log replay is likely to account for the bulk of recovery time. Symantec/Veritas and Oracle Together 25

3 Architectures for similar workloads Oracle 10 g. RAC Oracle Active/Passive N+1 Cluster with SFOHA DB-1 DB-2 DB-1 DB-3 DB-2 DB-1 § § § 4 servers 0 SFHA licenses 4 Oracle licenses 4 RAC licenses 4 Power. Path licenses § Databases: 3 § Failover time: seconds § Performance Overhead: 15 -25% § § § DB-2 DB-3 6 servers 0 SFHA licenses 6 Oracle licenses 0 RAC licenses 6 Power. Path licenses § Databases: 3 § Failover time: minutes § Performance Overhead: 0% DB-3 § § § 4 servers 4 SFHA licenses 4 Oracle licenses 0 RAC licenses 0 Power. Path licenses § Databases: 3 § Failover: Seconds to minutes § Performance Overhead: 0% Symantec/Veritas and Oracle Together 26

Storage Foundation for Oracle HA 1. Detects fault 2. Gracefully shuts down: 1. Application & database 2. Network resources 3. File system & storage resources 3. Migrates storage to standby 4. Starts resources on standby 5. Redirects traffic to standby Single Instance SF HA Symantec/Veritas and Oracle Together 27

Comparison of Single Instance HA and RAC • No matter which Oracle availability approach you select, Symantec/Veritas has the solution: – Single Instance HA with non clustered VM/FS • SFOR-HA with Vx. VM/Vx. FS – Single Instance HA with clustered VM/FS • SFOR-HA with CVM/CFS – RAC • SFRAC • And just to let you know, regarding Disaster Recover (DR), we have: – Global Cluster Option (GCO) – extension of VCS – Veritas Volume Replicator (VVR) Symantec/Veritas and Oracle Together 28

A word or two about Symantec/Veritas and ASM Symantec/Veritas and Oracle Together 29

Summary of Functionality Analysis * Except for ASM Disks Symantec/Veritas and Oracle Together 30

Administration Protection Performance ASM Alone Mirror Quick I/O ODM No Quick I/O (Some customers prefer QIO to ODM) Stripe ASM does not use ODM but does provide raw like performance Snapshot Checkpoint No Snapshot No Checkpoint No Replicate Migrate Arrays Tier Storage Grow No Migrate Arrays Copy Replicate No Tiered Storage $$$ $$ Online Defrag No Multi-path Table & Index Clustered File System No Copy Migrate OS Unix Linux Multi-path Change Log No Change Log Concatenate No Concatenate Slice No Slice $ Symantec/Veritas and Oracle Together 31

Administration Protection Performance ASM with Storage Foundation Snapshot Mirror Checkpoint Quick I/O ODM No Quick I/O (Some customers Prefer QIO to ODM) Stripe ASM does not use ODM but does provide raw like performance Copy Replicate No Checkpoint Grow Migrate Arrays Online Defrag Table & Index Clustered File System No Copy Tier Storage No Tiered Storage $$$ $$ Migrate OS Unix Multi-path Change Log No Change Log Concatenate Slice Linux $ Symantec/Veritas and Oracle Together 32

Administration Protection Performance SFOR Stand Alone – a complete solution! Stripe Snapshot Grow Mirror Checkpoint Migrate Arrays Quick I/O ODM Tier Storage Clustered File System Change Log Migrate OS Unix $$$ $$ Multi-path Copy Replicate Online Defrag Concatenate Slice Linux $ Symantec/Veritas and Oracle Together 33

Summary Symantec/Veritas and Oracle Together 34

Summary – SFOR/SFRAC value adds 1. Fully supports enterprise IT standardization – it is a complete solution 2. Fully supports any combination of Oracle single instance and RAC environments. 3. Includes DMP which provides the necessary functionality for load balancing and channel failover of storage resources 4. Includes intelligent storage management, as it has understanding and visibility of underlying physical disk in enterprise class storage environments such as Hitachi, EMC, and IBM Shark 5. Offers flexibility and granularity in laying out storage recognizing that dynamically changing environments will need i/o tuning from time to time. 6. Is a mature product (about 12 years old) that is endorsed for all environments including large scale ERP such as SAP. 7. Provides an infra-structure that facilitates DBAs, SAs, and Storage Admins working effectively and efficiently as a team to provide robust infra-structure for mission critical environments. 8. Provides robust (kernel level) cluster member management and performance/availability of cluster interconnect and CVM/CFS 9. Because the SFOR/SFRAC suite of products fully supports single instance Oracle as well as RAC, if you choose to deploy without RAC or with a mix of single instance and RAC, the very same infrastructure will meet your needs. 10. With the additional capabilities of VVR and GCO, a Highly Available solution can be architected for your Oracle environment to address not only HA, but DR as well! Symantec/Veritas and Oracle Together 35