Oracle and NetApp.ppt

OracleandNetApp MikeMcGuigganConsultingSystemsEngineerNortheastRegion 2 OracleandNetworkAppliance 12yearsofinnovationdrivingdowninfrastructurecostsANDincreasingenterpriseITproductivity 3 SafraCatz PresidentandCFOofOracleOOWquote IwouldliketointroducemygoodfriendTomMendoza NetAppisavery veryclosepartnerofOracle wehaveworkedtogetherforaverylongtimeinadvancingtechnology gridcomputing anddatacenterconsolidation foranyofyouthathasvisitedourAustinDataCenter itisacommercialforNetApp Wevotedforthemwithourmoney 4 OracleAustinDataCenter Over20 000servers Over6900 TBofNetAppStorage AustinDataCenterStatsMorethan20 000 serversLargestDell Linuxinstallationonearth6 900 terabytesofNetAppstorageLargestNetAppsingleinstallationonearthScalingatover60TBsofstorageeachmonthOver500mission criticalcustomers appshostedonthepremisesPrimarydatacenterfor50 000 Oracleemployees2acresofdatacenterraisedfloorspaceResultsExperiencing30 higherutilizationandfasterapplicationdeploymentStoragemanagementoverheadreduced50 GlobalIThas88 fasterresponsetimeonNetAppFCSAN 5 TheBottomLine 6 OracleasaCustomer Highlights 99 ofOracleapplicationdevelopmentisonNetApp 2400TB 99 ofOracleOnDemand ProductionApplicationsandDB 2100TB 100 OracleUniversity 120TB 100 OracleDemosDB Applications 500TB 50 DatabaseDevelopment 300TB 65 ofOracleinternalproduction 2420TB NetApphasreducedtheoverheadnecessarytoperformstorage relatedmanagementactivitiesby50 7 SAN Block NAS File NetAppSupportsThemAll FabricAttachedStorageTopology DedicatedEthernet FibreChannel EnterpriseSAN EnterpriseNAS DepartmentalNAS CorporateLAN iSCSISAN NetApp FAS 8 SimplifyingDatabaseManagement NetApp sValuePropositiontotheDBA 9 NetApp sValuetotheDBA PerformanceandUtilizationBackupandRecoveryDataProtectionDisasterRecoveryandBusinessContinuanceTest DevelopmentASMSnapManagerforOracle 10 DatabasePerformanceTuningandCapacityPlanningChallenges StoragecanbeaperformancebottleneckDuplicatedatabasecopiesareneededtomaintainavailabilityandSLAsPerformanceofeachvolumeislimitedtothenumberofspindleswithin Hot volumescan tbe helped bydisksinothervolumesCapacityplanning forecastingandmanagementareimprecisetasksAvailability scalabilityandcapacitymustbemaintainedorincreasedwhiledrivingdowncosts 11 FlexVol Flexible VirtualizedVolumes LUNs ConventionalVolumes LUNs DataONTAP7G FlexVols vol0 HMDIR s vol2 Oracle Cach nRaidGroups AGGREGATE PhysicalStoragePool FlexVol LogicalDataContainer 1MB 16TB FlexVol ssharediskAggregate Grow shrinknon disruptively HigherStorageUtilization ImprovedPerformance ThinProvision adddiskson the fly MoresharedspindlesmeanNO HOT vols LUNs WAFL Provisions on Demand P P P P P P 12 WAFL Snapshot andFlexClone TheFoundation NetApp sUniqueDNAWAFL WriteAnywhereFileLayoutCoreblockandfilestorageservicesResiliencyfeatures RAID DP SnapshotNear instantaneous point in time copy offilesystem vol orLUNRead onlySnapRestore Near instantaneous rollback ofvolorLUNtopriorSnapshotcopyFlexCloneNear instantaneous WRITABLE copy ofvolorLUNSamespace sharingcharacteristics A B C D ActiveFilesysorLUN Inodes blockmaps Diskblocks Snapshot D Y FlexClone 13 IntroducingSnapshotTM A B D C RootInode AfterBlockUpdate BeforeSnapshot Snapshot InodeCopy AfterSnapshot DiskBlocks DiskUsage 14 IntroducingSnapRestore A B D C New RootInode AfterSnapshot Snapshot InodeCopy AfterSnapRestore DiskUsage DiskBlocks 15 DatabasePerformanceTuningExample TestOLTPDatabase1 TestOLTPDatabase2 16 DatabasePerformanceTuningExample 17 NetApp sValuetotheDBA PerformanceandUtilizationBackupandRecoveryDataProtectionDisasterRecoveryandBusinessContinuanceTest DevelopmentASMSnapManagerforOracle 18 DatabaseBackupandRecovery ChallengesRMANbackupsconsumesignificantphysicalresourcesColdbackupsleadtolowerSLAsSeparatebackupsoneachplatformTime to recoverfromtapebecomesprohibitiveDBA stimespentonnon value addbackup restoretasksBackupsperformedwithlessfrequency 19 BackupandRecoverywithSnapshotandSnapRestore SignificanttimesavingsStayonlineReducesystemandstorageoverheadConsolidatedbackupsBackupmoreoften TimeinHours TimetoBackup TimetoRecover ToTape 60GB HrBestCase FromTape RedoLogs 300GBDatabase 012345678 PrimaryBackup SecondaryBackupSnapVault 20 NetApp sValuetotheDBA PerformanceandUtilizationBackupandRecoveryDataProtectionDisasterRecoveryandBusinessContinuanceTest DevelopmentASMSnapManagerforOracle 21 RAID DPReliability 2 000to4 000timesmoresecurethanregularRAIDMorereliablethanmirroringfordouble diskfailure14 ParityOverheadvs 50 Overheadw Mirror 72 moreusablecapacitythancompetitiveofferings Comparing2P 12Dvs 7 7Mirror P P DP RAIDProtectsagainstsinglediskfailure RAIDDPProtectsagainstanytwo diskfailure 22 RAID DPvsOtherRAIDMethods RAID DPprovidesRAID1protection withRAID4cost performanceandsimplicity 23 ProtectOracleDatawithSnapLock Tablespaces OracleDatabase Datafiles partitions oradata 2001a dbf oradata 2001b dbf FabricAttachedStorage FAS UnifiedStorageArchitecture SnapLocksoftwarehelpsensurethepermanence accuracy integrity andsecurityofdatabyenablingbusinessrecordsandOracledatafilestobebothunalterableandrapidlyaccessibleonlineforlongperiodsoftime 24 MigrateDataAcrossStorageTiers Periodicallymovedatabetweenstoragetiersasaccesspatternschangee g MOVEPARTITIONholdingQ2OrdersfromhighperformancestoragetiertolowcoststoragetierMoveimportantdataondemandUPDATEofpartitionkeywillcauserowtomovetoanewpartitione g productwarrantyexpiresWriteprotectdatawithSnapLockonanystoragetiere g MOVEPARTITIONtoSnapLockvolumeandmarkas readonly andsettheretentiondate HighPerformanceStorageTier LowCostStorageTier PartitionRules UseCases ContentMgmt ILM Compliance Litigation Etc 25 ProtectAgainstOracleBlockCorruption DatabaseBlockWrite VolumeManager I ODriver OperatingSystem HostBusAdapter SAN NASCloud Datapassesthroughmanylayersbeforereachingthestoragesubsystem Corruptioncanoccuratanypointinthedatapath Hardwareand orfirmwarefailures misconfiguration etc 26 SnapValidator PreventsOracleblockcorruption SnapValidator isNetApp simplementationofOracle sHARDinitiativeHARDstandsforHardwareAssistedResilientDataValidateswritestovolumesthatcontainOracledataOraclechecksumverificationFeatureofDataONTAPSupportedwithOracleDatabase9iand10g NFS iSCSI FCP NetAppistheonlyHARDpartnertosupportthisinitiativeacrossitsentireproductline NetAppistheonlyHARDpartnertosupportfilesystems 27 NetApp sValuetotheDBA PerformanceandUtilizationBackupandRecoveryDataProtectionDisasterRecoveryandBusinessContinuanceTest DevelopmentASMSnapManagerforOracle 28 DisasterRecoveryPlanning Challenges4xactualstoragerequirementExpensivetransportinfrastructureCumbersometoinstallandmanageDifficulttokeepbackupcopiessynchronized SecondaryDataCenter PrimaryDataCenter DatabaseServer RAID0 1MirrorCopy RAID0 1MirrorCopy DedicatedLinesandSwitches DatabaseServer 29 DisasterRecoverywithSnapMirror FastdatareplicationandfailoverSignificantreductioninstoragerequiredSyncorasyncreplicationMoreefficientnetworkutilizationAccesstomirroreddataVolumeorqtreereplicationSecondarycanbecomeprimaryincaseofdisasteratprimarysiteEasytoinstallandmanageoverexistingIPinfrastructure WAN SnapMirror ProductionSite RemoteDisasterRecoverySite 30 UnifiedandTieredDisasterRecoverywithReplicatorX SAN SAN iSAN CurrentInstance Point in TimeClones OranyLegacyStorage HA BCsiteFASStorageFlexClone Datareplicationandrecoveryoveranydistanceinaheterogeneousenvironment100 dataconsistencyacrossanynumberofservers storagedevices andfabric baseddevicesGuaranteesblockwriteorder 31 NetApp sValuetotheDBA PerformanceBackupandRecoveryDataProtectionDisasterRecoveryandBusinessContinuanceTest DevelopmentASMSnapManagerforOracle 32 DatabaseCloningandtheApplicationDevelopmentProcess Fullorpartialdatabasecopiesrequiredfor AppandDBDevelopmentMaintenance OS DBupgrade TestandQATrainingandDemosReportingandDWETLAbilitytodothisquickly correctly andefficientlydirectlyimpactsApplicationDevelopmentandDeployment PROD SECONDARY DR DEVMAINT TEST QA RPT ETL 33 ApplicationDevelopmentandTestingExample TraditionalApproach Productiondatabase100GBMirrorcopy100GBDevelopmentcopies300GBTestingcopies300GBTotal 800GB8xactualstoragerequirementTimeconsumingResourceoverhead Production 34 ApplicationDevelopmentandTestingExample NetAppApproach Productiondatabase100GBMirrorcopy100GBDevelopmentcopies30GBTestingcopies30GBTotal 260GBOver67 reductioninstoragerequiredNearinstantaneouscopiesNegligibleoverheadAbilitytohavemanymoretestanddevcopies Test1 Test2 Test3 Production MirroredCopy Dev1 Dev3 Dev2 Assumption upto10 changeindatainthetestanddevenvironments 35 DatabaseMaintenancewithFlexClones BenefitsInstantaneouscopiesLowresourceoverheadInexpensiveEasyandrelativelyinexpensivewaytomakecopiesofaproductiondatabasewithoutimpactingthedatabaseUsedatabaseclonestotestmigrations applybugfixes upgrades andpatchesEasilyreallocatestorageforadatabaseanditstransactionlogfiles Test1 Test2 TestN Production MirroredCopy Dev1 DevN Dev2 ProductionDBClones 36 CloningforProductionSupportApplicationsEMCtoNetAppexampleusingReplicatorX ContinuousreplicationwithnodisruptiontoproductionAvoidduplicatingexpensivestorageforproductionsupportLocalorremoteenvironmentsIntegrated instantaneouscloningofcurrentproductiondataManageupto255cloneswithminimalstoragecapacity ProductionEnvironment ProductionSupportEnvironment SAN SAN iSAN CurrentInstance Point in TimeClones InstantaneousClone ContinuousReplication DevelopmentandTestReportingAnalytics DataWarehouse OranyLegacyStorage FASStorageFlexClone ReplicatorX ReplicatorX 37 NewDatabaseDevelopmentMethodology MirrorPRODforinitialcopy DR IfnonNetAppPROD useReplicatorXforSAN to SANClonedatabasereplicasasneededCreateSnapshot copiesofreplicasforinstantSnapRestore ofworkingdatabasesExploitmultiplemirrorstoincreasefan outandsupportmultiplesites PROD Secondary DR Clones Develop Test Deploy 38 NetApp sValuetotheDBA PerformanceandUtilizationBackupandRecoveryDataProtectionDisasterRecoveryandBusinessContinuanceTest DevelopmentASMSnapManagerforOracle 39 NetAppAddsValuetoOracleASM 40 NetApp sValuetotheDBA PerformanceandUtilizationBackupandRecoveryDataProtectionDisasterRecoveryandBusinessContinuanceTest DevelopmentASMSnapManagerforOracle 41 SnapManager forOracle Automated fast andefficientUptimeANDperformanceSimplifybackup restore andcloningTightOracleDatabase10gintegrationAutomatedStorageManager ASM RMAN OracleDatabases NetAppStorageAppliance SnapManager GUI SnapDrive NetAppAppliance NFS FCP oriSCSI 42 OracleAdvanced 43 OtherCoolStuff NFS v4SupportwithDataONTAP7 3PlannedFeatureimplementationwithDNFSfor11gR2WorkloadprioritizationSmartredirectionRACFailoverManagementwithNetAppIntegrateManageONTAPAPI sintoCRS IfStoragenotaccessible isitfailingover plannedorunplanned Alternative nodeeviction suicide application usermustreconnect OracleEnterpriseManagerGridControlEnhancedplugin toincludeblocks Connector toOperationsManager SMB ESolutionwithDNFS SE RAConWindows 44 FlexShareKeyFeatures RelativepriorityofdifferentvolumesApplication user Vs DataONTAPbackground system prioritizationPer volumecachepoliciesDynamicconfigurationupdates 45 FlexShareHighBenefitUseCases ConsolidatedEnvironmentsProduction Test andDevelopmentonthesamesystemBackup DisasterRecoveryThrottlingManage like datawithconsistentperformanceStructuredandunstructuredMatchNetAppcachemanagementwithOraclecachemanagement 46 OracleEnterpriseManagerGridControlPluginforNetApp MonitorTrendsandThresholdAlerts MonitorKeyStatistics MonitorUtilization Etc ShipswithOracleEnterpriseManagerDeveloped maintainedandlicensedseparatelybyOracle 47 IntroducingDatabaseNFS DNFS WhatisDNFS AnOracledevelopedandsupportedNFSclientforallplatforms IncludingWindows WhatarethebenefitsofDNFS Simplermanagementwithenhancedperformanceandscalability Nocertificationrequired immediatecustomeravailabilityFullytestedduringdevelopmentratherthanafterdeploymentSupportsRAC ASM andHARDacrossalloperatingenvir