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

NameCheap黑色星期五和网络礼拜一

如果我们较早关注NameCheap商家的朋友应该记得前几年商家黑色星期五和网络星期一的时候大促采用的闪购活动,每一个小时轮番变化一次促销活动而且限量的。那时候会导致拥挤官网打不开迟缓的问题。从去年开始,包括今年,NameCheap商家比较直接的告诉你黑色星期五和网络星期一为期6天的活动。没有给你限量的活动,只有限时六天,这个是到11月29日。如果我们有需要新注册、转入域名的可以参加,优惠力度还是比...

RackNerd :美国大硬盘服务器促销/洛杉矶multacom数据中心/双路e5-2640v2/64G内存/256G SSD+160T SAS/$389/月

大硬盘服务器、存储服务器、Chia矿机。RackNerd,2019年末成立的商家,主要提供各类KVM VPS主机、独立服务器和站群服务器等。当前RackNerd正在促销旗下几款美国大硬盘服务器,位于洛杉矶multacom数据中心,亚洲优化线路,非常适合存储、数据备份等应用场景,双路e5-2640v2,64G内存,56G SSD系统盘,160T SAS数据盘,流量是每月200T,1Gbps带宽,配5...

Digital-VM:服务器,$80/月;挪威/丹麦英国/Digital-VM:日本/新加坡/digital-vm:日本VPS仅$2.4/月

digital-vm怎么样?digital-vm在今年1月份就新增了日本、新加坡独立服务器业务,但是不知为何,期间终止了销售日本服务器和新加坡服务器,今天无意中在webhostingtalk论坛看到Digital-VM在发日本和新加坡独立服务器销售信息。服务器硬件是 Supermicro、采用最新一代 Intel CPU、DDR4 RAM 和 Enterprise Samsung SSD内存,默认...

oracle数据库学习为你推荐
淘宝门户淘宝社区怎么进?Baby被问婚变绯闻黄晓明baby一起出来带娃,想要打破离婚传闻?安徽汽车网合肥汽车站网上售票微信回应封杀钉钉微信违规操作被封了,地图应用什么地图导航最好用最准确商标注册流程及费用我想注册商标一般需要什么流程和费用?老虎数码1200万相素的数码相机都有哪些款?大概价钱是多少?李子柒年入1.6亿宋朝鼎盛时期 政府财政收入有将近1亿贯铜钱,那么GDP是多少呢?丑福晋谁有好看的言情小说介绍下www4399com4399小游戏 请记住本站网站 4399.url
qq域名邮箱 中国十大域名注册商 美国linux主机 域名主机管理系统 buyvm 香港加速器 网站监控 云主机51web windows2003iso 主机合租 浙江独立 元旦促销 空间出租 已备案删除域名 免费全能主机 亚马逊香港官网 服务器干什么用的 优酷黄金会员账号共享 云营销系统 监控服务器 更多