Oracle DB High Availability on IBM Power Systems

1 IBM Oracle Center | November 2011Fr d ric DuboisIT CyrIT DB high Availability on IBM Power Systems Share Best Practices for demanding IT environmentsDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationIBM Power Technologies for OracleIBM Power Technologies for OracleHighHigh-- Availability and Disaster RecoveryAvailability and Disaster RecoveryIBM Live Partition Mobility with Oracle Database DemoIBM Live Partition Mobility with Oracle Database DemoAgendaDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationScalability with IBM Power Systems and Oracle3 Power 770 Power 750 Power 780PS BladesPower 740 2S/4 UPower 720 1S/4 UPower 795 Power 730 2S/2 UPower 710 1S/2 UOracle Certifies for the O/S&All Power servers run the same AIX=Complete flexibility for Oracle workload deploymentConsistency Binary compatibility Mainframe-inspired reliability Support for virtualization AIX, Linux and IBM i OSPower Systems with AIX deliver uptimeOpen Source LinuxHP UX 11/ HP IntegrityHP UX 11/ PA RISCSun Solaris / SPARCIBM AIX POWERA pple MACRed Hat EnterpriseWindows Server 2008 Windows Server 2003 Corporate Enterprise Downtime(Hours per Year)DOAG Conference 2011 (November 15th-17th)

2 2011 IBM CorporationIBM s Ten-Year March to UNIX LeadershipThe largest shift of customer spending in UNIX history415%20%25%30%35%40%45%Q300Q400Q10 1Q201Q301Q401Q102Q202Q302Q402Q103Q203Q30 3Q403Q104Q204Q304Q404Q105Q205Q305Q405Q10 6Q206Q306Q406Q107Q207Q307Q407Q108Q208Q30 8Q408Q109Q209Q309Q409Q110Q210Q310Q410HP Sun/OracleIBMS ource: IDC Server Tracker, Feb 2011 UNIX Server Rolling Four Quarter Average Revenue SharePOWER6 Live Partition Live Partition MobilityMobilityPOWER5 MicroMicro--PartitioningPartitioningPOWE R6 Shared Processor PoolsShared Processor PoolsPOWER6 PowerVM Lx86 PowerVM Lx86 POWER7 Shared Storage PoolsShared Storage PoolsPOWER6 Active Memory Active Memory SharingSharingPOWER4 Dynamic LPARsDynamic LPARsDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationEnablement: Product Roadmap Interlocks Oracle and IBM5 A Collaborative Continuous Process between Oracle and IBM to ensure the Oracle Certificationof IBM SWG and STG products at its most Current Releases with Oracle Product Releases * Applications Unlimited (PSFT, JDE, Siebel CRM, E-Business Suite) Fusion Applications Business Intelligence and EPM (BI Apps, OBI EE, Hyperion EPM) Retail GBU (Retek, 360 Commerce, ProfitLogic) Communications GBU (Portal Software, metasolv ) Insurance GBU (AdminServer, Skywire) Edge Applications: G-Log OTM, Agile PLM, Demantra Oracle Technology (DB and RAC, Fusion Middleware, Enterprise Mgr) Focus on Currency and Parity IBM Cross-Brand Technology Focus (IBM SWG and STG Products).

3 Extended technical advocates from Dev Labs* Continuous evaluation as new companies are acquiredDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationOracle DB Certification History6 For 23+ years, IBM has delivered the best infrastructure components available in the market to support customers who have selected Oracle as their SW providerDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationFusion Apps is Available on Power /AIX (4Q 11) HUGE NEWS: Fusion Apps is available on AIX concurrent with Oracle s Base Development Platform!!!DOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationOracle Certifies Active Memory Expansion (AME) on IBM Power /AIXO racle Virtualization MatrixAnother Proof point thatOracleis committed to red onblue DOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationOracle Power Technology Adoption RoadmapDOAG Conference 2011 (November 15th-17th)

4 2011 IBM CorporationMix Workload Types for Best Ressources Usage10 StorageDev & TestOracleDatabaseOracleMiddlewareOracle Applications061218 Micro-partitionningShared CPU Reach 70 to 80% CPU average usage Consolidate different workload profiles and better optimize the resources Development environment could be consolidated into the production infrastructure, workloads can be isolated and resources can be shared CPU resources for Dvt can be given a lower priority than production as needed by business Shared Processor Pool Memory dynamic LPAR Different VIO Server to isolate I/Os for Dvt environmentDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationVirtualize Network for Oracle with PowerVM virtualization11 StorageDev & TestOracleDatabaseOracleMiddlewareOracle ApplicationsVirtual Ethernet Partitions can be interconnected with Virtual Ethernet network. Virtual Ethernet is easy, flexible, performance and it s integrated at the low level of the system (microcode) Does not require any hardware for internal interconnection, can be bridged to the outside network infrastructure thought a VIO ServerHost Ethernet Adapter (also called IVE) HEA switch can be configured and logical ports can be assigned to partitions for network interconnection HEA (also called IVE) is a hardware switch adapter connected to the internal Bus of the processor(s) (GX bus) and can connect to the external network infrastructure Oracle supports both Virtual Ethernet and Host Ethernet Adapter technologiesVLANsEnterprise NetworkVirtual Ethernet DevicesVIO ServerYou can build heterogeneous network configuration and mix virtual and physical infrastructure at the client LPARDOAG Conference 2011 (November 15th-17th)

5 2011 IBM CorporationVirtualize Storage for Oracle with PowerVM virtualization12 StorageDev & TestOracleDatabaseOracleMiddlewareOracle ApplicationsVirtual Fiber Chanel (NPIV) Partitions can be interconnected with Virtual Fiber Chanel adapters to the SAN throught an VIO Server and an NPIV adapter. Virtual Fiber Chanel is is easy, flexible, and performance and it s integrated at the low level of the system (microcode/Porwer Hypervisor). VIO Server maps the Virtual to Physical fiber chanels NPIV protocol does not require any hardware for internal interconnection, SAN disks are directly assigned from the SANV irtual SCSI Physical Storage is assigned to the VIO Server, and virtual mapping of the disks is done at the VIO Server level. VIOS provides Storage management techniques. (Multipathing, Logical Volume Manager) Oracle supports both NPIV and Virtual SCSI protocolsVirtual SCSI orFiber Chanel DevicesVIO ServerDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationThe Benefits of PowerVM for Oracle environments13061218 Shared CPU+ many more PowerVM features to reduce costs, improve flexibility, scalability, reliability SMT MVSPP Dedicated Shared Processor NPIV Create Logical Partitions instead of using a server for each workload Mix different Workloads to screw CPU peaks (Production and Test/Dev)

6 Reduce global number of CPUs Virtualize Server resources Optimizes CPU usage, using Shared Processor Pool Create a Virtual I/O Server partition to share physicalresources and simplify I/O infrastructure LPM AMS AME CuODMicro-partitionningOracleApplication sOracleMiddlewareOracleDatabaseTest & DevVIO ServersConsolidate and Virtualize the Oracle Workloads to optimizes the IT resourcesStorageNetworkPower SystemDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationProcessor cores for Oracle : use DLPAR and micro partitions14 During the day Database partition has workload peaks Node1 database is defined as uncapped mode, and is able to get free capacity from the Shared Processor Pool (SPP). Uncapped mode gets additional CPU up to the number of Virtual Processors You can change the number of VPs using Dynamic LPAR Weight parameter defines the priority for the uncapped partitions Test and Development partitions will be capped and will not pick up CPU cycles from the Shared Processor Pool Minimize license cost on core usage and define a Virtual Shared Processor Pool with a CPU capacity Entitlement.

7 Host DB partitions in a Virtual Shared Processor Pool Core licensing is based on the VSPP CapacityDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationPower Technology for Oracle Building Block:IBM Power system , PowerVM Virtualization and Oracle Software151511/3/2011 Oracle Apps AIX LPARO racle DB AIX LPARO racle DB AIX LPARO racle DBAIX LPARVIOS erver 2 VIOS erver 1 NPIV FCAdapter(s)Shared EthernetAdapter(s)Shared ProcessorPool(s)Technology Building Block is based onIBM Power system and PowerVM Shared Processor pool Physical or Multitple virtual Pools Uncapped partitions for PROD Capped partitions for DEV VIO Server virtualization VIO Server 8 Gbps NPIV FC adapters for Storage access Ethernet adapters shared in VIO servers for virtual network accessand /or Host Ethernet Adapters (IVE) AIX , , or (WPARs) 2 VIO servers for Storage and network redundancy Oracle single instance or Real Application Cluster CRS/ASM/RAC 11g (Support for virtualized network and NPIV virtual disks Consolidate DB Server Lpars up to 70 % to 80% of the server CPU capacityNPIV FCAdapter(s)Shared EthernetAdapter(s)LANSAN70-80%DOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationIBM Power Technologies for OracleIBM Power Technologies for OracleHighHigh-- Availability and Disaster RecoveryAvailability and Disaster RecoveryIBM Live Partition Mobility with Oracle Database DemoIBM Live Partition Mobility with Oracle Database DemoAgendaDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationThe Causes of Unavailability Cpu Memory Disk Electrical outage.)

8 Backup Upgrade diagnostic .. Flood Electrical problem Air-conditioning ..Live Partition Live Partition Mobility improves itMobility improves itLive Partition Live Partition Mobility improves itMobility improves it99,999% = 5 minutes outage per year99,99% = 1 hour outage per year99,95% = 4 hours outage per year99,90% = 43 hours outage per year99% = 3 days outage per year98% = 7 days outage per year97% = 11 days outage per yearStandardAvailabilitySuperiorAvailabi lityHighAvailabilityAvailability levelsWhere are you ?DOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationInfra VirtualizationFlashCopyRAIDV olumeCopySnapMirrorOracle Database 11gOracle Database 10gBackup-RMAN-User backups-TSMR ecovery- RMAN- Oracle Flashback-Media Recovery-TSMO racle Data GuardIBM PowerHAReal Application Clusters (RAC)RAC + Data GuardExtended RACO racle StreamsIBM InfosphereRAC + PowerHARemote replication - Metro & Global Mirroring (PPRC)- Stretch & Fabric Metro ClusterOASW eblogicIBM WebsphereSAN Volume ControllerPowerVM: micro-p, VIOs, NPIV, AME, AMS.

9 Load Balancing RouterOracleAS GuardIBM PowerHALoad Balancing RouterServerClusteringCFSCRS PowerHAASMGPFS JFS2 ASMGPFSASMGPFSLoad Balancing + Failover modeSingleActive / PassiveActive / ActiveExtended Solution (MAA)ApplicationTierDatabaseTierStorageA SMJFS2 Remote replication - Metro & Global Mirroring (PPRC)- Stretch & Fabric Metro ClusterCRS PowerHACRS PowerHAHigh Availability : Provide the Right HA/DR ArchitectureDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationCold Fail-Over InfrastructureMicro-partitionningVIO ServerMicro-partitionningVIO ServerOracle ApplicationsPowerHA or Oracle Grid InfrastructureDatabaseOracle MiddlewareProtect all components Third Party Applications Oracle Applications Oracle Middleware Oracle Database Cold Failover with downtime PowerHA for any productorOracle clusterware for Oracle products or DataGuardOracle ApplicationsDatabaseOracle MiddlewareProvide Different Level of ServiceDOAG Conference 2011 (November 15th-17th)

10 2011 IBM Corporation07,51507,51522,530DB Instance 1 ProductionProduction ServerPassive ServerCold Fail-Over architecture is an HA solution with downtimeIBM PowerHA or Oracle DataGuard Requires a minimum downtime of the DB DataGuard replays the logs on a standby DB and uses a 2ndcopy of the original database PowerHA can use the same Database storage volumes. CPU and Memory resources for the passive server are not wasted, they are reserved and can be automatically activated with Capacity on Demand Simple process for switch over operation to DR and recovery to production server Optimize the overall infrastructure with consolidation of other workloads ( Development, Test, ..) and Capacity on Demand Workload balancing across the servers with PowerVM features, LPM, micro-partitioning, .CPU%StandbyLPAR or Instance 1 Stanby LPAR or Instance 2DB Instance 2HA Step 1: Active/Passive is Cold Fail-over solutionDOAG Conference 2011 (November 15th-17th) 2011 IBM CorporationUse PowerVM and Oracle Grid InfrastructureMicro-partitionningVIO ServerMicro-partitionningVIO ServerOracle Applications(Cluster Implementation) Oracle Grid InfrastructureOracle Middleware(Cluster Implementation)Provide high Availability and Scalable solutions for the entire stack No downtime on node failure Rolling Upgrade Patching Increase Workload treatment by adding nodes with no downtime Combine RAC and PowerVM to Scale Right, in and out of the box !