ORACLEDATABASEHIGHAVAILABILITYSTRATEGY,ARCHITECTUREANDSOLUTIONSDOAGNuremberg-17/09/2013KirillLoifmanOracleCertifiedProfessionalDBAwww:dadbm.
comTwitter:@loifmkir14/03/2012Footer2ELEMENTSOFHIGHAVAILABILITYHighavailability–Eliminatingsinglepointsoffailurethroughredundancy-Examples:redundantHW,SAN/ASM,RACdatabasesDisasterrecovery–Recoveringfromfailure-Examples:Extendedclusters,standbydatabasesOracleMaximumAvailabilityArchitecture(MAA)–CombiningHAandDRelementsDowntime–Howmuchtimeyoucantolerateyoursystembeingunavailable–Includesunexpectedaswellasplanneddowntime-99.
9%availability~8hoursand45minutesofdowntimeperyear14/03/2012Footer3CAUSESOFDOWNTIME2waysofdealingwiththepotentialfordisaster:a)expectandplanforitb)donothing,andhopeforthebest14/03/2012Footer4UNDERSTANDINGSERVICELEVELAGREEMENTS(SLA)1.
UnderstandingServiceLevelAgreements-customer'sservicerequirements2.
UnderstandingelementsofSLAs:-SystemAvailabilitye.
g.
Thedatabaseserversmustbeavailable7daysaweek,from6amtomidnight-AcceptableDataLosse.
g.
Nomorethan15minutesofdataentrycanbelost-RecoveryTimee.
g.
Intheeventofadisaster,thesystemsshouldbebackupandrunningwithinonehour.
-Performancee.
g.
Transactionresponsetimeshouldnotexceed2seconds.
3.
MapyourSLAstoappropriateHighAvailabilityLevels/Tiers4.
DesignsystemsandprocessestomeetSLAexpectations5.
Donotforgetaboutcost!
14/03/2012Footer5AVAILABILITYTARGETVSCOSTHowmany9sdoyouneed-Sharpdecreaseindowntimeforeachadditional9intheavailabilitytarget.
Whatwillitcost-CostcomparisonofoptionshelpsinachievingrealisticexpectationswhendevelopingSLAsAvailabilityTargetDowntimePerYear(Approx.
)90%36days98%7.
3days99.
7%26hours99.
99%52minutes99.
999%5minutesItemSANSnapshotbackupNativeDBbackupLicensing28,000Training14,000Storage45,00010,000TotalCost87,00010,000RecoveryTimeabout5minutesabout45minutesBenefitsNear-instantrecoveryReducedcomprexity14/03/2012Footer6LEVELSOFHIGHAVAILABILITY-EXAMPLELevel0:Out-of-the-box(nospecifichigh-availabilityelements)Level1:Storage-levelprotection(databaseinstancewithprotectedstorage)Level2:CFCor/andStandby(ColdFailoverClusteror/andStandbyDBatthesamephysicallocation)Level3:Recoveryviaredundantcomponents(HotFailoverwithmulti-nodeRACatthesamephysicallocation)Level4:Activeandpassiverecovery(2siteconcept,MAA,RAC,StandbyDB,Storagemirroring)Note:HALevelcombinationspossible;*percentagesshownareforillustrativepurposesonly.
14/03/2012Footer7ORACLE'SSOLUTIONTODOWNTIMEOracleCluster-ware&ASMRAC,RAC1NodeOracleRestartFlashbackTechnologyRecoveryManager(RMAN)DataGuardStreamsandGoldenGateFast-StartFaultRecoveryDataRecoveryAdvisorOnlinereorganization&redefinitionPatchinginrollingfashionOnlinepatchingDynamicdatabasereconfigurationAutomaticDiagnosticRepository(ADR)HARD-OracleHardwareAssistedResilientData…14/03/2012Footer8ORACLEDATABASEHIGHAVAILABILITY:BESTPRACTICES14/03/2012Footer9STORAGE-LEVELPROTECTIONCONSIDERATION2filesystems(DATA&FRA)areenoughtosharestoragebetweenmultipleDBsWhichRAIDConfigurationforHAtouse-basedonbusinessrequirements,costs,etc.
a)ASMmirroring(bestchoiceforlowcoststorage;enablesextendedclusteringsolutions)b)HardwareRAID1(mirroring;bestperformance;bestchoiceformodernSAN)c)RAID5(parityprotection,moreeconomicalsolution,notforwriteintensiveworkloads)d)BothASMmirroringandHardwaremirroringWhatTypeofStripingWorksBesta)ASMonlystriping-manyLUNstomanageatthestoragelevel-LUNsshouldbeequalandlimitedinsizeb)RAID0andASMstriping(stripe-on-stripe)DiskI/OdesingbestpracticesUseexternalRAIDprotectionwhenpossibleUseLUNswiththesameperformancecharacteristicsUseLUNswiththesamecapacityMaximizethenumberofspindlesinyourASMdiskgroup-painforSANadmin14/03/2012Footer10ASMSTRIPINGONLY14/03/2012Footer11HARDWARERAID–STRIPEDLUNS14/03/2012Footer12SINGLE-NODE,NON-CLUSTEREDORACLEDATABASEHALevel1~95-98%AvailabilitySingle-instance,standalone(noncluster)databaseProtectedstorageviaSAN/ASMOracleRestarttoenhanceHAOtherHAfeatureslike:FlashbackDatabase,OnlineRedefinition,RecoveryManager,andOracleSecureBackup,etc.
2filesystems/ASMdatagroups14/03/2012Footer13ORACLEDATABASEWITHCLUSTERWARE(COLDFAILOVER)HALevel2~98-99%Availability2ormultiple-nodesclusterSingleDBinstanceincoldfailovermodeOracleGRIDInfrastructureOracleRACOneNodeasOraclerecommendedcoldfailoversolutionSharedstorageonASM,OCFS2,NFS,…OracleRAConeNodeprosandcons:+betterDBavailabilitythantheothers+Onlinemigration&patching+Singlevendorsolution+ReadytoscaletofullRAC+SupportsDataGuard+Host-basedmirroringwithASM-Worksonlyfrom11gR2-Licensedseparately(+25%onCPU)14/03/2012Footer14ORACLEDATABASECOLDFAILOVER-OTHEROPTIONSOracleGridInfrastructurewithOracleclusterwarescripts+NotlicensedseparatelyincaseyouclusteranOraclelicensedproduct(database)+WorksforOracleClusterwareandDatabasebefore11gR2+Host-basedmirroringwithASMpossible-NoonlinerelocationpossibleaswithRACOneNode-Oracledoesnotdirectlysupportactionscriptsascustomcodefragments.
RedHatFailoverCluster+Inexpensive+MakesenseusingLinuxRedHat+Simpletomanagebutamajorupgradecanbeapain-Storagenotsharedbutmountedtoactivenode-Host-basedmirroringinastretchedclusterrequiresdifferentLinuxLVMwithmoreoverheadHPServiceguard+Complexbutstable+AvailableonHP-UXandLinux+Host-basedmirroringwithHP-UXLVMpossible-Expansive14/03/2012Footer15ORACLERACDATABASEHALevel3~99,5%Availability2ormultiple-nodesclusterOracleGRIDInfrastructure+OracleRACDBOracleRACprosandcons:+Hotfailoverfunctionality+Scalabilityacrossdatabaseinstances+Abilityofincreasingcapacitywithoutdowntime+Optimalcomputerresourceusage+Rollingupgradesandpatching+DBconnectionload-balancing-MightaffectDMLintensiveperformance-Licensedseparately(~50%ontopofCPUlicense)-Strictrequirementsfortheclusterinterconnect14/03/2012Footer16ORACLERACDATABASEONEXTENDEDCLUSTERSHALevel4~99,7%AvailabilitySameconfigurationaslocalOracleRAC2DataCenterlocationsDistancesovertenkilometersrequiredarkfiberRedundantstorageThirdvotingdiskonaninexpensiveNFSProsandCons:+GreateravailabilitythanlocalOracleRACcluster+Disasterrecoverypossibilitiesforsomedisasters+Extremelyrapidrecoveryifonesitefails-Cannotprotectagainstalldatacorruptionsorcomprehensivedisasters14/03/2012Footer17EXTENDEDRACDISKMIRRORINGNeedcopyofdataateachlocationTwooptions:1)Host-basedmirroring+WorkswithOracleASM,LRHHA-LVM,HP-UXLVM,…+Nodowntimeincaseofstoragefailure-Extraoverheadonserverresources-Morecomprexityforclustermaintenance2)Remotearray-basedmirroring+WorkswithHPCLX,EMCSRDF,HITACHIHAM,…+Doneonhardwarelevel+Nooverheadonserver-Outageincaseofprimarystoragefailureforsome(HPCLX)-StorageHAsoftwarelicenserequiredDiskmirroringisvendorspecificRedHat:Whenusingastretchedclustersolution,notallstorageconfigurationsaresupportedbyRedHat,i.
e.
clvmandcmirrorarenotsupported,butHA-LVM(withoutclvmd)maybeused14/03/2012Footer18ACHIEVINGQUORUMWITHEXTENDEDRACEveryClusternodemustaccessmorethanhalfofthevotingdisksatanytimeorthatnodewillbeevictedfromthecluster*Thesitethathousesthemajorityofthevotingdisksisapotentialsinglepointoffailurefortheentirecluster.
14/03/2012Footer19ORACLERACANDDATAGUARDCOMPLEMENTARITYRACaddressessystemfailuresbyprovidingrapidandautomaticrecoveryfromfailures,suchasnodefailuresandinstancecrashes.
DataGuardaddressessitefailuresanddataprotectionthroughtransactionalconsistentprimaryandstandbydatabasesthatdonotsharedisks,enablingrecoveryfromsitedisastersanddatacorruption.
14/03/2012Footer20ORACLEMAXIMUMAVAILABILITYARCHITECTURE(MAA)MAAisasetofbestpracticeblueprintsfortheintegrateduseofOracleHAtechnologiesMAAprovidesguidanceonoptimalHAarchitecturesdesignedtoachievethedifferentservicelevelobjectivesMAAresources:oracle.
com/goto/maa14/03/2012Footer21ORACLEMAAEXAMPLE–RAC&DATAGUARDHALevel4~99.
9%availabilityMAAprovidesthemostcomprehensivearchitectureforreducingdowntimeforscheduledandunscheduledoutagesTwoidenticalsitesPrimarysitecontainstheRACdatabaseSecondarysitecontainsPhysicalStandbydatabaseorbothPhysicalandLogicaloneonRACActiveDataGuardcanbeuseforonlinereporting(extralicensed)DataGuardswitchoverandfailoverfunctionsallowtherolestobetradedbetweensites14/03/2012Footer22ACTIVE-ACTIVEHAANDZERO-DOWNTIMEUPGRADES:GOLDENGATE14/03/2012Footer23DATABASEHASOLUTIONS–ANOTHEREXAMPLEStretchedRHCSwith2NodesSingleDBinstance(s)incoldfailovermode1OraclebinarysetperDBinstanceStoragemirroringwithDRBDHALevel3-99.
7%14/03/2012Footer2414/03/2012Footer24ORACLEEXADATAVERSION3ExadataX3DatabaseforHighAvailabilitySamearchitectureandpriceasX24xlargerflashmemory->22TBPCIflashmemoryperrack20xmorewriteperformance->ExadataSmartFlashWriteCaching33%moredatathroughput->100GB/secrunningSQL33%fasterDBCPUs->8-CoreXeonSandyBridgeE5-269075%morememory->2-4TBDRAMFull10GbEthernettoDataCentre10-30%lowerpower->Upto3KilowattReductionperRackNewlowercost1/8racksolutionNewOraclePlatinumServicesonX3AppliedtoOracleEngineeredSystemsDeliveredatnoadditionalcostsforPremierSupportcustomers24/7oraclemonitoringandremotediagnostics5MinuteFaultNotification15MinuteRestorationorEscalationtoDevelopment30MinuteJointDebuggingwithDevelopmentQuarterlysystemupdatesExadatalimitations-Cannotinstallothersoftware-Cannotspreadclusternodes-Cannotmirrorstorage-…14/03/2012Footer25ORACLE12CHIGHAVAILABILITYFEATURESOracleMultitenantarchitectureApplicationContinuity-improveapplicationrecovery(formerTAF)GlobalDataServices-supportglobaldatabaseservicesActiveDataGuardFarSync-extendzero-data-lossprotectionFlexASM-enableinter-nodestoragefailoverandreduceASM-relatedresourceconsumptionSYSDG,SYSBACKUP–newprivilegestoavoidgrantingSYSDBAActiveDuplicateCloning–rmanfeatureMoreonlineoperations:datafilemove,partitionmoveDatabaseRollingUpgradesusingActiveDataGuardOEM12cCloudControl:-OracleSiteGuard–extendsautomationofdisasterrecoverytotherestoftheOraclestack-HighAvailabilityConsole-integratesmonitoringofvariousHAareas-MAAConfigurationAdvisor-AutomationofmigrationadatabasetoASMandRAC….
THANKYOU!
KirillLoifmanwww.
dadbm.
com
LOCVPS在农历新年之后新上架了日本大阪机房软银线路VPS主机,基于KVM架构,配备原生IP,适用全场8折优惠码,最低2GB内存套餐优惠后每月仅76元起。LOCVPS是一家成立于2012年的国人VPS服务商,提供中国香港、韩国、美国、日本、新加坡、德国、荷兰、俄罗斯等地区VPS服务器,基于KVM或XEN架构(推荐选择KVM),线路方面均选择国内直连或优化方案,访问延迟低,适合建站或远程办公使用。...
官方网站:点击访问亚洲云官网618活动方案:618特价活动(6.18-6.30)全站首月活动月底结束!地区:浙江高防BGPCPU:至强铂金8270主频7 默频3.61 睿频4.0核心:8核(最高支持64核)内存:8G(最高支持128G)DDR4 3200硬盘:40G系统盘+80G数据盘带宽:上行:20Mbps/下行:1000Mbps防御:100G(可加至300G)防火墙:提供自助 天机盾+金盾 管...
在六月初的时候有介绍过一次来自中国台湾的PQS彼得巧商家(在这里)。商家的特点是有提供台湾彰化HiNet线路VPS主机,起步带宽200M,从带宽速率看是不错的,不过价格也比较贵原价需要300多一个月,是不是很贵?当然懂的人可能会有需要。这次年中促销期间,商家也有提供一定的优惠。比如月付七折,年付达到38折,不过年付价格确实总价格比较高的。第一、商家优惠活动年付三八折优惠:PQS2021-618-C...
oracle数据库学习为你推荐
乐划锁屏oppofindx2乐划锁屏点进去闪退 是什么情况?网红名字被抢注谁知道这个网红叫什么名字?求帮助!地图应用看卫星地图哪个手机软件最好。留学生认证留学生回国认证,是否要求需要在国外待满三年,还是只需要完成所需的三年课程?留学生认证留学生前阶段双认证认证什么内容?bbs.99nets.com怎么制作RO单机钟神发战旗TV ID:新年快乐丶未央不见是哪个主播同一服务器网站一个服务器放多个网站怎么设置?ip查询器怎么样查看自己电脑上的IP地址66smsm.comffff66com手机可以观看视频吗?
免费虚拟空间 租服务器 com域名注册 m3型虚拟主机 买域名 广东服务器租用 北京vps主机 海外服务器 wordpress技巧 directadmin dropbox网盘 500m空间 福建天翼加速 个人域名 网站木马检测工具 nerds 服务器托管什么意思 广州服务器 多线空间 备案空间 更多