Fastoracle数据库学习

oracle数据库学习  时间:2021-04-05  阅读:()
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%5minutesItemSANSnapshotbackupNativeDBbackupLicensing28,000Training14,000Storage45,00010,000TotalCost87,00010,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

Megalayer 香港CN2优化线路VPS主机速度和性能综合评测

对于Megalayer云服务器提供商在之前也有对于他们家的美国服务器和香港服务器进行过评测和介绍,但是对于大部分网友来说需要独立服务器和站群服务器并不是特别的普及,我们很多网友使用较多的还是云服务器或者VPS主机比较多。在前面也有在"Megalayer新增香港VPS主机 1GB内存 50GB SSD 2M带宽 月59元"文章中有介绍到Megalayer商家有新增香港CN2优化VPS主机。那时候看这...

Virtono:€23.7/年,KVM-2GB/25GB/2TB/洛杉矶&达拉斯&纽约&罗马尼亚等

Virtono最近推出了夏季促销活动,为月付、季付、半年付等提供9折优惠码,年付已直接5折,而且下单后在LET回复订单号还能获得双倍内存,不限制付款周期。这是一家成立于2014年的国外VPS主机商,提供VPS和服务器租用等产品,商家支持PayPal、信用卡、支付宝等国内外付款方式,可选数据中心包括罗马尼亚、美国洛杉矶、达拉斯、迈阿密、英国和德国等。下面列出几款VPS主机配置信息,请留意,下列配置中...

易速互联月付299元,美国独立服务器促销,加州地区,BGP直连线路,10G防御

易速互联怎么样?易速互联是国人老牌主机商家,至今已经成立9年,商家销售虚拟主机、VPS及独立服务器,目前商家针对美国加州萨克拉门托RH数据中心进行促销,线路采用BGP直连线路,自带10G防御,美国加州地区,100M带宽不限流量,月付299元起,有需要美国不限流量独立服务器的朋友可以看看。点击进入:易速互联官方网站美国独立服务器优惠套餐:RH数据中心位于美国加州、配置丰富性价比高、10G DDOS免...

oracle数据库学习为你推荐
特朗普取消访问丹麦特朗普专机抵达日本安保警力情形如何?777k7.com怎么在这几个网站上下载图片啊www.777mu.com www.gangguan23.comwww.119mm.comwww.kb119.com 这个网站你们能打开不?baqizi.cc曹操跟甄洛是什么关系鹤城勿扰齐齐哈尔电视台晴彩鹤城是哪个频道盗车飞侠侠盗飞车车子下水秘籍bihaiyinsha以前在碧海银沙游戏城的那个打气球的游戏叫什么?恶魔兜兜狼人杀恶魔可以验出神民的身份吗关键词挖掘如何挖掘关键词?苦木丹苦木穿心莲治什么病__,
jsp虚拟空间 三级域名网站 国外主机 bbr 国外idc 免费cdn加速 eq2 52测评网 天互数据 电子邮件服务器 ftp教程 howfile 工信部icp备案号 169邮箱 泉州移动 免费美国空间 如何用qq邮箱发邮件 绍兴电信 安徽双线服务器 最漂亮的qq空间 更多