Master Complexity

1
Master Complexity
2
Symantec/Veritas and Oracle Together Presented
to UNYOUG

• 10/11/2007

3
Agenda
4
Symantec/Veritas Oracle HistoryA Decade of
Partnership
5
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
• Weve been making cluster software/VM/FS for over
  12 years
• Customers have freedom of choice
• We make Oracle even better!

6
History

• VxVM Resilvering /Mirror for Oracle (SmartSync
  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 8i)
• VOS (VERITAS ORACLE SUN, JEC- Joint Escalation
  Center)
• SFRAC for Solaris, AIX, HP-UX
• RMAN (NetBackup)
• APM (Indepth for Oracle)
• Today Widespread adoption in Oracle deployments
  on open systems
• Ongoing development integration (Symantec
  Engineers onsite at Oracles corporate office)
• SFCFS for RAC on LINUX (RH, Suse Oracle
  Enterprise Linux)

7
ODM Time Line
Prototyping early development establish
ODMs viability
Oracle develops initial spec of ODM
Oracle 9iships
Oracle 10gprevalent
2000
2007
1999
2001
Pre-1999
Oracle and VERITAS sign ODM agreement
VERITAS releases DB Edition 3.0 w/ODM support
VERITAS SFORA/SFRAC 5.0 w/ODM prevalent
8
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 11g
• 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.

9
RAC certifications
Oracle 9i Oracle 10g Oracle 11g (1Q08)
AIX Part of Oracle release process
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 SFCFS ONLY ??
Solaris Opteron Part of Oracle release process
10
Symantec/Veritas OracleSingle Instance
11
Storage Foundation for Oracle (SFOR)

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

12
SFORBenefits in a Oracle environment

• Enterprise-ready File System (VxFS)
• File system ease of use
• Oracle Disk Manager provides raw-like performance
• Supports all data types
• Data files, logs, binaries, OS, app data, etc...
• Enterprise-ready Volume Manager (VxVM)
• Dynamic Multi-Pathing
• Snapshot technology for off-host processing
• 100s of tested OS/array combinations
• Granular I/O separation/tuning capabilities
• Simplified device naming and mgmt
• Dynamic Storage Tiering
• Deep Mapping

13
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

14
Symantec/Veritas OracleSingle InstanceHigh
Availability
15
Storage Foundation for Oracle (SFOR -HA)

• 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
• 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)
• Hundreds of successful customer installs in
  production Oracle environments

16
SFOR-HABenefits in a Oracle environment

• 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 VxFS
• Enterprise-ready Cluster Volume Manager
• Dynamic Multi-Pathing
• Snapshot technology for off-host processing
• 100s 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 VxVM

17
SFOR-HA - Veritas Cluster Server Benefits in a
Oracle environment

• 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

18
Standardization VCS Support for Apps DBs
Databases Version Solaris AIX HP/UX Windows Linux (RH)
Oracle 8i-9i,10g
DB2 7.1-8.2(EEE) N/A
Sybase 11.x-12.5
SQL 2000, 2005 N/A N/A N/A
Applications
Exchange 2000, 2003 N/A N/A N/A N/A
Oracle eBus Apps 11.5.7-.9
Oracle App Srvr 9.0.4-10.1.2
PeopleSoft 8.1, 8.4, 8.8
SAP 4.6, 4.7, 6.2
Siebel 6.x-7.7
Sun ONE (Sun JES) 5.0-6.1 N/A N/A N/A N/A
Tuxedo 6.5-8.1
WebLogic Server 6.1-8.x
WebSphere App Srvr 5.x, 6.0 N/A
WebSphere MQ 5.3
10gR2
, 15
, .10
NetWeaver
, 7.8
, 9.0
19
Symantec/Veritas OracleRAC
20
Storage Foundation for Oracle RAC (SFRAC)

• 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
• Based on core VERITAS technologies
• VCS 10 years of customer success
• SF 15 years of customers success
• Robust features stability
• Reuse VERITAS knowledge
• Storage Foundation Manager (SFM)
• Specific enhancements for the RAC environment
• Hundreds of successful installs and production
  customers in Oracle RAC environments

21
SFRACBenefits in a Oracle environment

• 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 VxFS
• Enterprise-ready Cluster Volume Manager
• Dynamic Multi-Pathing
• Snapshot technology for off-host processing
• 100s 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 VxVM

22
SFRAC - Veritas Cluster Server Benefits in a
Oracle environment

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

23
Comparison of Single Instance, HA, and RAC
24
Three Levels of Availability for Oracle
RAC ARCHITECTURES
HA /CLUSTERING
SINGLE INSTANCE

• Manual fail-over
• Simple set-up
• Hours to restore

• Automated fail-over
• Active/passive or N1
• Minutes for fail-over

• Highest availability
• Shared resources
• Fastest fail-over

Recommended Architectures
25
Database Fail-over What to Expect
SF RAC (Oracle RAC)
SF CFS HA w/ (single instance Oracle)
SF HA for Oracle (single instance Oracle)

• Import disk group
• Mount file system
• Start database
• Resolve transactions (replay logs)
• Update IP
• Clients Reconnect

• Import disk group
• Mount file system
• Start database
• Resolve transactions (replay logs)
• Update IP
• Clients Reconnect

• 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.
26
3 Architectures for similar workloads
Oracle 10gRAC
Oracle Active/Passive
N1 Cluster with SFOHA

• 4 servers
• 0 SFHA licenses
• 4 Oracle licenses
• 4 RAC licenses
• 4 PowerPath licenses

• 6 servers
• 0 SFHA licenses
• 6 Oracle licenses
• 0 RAC licenses
• 6 PowerPath licenses

• 4 servers
• 4 SFHA licenses
• 4 Oracle licenses
• 0 RAC licenses
• 0 PowerPath licenses

• Databases 3
• Failover time seconds
• Performance Overhead 15-25

• Databases 3
• Failover time minutes
• Performance Overhead 0

• Databases 3
• Failover Seconds to minutes
• Performance Overhead 0

27
Storage Foundation for Oracle HA

1. Detects fault
2. Gracefully shuts down
3. Application database
4. Network resources
5. File system storage resources
6. Migrates storage to standby
7. Starts resources on standby
8. Redirects traffic to standby

Single Instance
Single Instance
SF HA
SF HA
28
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 VxVM/VxFS
• 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)
•  

29
A word or two about Symantec/Veritas and ASM
30
Summary of Functionality Analysis
Except for ASM Disks
31
ASM Alone
No Multi-path
No Quick I/O - (Some customers prefer QIO to
ODM)
Performance
ASM does not use ODM but does provide raw like
performance
Table Index
No Snapshot
No Checkpoint
No Replicate
No Copy
No Change Log
Protection
No Migrate Arrays
No Tiered Storage
No Concatenate
No Slice
Administration
32
ASM with Storage Foundation
No Quick I/O - (Some customers Prefer QIO to
ODM)
Performance
ASM does not use ODM but does provide raw like
performance
Table Index
No Checkpoint
No Copy
No Change Log
Protection
No Tiered Storage
Administration
33
SFOR Stand Alone a complete solution!
Performance
Protection
Administration
34
Summary
35
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!