SFORA/SFRAC/ASM/HA-vs-RAC

Document Sample
SFORA/SFRAC/ASM/HA-vs-RAC Powered By Docstoc
					    Symantec/Veritas Briefing
Maximizing value of SFORA/SFRAC

   Presented to Company ABC
           03/01/2010
Storage Foundation for Oracle /HA - RAC
Architecture




                                                                          VERITAS Cluster Server
                   Application
                    Oracle DB


               SF for Databases: ODM,
        On-line Storage Mapping & FlashSnap

          Storage Foundation: PDC, DST,
        DMP, Thin Provisioning & Checkpoints

   Storage Foundation for Databases /HA and RAC
                                 How Symantec/Veritas Adds Value in your Oracle RAC Environment 2
Agenda

1   Understanding Company ABC’s Environment

2   Symantec/Veritas - Oracle History

3   Value Proposition of Symantec/Veritas Stack

4   Value Add of Symantec/Veritas Stack with/without ASM

      -   Oracle 10gR2/11gR1

      -   Oracle 11gR2

5   Considerations concerning Oracle RAC

6   HA vs RAC
                                 How Symantec/Veritas Adds Value in your Oracle RAC Environment 3
Understanding Company
ABC’s Environment




       How Symantec/Veritas Adds Value in your Oracle RAC Environment 4
Understanding Company ABC’s
Environment
•   How many servers – hundreds of DB servers
•   what OS – HP, IBM growing, some Sun, some Linux
•   what applications - Amdocs (30TB), SAP (22TB), many in-house and 3rd party apps.
•   web tier details (middleware, os platform(s)) -
•   web app details (middleware, os platform(s)) – weblogic, websphere
•   what DBs other than Oracle -
•   how many Oracle RAC clusters - 4
•   how many Oracle single instances - many
•   what versions of Oracle - 9i and 10g
•   Using Oracle autoextend? - some
•   Cloning of Oracle DBs – EMC TimeFinder?
•   Volume Manager/File System – LVM/VxFS, some ASM, 50% raw/50% FS for Oracle DB
•   Storage – EMC – DMX for all Oracle; CLARiiON to some extent for non-DB tiers.
•   What SF bundles are in use (e.g. SF, SFORA, SF-HA, SFORA-HA, SFRAC)? SF
•   multi-pathing – PowerPath
•   backup/restore - NBU
•   Files to backup external to Oracle – none
•   HA – MC/Service Guard
•   DR – evolving with move to new Data Centers;SRDF/A; Data Guard and Oracle streams?
•   Storage tiering –
•   Thin Provisioning -
•   Storage Array Migration Plans – none at this time?
•   Server Migration Plans -
•   Performance Monitoring Tools – OEM Grid Control

                                                            How Symantec/Veritas Adds Value in your Oracle RAC Environment 5
Symantec/Veritas –
Oracle History

A Decade of Partnership




      How Symantec/Veritas Adds Value in your Oracle RAC Environment 6
Symantec/Veritas Position
• Oracle is a great and mature database company, but an
  emerging enterprise wide IT clustering/infra-structure
  provider
• 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 15 years
• With Symantec/Veritas, customers have freedom of
  choice
• We make Oracle even better!
                                        How Symantec/Veritas Adds Value in your Oracle RAC Environment 7
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)
•   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)
•   OEM Plug-in
•   SFRAC for Linux – Oracle 11gR2 – certified by Oracle on 01/28/2010
                                         How Symantec/Veritas Adds Value in your Oracle RAC Environment 8
ODM Time Line



                           Prototyping &
   Oracle develops       early development
     initial spec         establish ODM’s               Oracle 9i               Oracle 10g           Oracle 11g
       of ODM                  viability                 ships                  prevalent



     Pre-1999            1999                2000            2001                  2007               2008-10



                       Oracle and                       Veritas                 Veritas
                      Veritas sign                   releases DB            SFORA/SFRAC 5.0
                     ODM agreement                    Edition 3.0               w/ODM
                                                        w/ODM
                                                       support
                                                                                             Veritas
                                                                                         SFORA/SFRAC 5.1
                                                                                             w/ODM


                                                    How Symantec/Veritas Adds Value in your Oracle RAC Environment 9
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) for
     10gR2 and 11gR1
• Includes coverage of Oracle 11g
• Support for ASM with Storage Foundation
   – Includes VCS agent for HA ASM failovers (Oracle single instance)
     and RAC
• Symantec has developed a Storage Foundation plug-in for
  Oracle Enterprise Manager – has been available since
  11/14/2007 and is FREE!
• SFRAC for Linux – Oracle 11gR2 – certified by Oracle on
  01/28/2010
                                       How Symantec/Veritas Adds Value in your Oracle RAC Environment 10
RAC certifications

            Oracle 9i    Oracle 10g           Oracle 11gR1 Oracle 11gR2


AIX                                                                          Q1-2010

HP-UX                                                                        Q1-2010
Itanium
HP-UX PA-                                                                    Q1-2010
RISC
Solaris                                                                      Q1-2010
SPARC
                        SFCFS ONLY           SFCFS ONLY
Linux

Solaris                                                                      Q1-2010
Opteron
                                     How Symantec/Veritas Adds Value in your Oracle RAC Environment 11
Value Proposition of
Symantec/Veritas Stack
   Single Instance Oracle
   Single Instance Oracle HA
   Oracle RAC




              How Symantec/Veritas Adds Value in your Oracle RAC Environment 12
Symantec/Veritas – Oracle:
Single Instance




           How Symantec/Veritas Adds Value in your Oracle RAC Environment 13
Storage Foundation for Oracle (SFOR)

                                    • Use same infrastructure software
               Oracle
                                      across enterprise datacenter
                                       –   Supports many brands and versions of Operating
                                           Systems, storage arrays, and databases
                                       –   Standardize environment to improve operational
                                           efficiencies

             RAC Extensins
                                    • Based on core VERITAS technologies
             Cluster Server            –   VM/FS 15+ years of customer successes
                                       –   Robust features & stability
       Database Accelerator (ODM)
                                       –   Reuse VERITAS knowledge
           Veritas File System

        Veritas Volume Manager      • Storage Foundation Manager (SFM)

                                    • Thousands of successful customer
                                      installs in production Oracle
                                      environments
            Hardware


                                           How Symantec/Veritas Adds Value in your Oracle RAC Environment 14
SFOR
Benefits in a Oracle environment
                                    • Enterprise-ready File System (VxFS)
               Oracle                  –   File system ease of use
                                       –   Oracle Disk Manager provides raw-like performance
                                       –   Supports all data types
                                            •   Data files, logs, binaries, OS, app data, etc...


            RAC Extensions          • Enterprise-ready Volume Manager
             Cluster Server
                                      (VxVM)
                                       –   Dynamic Multi-Pathing (DMP)
       Database Accelerator (ODM)
                                       –   Snapshot technology for off-host processing
           Veritas File System         –   100s of tested OS/array combinations
                                       –   Granular I/O separation/tuning capabilities
        Veritas Volume Manager         –   Simplified device naming and mgmt
                                       –   Dynamic Storage Tiering
                                       –   Thin Provisioning
                                       –   Deep Mapping
                                       –   Portable Data Containers (PDC)
            Hardware


                                                How Symantec/Veritas Adds Value in your Oracle RAC Environment 15
Increase Operational Efficiency with
Storage Foundation Manager
                           • Key benefits:
                               – Raise admin productivity
                               – Reduce risk of errors
                           • Visibility
                               – Single-pane-of-glass management
                               – Identify application SF faults
                               – Comprehensive resource detail

                           • Control
                               – 250+ guided SF operation
                               – Reduces SF TCO
                               – Drive operational efficiency

                           • Mobility
                               – Simple, repeatable SF processes
                               – Disk Group Migration
                               – Volume Migration


                            How Symantec/Veritas Adds Value in your Oracle RAC Environment 16
DMP is Optimized Multi-Vendor
Multi-Pathing
• One interface for all your hosts & storage
  – Industry’s broadest Hardware Compatibility List

• Enterprise grade performance
  – Best in class throughput
  – Best in class failover
  – Best in class scalability

• Integrated with Storage Foundation
  – Top of cluster to array spindle certification
  – Trusted SCSI-3 PR & I/O Fencing

• Managed by Storage Foundation Manager
  – Simple datacenter wide path management


                                             How Symantec/Veritas Adds Value in your Oracle RAC Environment 17
DMP Enables Multi-Vendor Storage

• Ability to connect any storage to any host
  – Standard multi-pathing across on Unix, Linux and Windows
    servers
  – Full flexibility to storage teams
  – Full flexibility to server teams
• Enable competitive hardware pricing
• Enable ‘any vendor to any vendor’ online storage
  migrations
• Enable ‘any tier to any tier’ online migrations
• Consistent, enterprise grade, performance and availability
• Frees you from the mish-mash of multi-pathing solutions
  you would have to use if not using SF/DMP.
                                        How Symantec/Veritas Adds Value in your Oracle RAC Environment 18
You Don’t Have to Run “raw” for
Performance

                                               EXTENSIONS FOR ORACLE
                                                 DISK MANAGER (ODM)
         System Global Area

                                         • Match raw performance lb for lb
        ODM      Buffer Cache
                                         • Oracle & Symantec co-
                                           developed
                     File System
         I/O path                        • Eliminates redundant buffering
                     Buffer Cache
                                         • Eliminates thousands of file
          Disk
                                           descriptors
                                         • Single call for multiple I/O
                                           requests
Up to 30% faster than traditional file
             systems


                                            How Symantec/Veritas Adds Value in your Oracle RAC Environment 19
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 data buffering
  – 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
• With SFOR 5.1, ‘cached ODM’ feature has been added
  – Provides better performance for DW and hybrid workloads.


                                            How Symantec/Veritas Adds Value in your Oracle RAC Environment 20
File System vs. Raw Partitions


     BENEFITS OF RAW              BENEFITS OF FILE SYSTEM


                          • Performance (just like raw)
• Performance
                          • Easy file management
                          • Online storage growth (auto
                            extend)
                          • Online backups & BLIB
                            (integration with NetBackUp)
                          • Dynamic Storage Tiering
                          • Thin Provisioning
                          • Easy OS migrations (PDC)
                          • Storage pooling
                          How Symantec/Veritas Adds Value in your Oracle RAC Environment 21
Snapshot Technology –
Oracle Database FlashSnap
• Allows capturing of an online image of an actively changing database
• Database snapshot can be used on the same host as the production database, or on
  a secondary host that shares the same storage
• Snapshot storage can be different (e.g less expensive) from source DB storage
• Requires no root privileges to use
• Uses VxVM mirroring capabilities
• Typical ‘use cases’ are:
   –   Database Backup and Restore
   –   Decision-Support Analysis and Reporting
   –   Application Development and Testing
   –   Logical Error Recovery
• Snapshots can be online, instant, or offline
• Oracle RMAN can be used to create DB clones, but, unlike DBFlashSnap, it cannot
  incrementally refresh the cloned image – it always has to be totally recreated from
  ‘scratch’.
• If snapshots reside on PDC formatted DB/Volumes, then the cloned instance can be
  brought up on different OS platform – cannot do this if using Oracle RMAN

                                                 How Symantec/Veritas Adds Value in your Oracle RAC Environment 22
Dynamic Storage Tiering

• 2 key technologies in SF: Multi-Volume File Systems (MVFS) & Dynamic Storage Tiering
• 1 file system name space; N volumes; 1 to N storage tiers; M hardware vendors
• Sysadmin defines where to create files; when, why, and where to relocate files
• Files go where they should when they should automatically and transparently (to users, applications, and
  utilities)
• For Oracle DB environments, this is a natural fit when using partitioned tables (1:1 mapping between files and
  partitions) – can eliminate the need to manually ‘age out’ large tables to avoid performance problems!

                                                         /one_file_system

                               /sales                            /financial                          /development

                    /current            /forecast        /2005                /2004            /new_app          /history




                                                                 storage

                                                TIER 1                                TIER 2
       Comprising of High End Array(s) such                                                      Comprising of Lower End Array(s) or
             as EMC DMX, IBM Shark, etc.            Mirrored                     RAID5           devices such as Clariion, JBOD, etc.




                                                                         How Symantec/Veritas Adds Value in your Oracle RAC Environment 23
Extent Balanced File System (EBFS)
feature of MVFS

• Balance file extents among                                   File File
                                                                    Extents
  component volumes within a tier
• Chunk-size is configurable; can be
  specified in placement policy
• Individual storage tiers may have
  different chunk-size from others         V1       V2                                V3

• Automatic rebalancing as volumes are            TierX

  added or dropped
• So, does what ASM does, but as integral part of the
  complete SFORA/SFRAC stack, and with much more
  flexibility!
• So, if you want to emulate ASM, no problem!


                                    How Symantec/Veritas Adds Value in your Oracle RAC Environment 24
What is Thin Provisioning?
                                                                            Storage Optimization


 Traditional Options            Thin Storage

                               Data in file system             • Advantages
                                                                    – High utilization
                                                                    – Efficient operations

  Provision for growth
       • Utilization low                                       • Challenges
   • One provisioning event
                                                                    – Getting thin
                                  Host volume
                                                                    – Staying thin


                                                               • Requirement
                                                                    – Thin-friendly
  Provision as needed                                                 host stack
       • Utilization high      Dedicated in array
  • Many provisioning events


                                      How Symantec/Veritas Adds Value in your Oracle RAC Environment 25
                                                                                                      25
Optimize Thin Storage With Storage
Foundation                                                                         Storage Optimization

Benefits:
                                                                             Optimized Thin
 • Get thin and reclaim unused space as you migrate –                           Storage
   save huge on storage costs by ‘over provisioning’
 • Ensure all your hosts are thin friendly
 • Keep thin storage thin over time
 • SF is the only stack that can get you thin and keep you
   thin, because of the intimate integration between the VM
   and the FS.
                                                                             STD                THIN
Solutions:
 Thick to Thin Migration with SF SmartMoveTM
 • Industry’s only solution to reclaim unused space online
 • Works with any thin storage, from any vendor
 • Cross-platform: Unix, Linux and Windows
 Keep thin storage thin with the right host stack
 • VxFS - Cross platform thin friendly file system
 • Online Thin Reclamation Ready in 5.0 MP3
 • For Oracle, Autoextend must be in use; With Oracle 10g
   and later, files can be dynamically shrunk online.
                                             How Symantec/Veritas Adds Value in your Oracle RAC Environment 26
Symantec/Veritas – Oracle:
Single Instance
High Availability




           How Symantec/Veritas Adds Value in your Oracle RAC Environment 27
Storage Foundation for Oracle (SFOR -HA)

                                       • When you need to keep your Oracle
                                         Single Instance DBs Highly Available
                Oracle                   (HA), you move from SFOR to SFOR-HA
                                       • Continue to use same infrastructure
                                         software across enterprise datacenter
                                          –   Supports many brands and versions of Operating
                                              Systems, storage arrays, and databases
              RAC Extensins
                                          –   Standardize environment to improve operational
           Veritas Cluster Server
                                              efficiencies
                                       • Based on core VERITAS technologies
        Database Accelerator (ODM)
                                          –   VCS 15+ years of customer success
        VxFS or Cluster File System       –   VM/FS 15+ years of customer successes
                                          –   Robust features & stability
      VxVM or Cluster Volume Manager
                                          –   Reuse VERITAS knowledge
                                       • Storage Foundation Manager (SFM)
                                       • Hundreds of successful customer installs
                                         in production Oracle environments
             Hardware


                                                How Symantec/Veritas Adds Value in your Oracle RAC Environment 28
SFOR-HA
Benefits in a Oracle environment
                                       •   Enterprise-ready VxFS or Cluster File
                                           System
                Oracle                      –   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

             RAC Extensions
                                       •   Enterprise-ready VxVM or Cluster Volume
        Veritas Cluster Server             Manager
                                            –   Dynamic Multi-Pathing
        Database Accelerator (ODM)          –   Snapshot technology for off-host processing
                                            –   100s of tested OS/array combinations
        VxFS or Cluster File System
                                            –   Granular I/O separation/tuning capabilities
                                            –   Simplified device naming and mgmt
      VxVM or Cluster Volume Manager
                                            –   Dynamic Storage Tiering
                                            –   Deep Mapping
                                            –   Same look and feel as VxVM



             Hardware


                                                How Symantec/Veritas Adds Value in your Oracle RAC Environment 29
SFOR-HA - Veritas Cluster Server
Benefits in a Oracle environment
                                    • Enterprise-ready Cluster Server
                                        –   Robust I/O Fencing
               Oracle                   –   Dozens of pre-built agents for enterprise applications,
                                            well known adopted clustering API
                                        –   Support for many Disaster Recovery configurations
                                             •   Campus Clusters
                                             •   Remote DR sites
                                                   –   GCO
            RAC Extensions                         –   VVR
                                                   –   Fire Drill
         Veritas Cluster Server
                                             •   Heterogeneous replication support
       Database Accelerator (ODM)   • Integrated with O/S kernel
           Cluster File System      • No OS, or Storage Vendor, or Oracle
        Cluster Volume Manager
                                      based solution can begin to cover the total
                                      heterogeneous IT infrastructure
                                      environments we fully support!


            Hardware


                                                 How Symantec/Veritas Adds Value in your Oracle RAC Environment 30
Standardization: VCS Support for
Apps & DBs – way beyond Oracle!
 Databases                  Version     Solaris   AIX        HP/UX           Windows            Linux (RH)
 Oracle               8i-9i,10g , 11g
 DB2                  7.1-8.2(+EEE)                            N/A                                 (+SLES)
 Sybase               11.x-12.5 , 15
 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 , .10
 Oracle App Srvr      9.0.4-10.1.2
 PeopleSoft           8.1, 8.4, 8.8
 SAP                  4.6, 4.7, 6.2
                       NetWeaver
 Siebel               6.x-7.7, 7.8
 Sun ONE (Sun JES)    5.0-6.1                     N/A          N/A               N/A               N/A
 Tuxedo               6.5-8.1 , 9.0
 WebLogic Server      6.1-8.x
 WebSphere App Srvr   5.x, 6.0                                 N/A
 WebSphere MQ         5.3
                                                   How Symantec/Veritas Adds Value in your Oracle RAC Environment 31
Multi-Data Center Availability with
VCS – way beyond Oracle!



                 Cluster            Cluster
                Heartbeats         Heartbeats

                                       •
                   • Wide-area protection Metropolitan-area protection
                   • Two VCS Clusters • Single stretch VCS Cluster
                      – Global synchronization Data Loss (RPO=0)
                                        • Zero
                   • Push-button failover/failback replication OR
                                            – Sync
                                                      VxVM Mirroring
                                        • Fully
                     Asynchronous Replication
                  Sync                                   automated failover



     Stretch Cluster
        Local HA             Veritas Cluster Server                      Global Cluster

                                                How Symantec/Veritas Adds Value in your Oracle RAC Environment 32
VERITAS Volume Replicator - for Oracle and
everything else! - Replication over IP Networks

                       RLink                                                                        RLink
                                                   IP Network
  Application                                                                                                     Application

Volume Manager                 • Replication Links (Rlinks):                                                   Volume Manager
Volume Manager
   Volume                          –   Support up to 32                                                            Volume
  Replicator                                                                                                      Replicator
                                   –   Configure each for synchronous or asynchronous
                                       replication
                               • Storage Replicator Log (SRL)
                                   –   Tracks writes in specific order to guarantee write-order
                                       fidelity
                               • Replicated Volume Group (RVG)
                                   –   Pick which data to replicate
                 SRL           • No Distance Limitations                                                    SRL
           RVG                 • Initialization Options
                                   –   Tape-based, Over-the-Wire, Mirroring
                               • Host Impact = Volume Manager + 2%
                               • No application performance impact in asynch



                                                                How Symantec/Veritas Adds Value in your Oracle RAC Environment 33
Will my HA/DR plan work when I need
it?

 • Configuration drift degrades protection
   – Storage changes
       • E.g. new volumes, mount points
   – Expired demo licenses
   – OS and App patch versions


                                                             78%
   – Hidden App corruption
   – etc., etc., etc.
                                                    NEVER TESTED DR PLAN

                                                 • Why not?
                                                      –    Very Disruptive
                                                      –    Might Not Work
                                                      –    Lack Of Resources
                                                      –    How?
                                          How Symantec/Veritas Adds Value in your Oracle RAC Environment 34
Physical Fire Drill in Action
                                                          Initiate Snapshot
                                                           Mount Fire
                                                               Application
                                                          Test Reset Drill
  Primary Site                 Secondary Site         • Fire Drill is a cloned VCS
                                                        Service Group modified to use
                                                        snapshot storage
    Prod SG                       FD SG               • Fire Drill:
                   VCS                                      – Creates snapshot
                                                            – Configures snapshot
                                                            – Imports snapshot
                                                            – Mounts snapshot
                                                            – Starts SG on the mount
                                                            – Requires SF 5.0
                                                      • Any errors are logged by VCS
                 Replication                          • Fire Drill SGs are isolated
                                                        from production SGs
                                            Storage
                                           Snapshot         – E.g. No DNS update

                                                      How Symantec/Veritas Adds Value in your Oracle RAC Environment 35
Symantec/Veritas – Oracle:
RAC




           How Symantec/Veritas Adds Value in your Oracle RAC Environment 36
Storage Foundation for Oracle RAC
(SFRAC)
                                   •   Use same infrastructure software across
                                       enterprise datacenter
          Oracle RAC                    –   Supports many brands and versions of Operating Systems,
                                            storage arrays, and databases
                                        – Standardize environment to improve operational
                                            efficiencies


                                   •   Based on core VERITAS technologies
           RAC Extensions
                                        –   VCS 15+ years of customer success
                                        –   SF 15+ years of customers success
            Cluster Server
                                        –   Robust features & stability
      Database Accelerator (ODM)        –   Reuse VERITAS knowledge

          Cluster File System      •   Storage Foundation Manager (SFM)
       Cluster Volume Manager

                                   •   Specific enhancements for the RAC
                                       environment

                                   •   Hundreds of successful installs and
           Hardware                    production customers in Oracle RAC
                                       environments
                                              How Symantec/Veritas Adds Value in your Oracle RAC Environment 37
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
                                            •   Data files, logs, binaries, OS, app data, etc...
            RAC Extensions             –   Same look and feel as VxFS

             Cluster Server
                                    • Enterprise-ready Cluster Volume
       Database Accelerator (ODM)     Manager
           Cluster File System
                                       –   Dynamic Multi-Pathing
                                       –   Snapshot technology for off-host processing
        Cluster Volume Manager         –   100s of tested OS/array combinations
                                       –   Granular I/O separation/tuning capabilities
                                       –   Simplified device naming and mgmt
                                       –   Dynamic Storage Tiering
                                       –   Thin Provisioning
            Hardware                   –   Deep Mapping
                                       –   Same look and feel as VxVM

                                           How Symantec/Veritas Adds Value in your Oracle RAC Environment 38
SFRAC - Veritas Cluster Server
Benefits in a Oracle environment
                                    • Enterprise-ready Cluster Server
                                       –   Robust I/O Fencing
           Oracle RAC
                                       –   Dozens of pre-built agents for enterprise
                                           applications, well known adopted clustering API
                                       –   Support for many Disaster Recovery configurations
                                            •   Campus Clusters
                                            •   Remote DR sites
            RAC Extensions
                                            •   Heterogeneous replication support
             Cluster Server

       Database Accelerator (ODM)
                                    • Specific extensions for Oracle RAC
                                       –   Cluster membership coordinated across all software
           Cluster File System             tiers - Robust I/O Fencing to handle Split-Brain
                                       –   Robust performance and availability for cluster
        Cluster Volume Manager
                                           interconnects – hardware independent solution!


                                    • Integrated with O/S kernel

            Hardware


                                           How Symantec/Veritas Adds Value in your Oracle RAC Environment 39
Storage Foundation – a complete solution!


                     Stripe      Mirror          Quick I/O               ODM           Online Defrag
   Performance



                                                                                                              Multi-path




                    Snapshot    Checkpoint                               Copy            Clustered           Change Log
                                                Replicate
                                                                                        File System
   Protection
   Administration




                      Grow     Migrate Arrays   Tier Storage      Migrate OS           Concatenate              Slice


                                                                  Unix     Linux



                                                $$$ $$      $

                                                                How Symantec/Veritas Adds Value in your Oracle RAC Environment 40
Value Add of
Symantec/Veritas
Stack with/without
ASM

Oracle 10gR2/11gR1



     How Symantec/Veritas Adds Value in your Oracle RAC Environment 41
 Challenges of running ASM in
 Oracle DB Environments (10gR2/11gR1)
• Availability
   –   ASM is another Oracle instance to manage on each server
   –   No multi-pathing
   –   Doing storage array migrations on-line is cumbersome
   –   Local Failover – Oracle Clusterware available, but not strongly recommended (see
       http://www.oracle.com/technology/products/database/clusterware/pdf/SI_DB_Failover_11g.pdf )
   –   Disaster Recovery – requires storage vendor software and no ‘Fire Drill’ capability
• Scalability
   –   No granular control of database objects
• Performance
   –   No granular control of database objects
   –   No multi-pathing capability for HBA load balancing
   –   No awareness of physical disk (see next slide)
   –   For DSS/DW workloads – breaks read ahead algorithm of storage array (see later slide)
• Manageability
   –   ASM manages only a subset of oracle ‘files’. How do you manage everything else?
   –   ‘File’ management is very limited and coarse – can only add/remove ‘disks’
   –   Storage management is more complex since ASM requires Oracle level striping, even if storage array
       striping is already in play
   –   ASM does not have Dynamic Storage Tiering
   –   ASM does not have Thin Provisioning
   –   ASM requires RMAN for backup/cloning or 3rd party replication solution
                                                         How Symantec/Veritas Adds Value in your Oracle RAC Environment 42
 ASM Disk vs Real Physical Disk
• Oracle ‘disk’ = unix device
   – e.g. /dev/rdsk/ct1t0d0
• Real Physical Disk:
   – Maps physically, for example, to an EMC 4-member meta-volume (Raid-1 = mirrored), which
     means it is touching 8 different Partitions of 8 different physical disks (146GB capacity) utilizing
     stripe size of 960KB, inside the storage array.
• SF includes deep mapping and does not mandate host level striping – much more granular
  in allowing corrective actions when an I/O issue has been identified.
                                                                                                      And what about
                                                                                                             Host
   member 1   member 2   member 3
     m1         m1         m1
                                    member 4   member 1   member 2      member 3      member 4      i/o path info – HBA,
                                                                                                          3
                                                                                                    memberApplication
                                      m1         m2         m2            m2            m2
                                                                                                           Switch,
      A1        A2         A3
                                                                                                      Channel director,
                                                                                                           Database
                                       A4        A1          A2            A3            A4            A2
                           B3
                                                                                                            etc.?
      B1        B2                                           B2            B3            B4             B2
                                       B4        B1
      C1        C2         C23                                                                          C2
                                       C4        C1         C2             C3            C4                   Unix Device
      D1        D2         D3                                              D3            D4             D2
                                       D4        D1         D2                                                      HBA
      E1        E2         E3                                E2            E3            E4             E2
                                       E4        E1                                                          In Switch Port
      F1        F2         F3                                F2            F3            F4             F2
                                       F4        F1                                                       Out Switch Port
      G1        G2         G3                               G2             G3            G4             G2
                                       G4        G1
                                                                                                         Channel Director
      H1        H2         H3                                              H3            H4             H2
                                       H4        H1         H2
                            I3                                              I3           I4             I2   Storage LUN
      I1         I2                    I4         I1         I2
                                                                                                     Disk Partition/Spindle
                                                                                                   /xlrpl/oravl03
    Disk 1    Disk 2     Disk 3      Disk 4     Disk 5     Disk 6        Disk 7         Disk 8
                                                              How Symantec/Veritas Adds Value in your Oracle RAC Environment 43
ASM Disk vs Real Physical Disk

 • What about sharing individual disks across multiple servers?
    – In this example, there are 9 LUNs per 146GB physical disk – are they all
      assigned to a single server, or assigned across multiple servers? If
      assigned across multiple servers, what is the potential for inter-server disk
      contention?
 • The point we are making here is that Enterprise Storage (e.g. EMC,
   Hitachi, IBM, etc.) adds layers of complexity that ASM is not aware of.




                                              How Symantec/Veritas Adds Value in your Oracle RAC Environment 44
Oracle 10g ASM – 1MB Stripe Size Required
Example of ‘BAD’ 10g performance for DSS/DW




                   This is ‘Query 1’ of TPC-D
                   benchmark suite
                   • Data resides on EMC Symmetrix
                   • When table is on raw, getting
                     2,000 tracks pre-fetched per second
                   •When table is on ASM, getting just
                     500 tracks pre-fetched per second
                   •ASM striping ‘breaks’ pre-fetch!
                   •SF can be ‘tuned’ for OLTP and/or
                    DSS/DW applications – no built in
                    bias or pre-disposition for OLTP,
                    as we see here with Oracle ASM.




                                        How Symantec/Veritas Adds Value in your Oracle RAC Environment 45
   Summary of Functionality Analysis
   (10gR2/11gR1)
                                                                 ASM with                       SFORA/SFRAC
                                                   ASM Alone
                                                               SFORA/SFRAC                         Alone
Availability
ASM Instance not needed                                N                   N                                 Y

Adds multi-pathing                                     N                   Y                                 Y

Storage array migrations easily done on-line           N                   Y                                 Y

Local Failover - VCS                                   N                   Y                                 Y

Disaster Recovery w/o Storage Vendor SW                N                   Y                                 Y


Scalability

Have granular control of database objects              N                   N                                 Y

Multi-pathing capability increased IO throughput       N                   Y                                 Y

Performance
Have granular control of database objects              N                   N                                 Y

Multi-pathing capability for HBA load balancing        N                   Y                                 Y

Awareness/visibility of physical disk                  N                   N                                 Y

Manageability
Entire infra-structure managed by SFORA/SFRAC          N        Y* (Except for ASM Disks)                    Y

‘File’ management granular/full featured               N                   N                                 Y

Host level striping optional                           N                   N                                 Y

Dynamic Storage Tiering                                N                   N                                 Y

                                                               How Symantec/Veritas Adds Value in your Oracle RAC Environment 46
    ASMLib – What is it; Benefits; Platform
    Support - Exists on Linux Only!
•    What is ASMLIB?
         –   a storage management API to simplify and optimize OS to database I/O interface
         –   OS kernel integration
•    ASMLib Benefits/Problems Solved
         –   persistent device discovery, mapping and permissions
                   •   Disk names are determined by discovery order and can change from boot to boot
                   •   Standard name for a disk is not necessarily the same on every node
         –   I/O optimization and efficiency
                   •   Without ASMLib, every oracle process has to open all ASM disks which results in potentially a huge number of file descriptors
                   •   Aggregation of multiple I/O calls
                   •   Asynchronous I/O interface
         –   I/O priority and caching hints
                   •   Differentiate between redo log access and data/index access
         –   Data integrity
•    ASMLib Platform Support
         –   Linux – yes
         –   Solaris, AIX, HP-UX – no and not on the horizon
•    It is reasonable to assume that the Benefits/Problems solved by ASMLib apply only to Linux –
     what if you are running Oracle DB on AIX, HP-UX, or Solaris – who solves your problems?
     Answer: SFORA/SFORA-HA/SFRAC! Not to mention – we solve them on Linux as well, and
     we will soon be pointing out many shortcomings of deploying Oracle on Linux without the SF
     stack.
•    One other point – there seems to be mixed opinions regarding using ASMLib on Linux across
     the Oracle/Linux customer base. ASMLib does require OS kernel integration which leads to
     administrative complications!
                                                                             How Symantec/Veritas Adds Value in your Oracle RAC Environment 47
 Life with and without SFRAC on UNIX …
 (10gR2/11gR1)
                                                                                                             Solaris with
 Deploy RAC with ---------------------->   SFRAC             AIX with ASM           HP-UX with ASM           ASM
                                           all included in
 infrastructure components                 SFRAC             ASM                    ASM                      ASM


                                                             RAW                    RAW                      RAW


                                                             LVM                    HP-LVM                   SVM
                                                                                    JFS (VxFS) [HP
                                                             jfs2                   OEMs]                    UFS


                                                             gpfs                   CFS [HP OEMs]            QFS


                                                             etherchannel           APA                      IPMP or Trunking
                                                                                    HP SecurePath or
                                                             MPIO                   HP Native MP             MPxIO
                                                             GLVM or 3rd party
                                                             replication            3rd party replication    3rd party replication


                                                             PowerHA                Serviceguard             SunCluster
The above table makes it very clear that deploying with SFRAC greatly simplifies the Oracle RAC IT infrastructure,
and contributes greatly towards standardization. Furthermore, the Dynamic Storage Tiering (DST) and Thin
Provisioning capabilities offer great potential for significant storage savings across the entire enterprise.
The next slide gets more granular on this topic.
                                                                    How Symantec/Veritas Adds Value in your Oracle RAC Environment 48
  Life with and without SFRAC on Unix …
  (10gR2/11gR1)
                                       SFRAC (platform
FUNCTIONALITY                          independent)                          AIX with ASM             HP-UX with ASM            Solaris with ASM
Database storage                       CFS                                   ASM                      ASM                       ASM
OCR/Vote Disk                          CFS                                   RAW                      RAW                       RAW
Oracle logs, trace files, binaries     VxFS/CFS                              Jfs2 or gpfs             JFS                       SVM-UFS/QFS
Non Oracle files                       VxFS/CFS                              Jfs2 or gpfs             JFS                       SVM-UFS/QFS
                                                                                                      APA (Auto-Port
HA for RAC private interconnect        VCS Privnic                           etherchannel             Aggregation)              IPMP or Trunking
I/O Fencing                            VCS SCSI -3 PGR                       Oracle vote disk         Oracle vote disk          Oracle vote disk
                                                                                                      HP SecurePath/HP Native
Multi-pathing                          DMP                                   MPIO                     MP                        MPxIO
                                                                             ASM_DISK_STRIN           ASM_DISK_STRIN            ASM_DISK_STRIN
Device Discovery                       CVM                                   G                        G                         G
File Descriptor Management             ODM                                   ASM                      ASM                       ASM
DB Snapshots                           DBFlashSnap                           RMAN or 3rd Party        RMAN or 3rd Party         RMAN or 3rd Party
Dynamic Storage Tiering                included                              N/A                      N/A                       N/A
Thin Provisioning                      Included                              Limited                  Limited                   Limited
Tune for DSS/DW workloads              Yes                                   No                       No                        No
                                                                                                      Serviceguard or
HA for Single Instance Oracle          VCS Oracle agent                      PowerHA or CRS*          CRS*                      SunCluster or CRS*
                                                                                                      Serviceguard or
HA for Non Oracle                      VCS agents                            PowerHA or CRS*          CRS*                      SunCluster or CRS*
Online Storage Array Migrations agents for single instance Oracle failover or 3 Hard Apps. Failover – see
 *Oracle will not support CRS script                                           rd party
                                     Easy                                                               Hard                    Hard
  http://www.oracle.com/technology/products/database/clusterware/pdf/SI_DB_Failover_11g.pdf and
Host Level Striping                    Discretionary                           Mandatory                Mandatory
  http://www.oracle.com/technology/products/database/clusterware/pdf/TWP-Oracle-Clusterware-3rd-party.pdf                       Mandatory
Granular Control of DB objects         Yes                                                          Adds                    RAC
                                                                             No How Symantec/VeritasNo Value in your OracleNo Environment 49
Life with and without SFCFS Linux RAC…
(10gR2/11gR1)
  Deploy RAC with ---------------------->   SFCFS Linux RAC               ASM - no CFS       ASM - OCFS2             ASM- GFS
                                            all included in SFCFS Linux
  infrastructure components                 RAC                           ASM                ASM                     ASM

                                                                          RAW                                        RAW

                                                                          LVM2               LVM2                    LVM2

                                                                          ext3               ext3                    ext3

                                                                          Device Mapper      Device Mapper           Device Mapper
                                                                          3rd party
                                                                          replication        3rd party replication   3rd party replication

                                                                          RH Cluster         RH Cluster              RH Cluster

                                                                                             OCFS2                   GFS


The above table makes it very clear that deploying with SFCFS Linux RAC greatly simplifies the Oracle RAC IT
infrastructure, and contributes significantly towards standardization. Furthermore, the Dynamic Storage Tiering
(DST) and Thin Provisioning capabilities offer great potential for significant storage savings across the entire
enterprise.
The next slide gets more granular on this topic.


                                                                          How Symantec/Veritas Adds Value in your Oracle RAC Environment 50
Life with and without SFCFS Linux RAC…
(10gR2/11gR1)
FUNCTIONALITY                             SF CFS Linux RAC                    ASM - no CFS           ASM - OCFS2             ASM- GFS
Database storage                          CFS                                 ASM                    ASM                     ASM
OCR/Vote Disk                             CVM                                 RAW                    OCFS2                   RAW
Oracle logs, trace files, binaries        VxFS/CFS                            ext3                   ext3 or OCFS2           ext3 or GFS
Non Oracle files                          VxFS/CFS                            ext3                   ext3 or OCFS2           ext3 or GFS
HA for RAC private interconnect           NIC Bonding                         NIC Bonding            NIC Bonding             NIC Bonding
I/O Fencing                               N/A                                 Oracle vote disk       Oracle vote disk        Oracle vote disk
Multi-pathing                             DMP                                 Device Mapper          Device Mapper           Device Mapper
                                                                              ASM_DISK_STRIN         ASM_DISK_STRIN
Device Discovery                          CVM                                 G                      G                       ASM_DISK_STRING
                                                                              ASM and/or
File Descriptor Management                ODM                                 ASMLib                 ASM and/or ASMLib       ASM and/or ASMLib
DB Snapshots                              DBFlashSnap                         RMAN or 3rd Party      RMAN or 3rd Party       RMAN or 3rd Party
Dynamic Storage Tiering                   included                            N/A                    N/A                     N/A
Thin Provisioning                         Included                            Limited                Limited                 Limited
Tune for DSS/DW workloads                 Yes                                 No                     No                      No
                                                                              RH Cluster or
HA for Single Instance Oracle             VCS Oracle agent                    CRS*                   RH Cluster or CRS*      RH Cluster or CRS*
                                                                              RH Cluster or
HA for Non Oracle                         VCS agents                          CRS*                   RH Cluster or CRS*      RH Cluster or CRS*
Online Storage Array Migrations          Easy                                 Hard                   Hard                      Hard
  *Oracle will not support CRS script agents for single instance Oracle failover or 3rd party Apps. Failover – see
  http://www.oracle.com/technology/products/database/clusterware/pdf/SI_DB_Failover_11g.pdf and
Host Level Striping                      Discretionary                        Mandatory              Mandatory                 Mandatory
  http://www.oracle.com/technology/products/database/clusterware/pdf/TWP-Oracle-Clusterware-3rd-party.pdf
Granular Control of DB objects           Yes                                  No How Symantec/VeritasNo                        No
                                                                                                       Adds Value in your Oracle RAC Environment 51
Value Add of
Symantec/Veritas
Stack with/without
ASM

Oracle 11gR2



     How Symantec/Veritas Adds Value in your Oracle RAC Environment 52
 Challenges of running ASM in
 Oracle DB Environments (11gR2)
• Availability
   –   ASM is another Oracle instance to manage on each server
   –   No multi-pathing
   –   Doing storage array migrations on-line is cumbersome
   –   Local Failover – need RAC One Node ($10,000 per CPU uplift) – see next 2 slides
   –   Disaster Recovery – requires storage vendor software and no ‘Fire Drill’ capability
• Scalability
   –   No granular control of database objects
• Performance
   –   No granular control of database objects
   –   No multi-pathing capability for HBA load balancing
   –   No awareness of physical disk
• Manageability
   –   ASM manages only a subset of oracle ‘files’. How do you manage everything else?
        •   ACFS for Linux (Separate storage pool from ASM disks) – see subsequent slides for details about ACFS
        •   ACFS not yet available for Solaris, HP-UX, and AIX
   –   ‘File’ management is very limited and coarse – can only add/remove ‘disks’
   –   Storage management is more complex since ASM requires Oracle level striping, even if storage array
       striping is already in play
   –   ASM does not have Dynamic Storage Tiering
   –   ASM does not have Thin Provisioning
   –   ASM requires RMAN for backup/cloning or 3rd party replication solution
                                                                          How Symantec/Veritas Adds Value in your Oracle RAC Environment 53
Oracle RAC One Node
• Oracle is positioning RAC One Node as ‘Better Virtualization for Databases’ than VMs
    –   Oracle states “Virtual servers always suffer a performance handicap vs. physical hardware. This is
        because CPU instructions must be translated in a virtual server, adding to CPU overhead.”
    –   What Oracle does not state is that Virtual servers have the potential to reduce Oracle DBMS license
        revenues 
    –   Can work with Oracle VM (OVM) 
• Integrated with Oracle Clusterware which monitors the health of the database and ensures database service
  availability. In the event of a failure, Oracle RAC One Node will detect the failure, and either restart the failed
  database, or fail it over to another server. Comparable to other 3rd-party cold failover solutions from
  vendors like HP, IBM, and Symantec, Oracle RAC One Node cold failover ensures unattended recovery
  from failures, with full services restored within 5 to 30 minutes. It is ideal for those applications that can
  tolerate short periods of downtime, but cannot tolerate waiting for an administrator to detect the problem and
  restore services.
• In contrast, the type of failures VMs can detect and recover from is somewhat limited. They typically only
  monitor the health of the VM and the operating system running within. Should the database instance crash or
  hang, they would not detect the failure and would not restart the VM without administrator intervention.
• Customers who need sub-minute recovery should deploy their databases on multi-node Oracle Real
  Application Clusters (RAC). Oracle RAC provides the best possible availability and fastest recovery from
  failures.
• The Omotion feature provides the same load balancing benefits of VMs by allowing a migration of a database
  from a busy server to a server with spare capacity. Omotion leverages the ability of Oracle Real Application
  Clusters to simultaneously run multiple instances servicing a single database.


                                                                             Oracle 11gR2 Competitive Update       54
Oracle RAC One Node – Key takeaways…
• This feature is being positioned as a way to keep Oracle DBMS from being deployed
  in Virtual Server environments.
• For unplanned outages, it is the single instance HA solution
   – Our SF HA CFS solution avoids the need for RAC altogether
   – Cost of RAC One Node vs RAC vs Single Instance:
       • Licensing costs (list price per CPU):
           – Single instance Enterprise Edition = $47,500
           – RAC One Node – add $10,000          = $57,500
           – RAC              - add $28,000      = $75,500
       • ‘RAC One Node’ uplift is 36% of the RAC uplift
   – For 10gR2/11gR1 Oracle does not support scripts written by customer to do Single Instance
     HA – is this how Oracle will now ‘support’ Single Instance HA?
• For planned migrations or dynamic load balancing, Omotion is used to provide
  continuous uptime to the application
   – With 10gR2/11gR1, same could be accomplished using ‘services’ and having ‘idle’ instances
     ready to go or ‘manually’ starting the new instance. Is this an implicit admission that ‘idle’
     instances have significant overhead?
• RAC One Node not available with Oracle ‘Standard Edition’

                                                                Oracle 11gR2 Competitive Update   55
ASM Cluster File System (ACFS)
Overview of Oracle ACFS
• ACFS is a multi-platform, scalable file system, and storage management technology that
  extends ASM functionality to support customer files maintained outside of the Oracle Database.
  ACFS supports many database and application files, including executables, database trace files,
  database alert logs, application reports, BFILEs, and configuration files. Other supported files are
  video, audio, text, images, engineering drawings, and other general-purpose application file data.
• Regarding reference to multi-platform, ACFS is included in initial GA release of 11gR2 for Linux
  (9/1/2009), but is not included in the Solaris Sparc GA release (11/9/2009). AIX and HP-UX
  have not gone GA as of 11/23/2009. No dates have yet been provided by Oracle as to when
  ACFS will be available on platforms other than Linux.
Notes:
• ASM is the preferred storage manager for all database files. It has been specifically designed and
  optimized to provide the best performance for database file types.
• ACFS is the preferred file manager for non-database files. It is optimized for general purpose files.
• ACFS does not support any file that can be directly stored in ASM.
  Not supported means Oracle Support Services will not take calls and development will not fix bugs
  associated with storing unsupported file types in ACFS.
• ACFS does not support files for the Oracle grid infrastructure home. (RAC and ASM binaries, etc.)
• Read only Snapshots – limit of 64
• ASM and ACFS require two separate storage pools
                                                                       Oracle 11gR2 Competitive Update   56
ASM Cluster File System (ACFS) -
Architecture

       Notice 2 separate storage pools for Application data
       and DB data




                                            Oracle 11gR2 Competitive Update   57
   Summary of Functionality Analysis
   (11gR2)
                                                                                        ASM with                          SFORA/SFRAC
                                                       ASM Alone
                                                                                      SFORA/SFRAC                            Alone
Availability
ASM Instance not needed                                           N                                 N                                 Y

Adds multi-pathing                                                N                                 Y                                 Y

Storage array migrations easily done on-line                      N                                 Y                                 Y

Local Failover                                       Y (Requires RAC One Node)                      Y                                 Y

Disaster Recovery w/o Storage Vendor SW                           N                                 Y                                 Y


Scalability

Have granular control of database objects                         N                                 N                                 Y

Multi-pathing capability increased IO throughput                  N                                 Y                                 Y

Performance
Have granular control of database objects                         N                                 N                                 Y

Multi-pathing capability for HBA load balancing                   N                                 Y                                 Y

Awareness/visibility of physical disk                             N                                 N                                 Y

Manageability
Entire infra-structure managed by SFORA/SFRAC      N (ACFS available only on Linux)      Y* (Except for ASM Disks)                    Y

‘File’ management granular/full featured                          N                                 N                                 Y

Host level striping optional                                      N                                 N                                 Y

Dynamic Storage Tiering                                           N                                 N                                 Y

                                                                                      How Symantec/Veritas Adds Value in your Oracle RAC Environment 58
  Life with and without SFRAC on
  UNIX/Linux … (11gR2)
Deploy RAC with -----------------                                    HP-UX with            Solaris with         Linux with
>                                   SFRAC          AIX with ASM      ASM                   ASM                  ASM
                                    all included
infrastructure components           in SFRAC       ASM               ASM                   ASM                  ASM


                                                   LVM               HP-LVM                SVM                  LVM

                                                                     JFS (VxFS)
                                                   jfs2              [HP OEMs]             UFS                  ext3


                                                   gpfs              CFS [HP OEMs]         QFS                  ACFS

                                                                                           IPMP or
                                                   etherchannel      APA                   Trunking             NIC bonding
                                                                     HP SecurePath
                                                                     or HP Native
                                                   MPIO              MP                    MPxIO                Device Mapper
                                                   GLVM or 3rd
                                                   party             3rd party             3rd party            3rd party
                                                   replication       replication           replication          replication
                                                                                                                RH Cluster or
                                                   PowerHA           Serviceguard          SunCluster           CRS
The above table makes it very clear that deploying with SFRAC greatly simplifies the Oracle RAC IT infrastructure,
and contributes greatly towards standardization. Furthermore, the Dynamic Storage Tiering (DST) and Thin
Provisioning capabilities offer great potential for significant storage savings across the entire enterprise.
The next slide gets more granular on this topic.
                                                                  How Symantec/Veritas Adds Value in your Oracle RAC Environment 59
   Life with and without SFRAC on Unix/Linux
   … (11gR2)
                                                                                                                      Linux with
                                     SFRAC (platform                         HP-UX with           Solaris with        ASM
FUNCTIONALITY                        independent)       AIX with ASM         ASM                  ASM
Database storage                     CFS                ASM                  ASM                  ASM                 ASM

OCR/Vote Disk                        CFS                ASM                  ASM                  ASM                 ASM

Oracle logs, trace files, binaries   VxFS/CFS           Jfs2 or gpfs         JFS                  SVM-UFS/QFS         ext3 or ACFS

Non Oracle files                     VxFS/CFS           Jfs2 or gpfs         JFS                  SVM-UFS/QFS         Ext3 or ACFS

                                                                             APA (Auto-Port
HA for RAC private interconnect      VCS Privnic        etherchannel         Aggregation)         IPMP or Trunking    NIC bonding

I/O Fencing                          VCS SCSI -3 PGR    Oracle vote disk     Oracle vote disk     Oracle vote disk    Oracle vote disk

                                                                             HP SecurePath/HP
Multi-pathing                        DMP                MPIO                 Native MP            MPxIO               Device Mapper
Device Discovery                     CVM                ASM_DISK_STRING      ASM_DISK_STRING      ASM_DISK_STRING     ASM_DISK_STRING

File Descriptor Management           ODM                ASM                  ASM                  ASM                 ASM

                                                        RMAN or 3rd          RMAN or 3rd          RMAN or 3rd         RMAN or 3rd
DB Snapshots                         DBFlashSnap        Party                Party                Party               Party

Dynamic Storage Tiering              included           N/A                  N/A                  N/A                 N/A

Thin Provisioning                    Included           Limited              Limited              Limited             Limited

Tune for DSS/DW workloads            Yes                Yes                  Yes                  Yes                 Yes

                                                        PowerHA or RAC       Serviceguard or      SunCluster or       SunCluster or
HA for Single Instance Oracle        VCS Oracle agent   One Node             RAC One Node         RAC One Node        RAC One Node

                                                                             Serviceguard or      SunCluster or       RH Cluster or
HA for Non Oracle                    VCS agents         PowerHA or CRS       CRS                  CRS                 CRS

Online Storage Array Migrations      Easy               Hard                 Hard                 Hard                Hard

Host Level Striping                  Discretionary      Mandatory            Mandatory            Mandatory           Mandatory
Granular Control of DB objects       Yes                No                   No                   No                    No
                                                                       How Symantec/Veritas Adds Value in your Oracle RAC Environment 60
ASM Alone


                   Stripe      Mirror           Quick I/O               ODM            Online Defrag
 Performance



                                                                                                             Multi-path
                                              No Quick I/O -
                                                 (Some
                                               customers                                                  No Multi-path
                                                               ASM does not use
                                               prefer QIO      ODM but does provide
                                                to ODM)        raw like performance
                                                                                      Table &
                                                                                      Index

                  Snapshot    Checkpoint                                Copy             Clustered          Change Log
                                               Replicate
                                                                                        File System
 Protection




                    No          No               No                   No                                     No
                  Snapshot   Checkpoint        Replicate             Copy                                 Change Log
 Administration




                     Grow    Migrate Arrays    Tier Storage      Migrate OS            Concatenate             Slice
                                No
                                                  No                                     No                     No
                               Migrate                           Unix     Linux
                                                Tiered                                Concatenate               Slice
                               Arrays
                                                Storage
                                               $$$ $$      $

                                                               How Symantec/Veritas Adds Value in your Oracle RAC Environment 61
ASM with Storage Foundation

                   Stripe      Mirror           Quick I/O               ODM            Online Defrag
 Performance



                                                                                                             Multi-path
                                              No Quick I/O -
                                                 (Some
                                               customers
                                                               ASM does not use
                                               Prefer QIO      ODM but does provide
                                                to ODM)        raw like performance
                                                                                      Table &
                                                                                      Index

                  Snapshot    Checkpoint                                Copy             Clustered          Change Log
                                               Replicate
                                                                                        File System
 Protection




                                No                                    No                                     No
                             Checkpoint                              Copy                                 Change Log
 Administration




                    Grow     Migrate Arrays    Tier Storage      Migrate OS            Concatenate             Slice

                                                  No
                                                Tiered           Unix     Linux
                                                Storage
                                               $$$ $$      $

                                                               How Symantec/Veritas Adds Value in your Oracle RAC Environment 62
SFOR/SFRAC Stand Alone – a complete
solution – no matter what version(s) of
Oracle you run!

                     Stripe      Mirror          Quick I/O               ODM           Online Defrag
   Performance



                                                                                                              Multi-path




                    Snapshot    Checkpoint                               Copy            Clustered           Change Log
                                                Replicate
                                                                                        File System
   Protection
   Administration




                      Grow     Migrate Arrays   Tier Storage      Migrate OS           Concatenate              Slice


                                                                  Unix     Linux



                                                $$$ $$      $

                                                                How Symantec/Veritas Adds Value in your Oracle RAC Environment 63
Considerations
Concerning
Oracle RAC




   How Symantec/Veritas Adds Value in your Oracle RAC Environment 64
Who decides whether or not to use RAC?

• Oracle?
• Application Vendor?
• Or…You?




                          How Symantec/Veritas Adds Value in your Oracle RAC Environment 65
ERP Applications and RAC

• SAP
    – 70,000 Oracle DB environments
    –       60 are Production RAC
• Oracle EBS (Enterprise Business Suite)?
• PeopleSoft?
• Siebel?




                                    How Symantec/Veritas Adds Value in your Oracle RAC Environment 66
 Considerations Concerning Oracle RAC

• Many organizations are now investing in Oracle RAC
     – ‘Business Case’ warrants the investment in this technology
            • Cost of downtime understood
            • Downtime will be reduce by going to RAC from single node or active/passive
              cluster
            • Opportunities for server consolidation and reducing number of DBs
            • Horizontal scalability on commodity priced hardware

• RAC provides availability and scalability
     – Availability is quickly realized … at the DB tier
            • Great gains in both planned and unplanned application downtime
            • What about at the application tier? – see next slide…
     – Scalability requires some effort and planning
            • Application needs to be architected for RAC
            • Requires detailed understanding of the application’s performance


                                                How Symantec/Veritas Adds Value in your Oracle RAC Environment 67
 Availability - Application architecture
 considerations when going to RAC
• General application tier considerations:
    – If JDBC ‘thin client’, will connection pooling work transparently? (will lose
      context of ‘in-flight’ xaction)
    – If JDBC ‘thick client’ and/or OCI clients, can use TAF (Transparent
      Application Failover) and preserve context of ‘in-flight’ xaction
    – Planning to use Fast Connection Failover [FCF] (can be used with thick or
      thin JDBC clients, OCI, and/or ODP.NET. )?
• TAF - What about specific applications?
    –   Siebel is certified for TAF
    –   SAP does not support TAF, except for BW (Business Warehouse)
    –   PeopleSoft works with TAF, but is not certified
    –   Oracle eBusiness Suites does not work with TAF
    –   What about your application?
    –   TAF, without application mods, makes transparent only ‘select’ statements.
        For insert, update, and delete, application has to have the intelligence to deal
        with that!



                                               How Symantec/Veritas Adds Value in your Oracle RAC Environment 68
Scalability – An Oracle RAC basic fact
regarding getting data
• For Single instance Oracle:
    – Look for data block in SGA
    – If not found, then get it from disk

• RAC makes for longer code path:
    – Look for data block in local SGA
    – If not found in local SGA, then, via cache fusion, check SGA of other
      node(s) and if found, transfer via cache fusion data block to local SGA
    – If not found in the SGA of other instance(s), then get it from disk




                                            How Symantec/Veritas Adds Value in your Oracle RAC Environment 69
Scalability - Application architecture
considerations when going to RAC
• Oracle DB tier considerations:
    – Assign transactions with similar data access characteristics to specific
      nodes, by partitioning users and applications.
    – Create data objects with parameters that enable more efficient access when
      globally shared.
    – Avoiding sequences as hotspots by creating node-specific staggered
      sequence ranges.
    – Reduce the number of rows-per-block (RPB) in order to reduce page
      contention.
    – Use as few indexes as possible to reduce intra-node pinging of index blocks.
    – Pre-allocate space by turning on dynamic space management.
    – Use reverse-key indexes to reduce index-page hotspots. This has the
      undesirable side-effect of eliminating the ability to use index-scans.
    – Design indexes such that the clustering factor is as close to the number of
      used blocks as is possible.

                                            How Symantec/Veritas Adds Value in your Oracle RAC Environment 70
To RAC or not to RAC?




                                                                                         COST
            Server Capacity
            Available Capacity




                                                                                         PERFORMANCE
   • Global Cache Service Consumes Resources
   • Performance per node can degrade with more nodes
   • Linear scalability generally infeasible (results vary based on app)

                                           How Symantec/Veritas Adds Value in your Oracle RAC Environment 71
Oracle RAC Case Study:
3 Nodes vs 1 Node

 Oct 2, Amdocs w/ Oracle RAC
 • 3 Node RAC cluster
 • Problem: contention on
   ‘insert’ statements
 • Result: 14.7 sec avg
   statement execution                                              14.7 sec




 Oct 10, Amdocs w/ Oracle RAC
 • Action: reduce to 1 node
 • Result: 0.13 sec avg
   statement execution
 • 100 fold increase

                                                                    0.131 sec
   Apps not designed for
    RAC may not scale
                                How Symantec/Veritas Adds Value in your Oracle RAC Environment 72
Is PeopleSoft architected for RAC? Notice the
high RAC time – about 33% - for this node of a
             3 node RAC cluster




                                How Symantec/Veritas Adds Value in your Oracle RAC Environment 73
We can see that the most contentious
object by far is the PS_JRNL_LN table – 88%.




                              How Symantec/Veritas Adds Value in your Oracle RAC Environment 74
We examine ‘Oracle Sub-State’ ‘RAC OPS Wait’ events to find those
that are non-idle. and see that the event ‘buffer busy global cr’ has
accrued 6 days, 3 hours (147 hours) of wait time during this 12 hour
period! And ‘global cache cr request’ accrued almost 10 hours.




                                                How Symantec/Veritas Adds Value in your Oracle RAC Environment 75
Summary of RAC Analysis for
3 node PeopleSoft environment:

Node Most Contentious Object                              % RAC                 Total RAC Wait
1        PS_JRNL_LN                                            <5                   0 hour        17 minutes
2        PS_JRNL_LN                                            16                  1 hour         43 minutes
3        PS_JRNL_LN                                            33                157 hours



    The above table summarizes, for a 12 hour period, what we have learned Clearly, Node
    3 is experiencing severe wait times associated with RAC Wait events. Node 2 is
    moderately impacted, and Node 1 is just slightly impacted.

    Even though the vast majority of the access of the most contentious object –
    PS_JRNL_LN table - is read activity(SELECT) with very little write activity (INSERT,
    UPDATE, DELETE), we are seeing this behavior.

    This initial analysis shows enough evidence that Peoplesoft is not ‘tuned’ out of
    the box for Oracle RAC environments and that further investigation and analysis
    is warranted.


                                                      How Symantec/Veritas Adds Value in your Oracle RAC Environment 76
Oracle EBS running on 4 Node RAC Cluster. RAC Wait
accounts for 48% of total in-oracle time during at peak hour
during day, pretty evenly distributed across all 4 nodes.




                                         How Symantec/Veritas Adds Value in your Oracle RAC Environment 77
Oracle Published TPC-C results – single node vs 16
node RAC cluster




                                    How Symantec/Veritas Adds Value in your Oracle RAC Environment 78
HA vs RAC




  How Symantec/Veritas Adds Value in your Oracle RAC Environment 79
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
                                       How Symantec/Veritas Adds Value in your Oracle RAC Environment 80
Database Fail-over: What to Expect

   SF HA for Oracle              SF CFS HA w/
                                                                              SF RAC
   (single instance             (single instance
                                                                            (Oracle RAC)
       Oracle)                      Oracle)

• Import disk group         • Import disk group                    • Import disk group
• Mount file system         • Mount file system                    • Mount file system
• Start database            • Start database                       • Start database
• Resolve                   • Resolve                              • Resolve
  transactions                transactions                           transactions
  (replay logs)               (replay logs)                          (replay logs)
• Update IP                 • Update IP                            • Update IP
• Clients Reconnect         • Clients Reconnect                    • 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.

                                               How Symantec/Veritas Adds Value in your Oracle RAC Environment 81
 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
                                       Single Instance                  Single Instance
5. Redirects traffic to standby            SF HA                            SF HA




                                       How Symantec/Veritas Adds Value in your Oracle RAC Environment 82

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:193
posted:9/11/2012
language:English
pages:82