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

LightNode(7.71美元),免认证高质量香港CN2 GIA

LightNode是一家位于香港的VPS服务商.提供基于KVM虚拟化技术的VPS.在提供全球常见节点的同时,还具备东南亚地区、中国香港等边缘节点.满足开发者建站,游戏应用,外贸电商等应用场景的需求。新用户注册充值就送,最高可获得20美元的奖励金!成为LightNode的注册用户后,还可以获得属于自己的邀请链接。通过你的邀请链接带来的注册用户,你将直接获得该用户的消费的10%返佣,永久有效!平台目前...

NameCheap 2021年新年首次活动 域名 域名邮局 SSL证书等

NameCheap商家如今发布促销活动也是有不小套路的,比如会在提前一周+的时间告诉你他们未来的活,比如这次2021年的首次活动就有在一周之前看到,但是这不等到他们中午一点左右的时候才有正式开始,而且我确实是有需要注册域名,等着看看是否有真的折扣,但是实际上.COM域名力度也就一般需要51元左右,其他地方也就55元左右。当然,这次新年的首次活动不管如何肯定是比平时便宜一点点的。有新注册域名、企业域...

bluehost32元/月,2核2G/20GB空间,独立ip,新一代VPS美国云主机!

bluehost怎么样?bluehost推出新一代VPS美国云主机!前几天,BlueHost也推出了对应的周年庆活动,全场海外虚拟主机月付2.95美元起,年付送免费的域名和SSL证书,通过活动进入BlueHost中文官网,购买虚拟主机、云虚拟主机和独立服务器参与限时促销。今天,云服务器网(yuntue.com)小编给大家介绍的是新一代VPS美国云主机,美国SSD云主机,2核2G/20GB空间,独立...

oracle数据库学习为你推荐
公司网络被攻击最近公司频繁的受到网络攻击,导致网络瘫痪,又碰到arp攻击,有病毒的,有点崩溃。。。摩拜超15分钟加钱怎么领取摩拜单车免费卷特朗普取消访问丹麦特朗普首次出访为什么选择梵蒂冈微信回应封杀钉钉为什么微信被封以后然后解封了过了一会又被封了百度关键词工具如何利用百度关键词推荐工具选取关键词haole10.comwww.qq10eu.in是QQ网站吗斗城网女追男有多易?喜欢你,可我不知道你喜不喜欢我!!平安夜希望有他陪我过www.ijinshan.com桌面上多了一个IE图标,打开后就链接到009dh.com这个网站,这个图标怎么删掉啊?45gtv.comLETSCOM是什么牌子?惠丰吧毕节医药高等专科可以专升本吗
网页空间租用 欧洲欧洲vps arvixe cpanel 鲨鱼机 idc评测网 国外bt gitcafe 英语简历模板word 512au 私有云存储 web服务器架设软件 亚洲小于500m 小米数据库 服务器维护方案 asp免费空间申请 美国免费空间 umax120 息壤代理 视频服务器是什么 更多