Oracle数据库产品介绍

©2007Oracle版权所有第0页InsertPictureHere芦克强芦克强芦克强芦克强售前技术顾问售前技术顾问售前技术顾问售前技术顾问数据库产品介绍数据库产品介绍数据库产品介绍数据库产品介绍©2007Oracle版权所有第1页提纲提纲提纲提纲
高可靠的集群数据库高可靠的集群数据库高可靠的集群数据库高可靠的集群数据库(RAC)
海量数据管理的利器海量数据管理的利器海量数据管理的利器海量数据管理的利器(PARTITIONING)
事半功倍的管理工具事半功倍的管理工具事半功倍的管理工具事半功倍的管理工具(OEM)
数据安全的保障数据安全的保障数据安全的保障数据安全的保障(databasesecurity)
灾难备份恢复灾难备份恢复灾难备份恢复灾难备份恢复(DataGuard)©2007Oracle版权所有第2页Oracle集群基本结构集群基本结构集群基本结构集群基本结构集群数据库集群数据库集群数据库集群数据库磁盘系统磁盘系统磁盘系统磁盘系统高速互连网络高速互连网络高速互连网络高速互连网络光纤交换机光纤交换机光纤交换机光纤交换机公共网络公共网络公共网络公共网络EM中央控制台中央控制台中央控制台中央控制台StorageAreaNetwork低延迟网络互连低延迟网络互连低延迟网络互连低延迟网络互连用户程序用户程序用户程序用户程序防止单点失败防止单点失败防止单点失败防止单点失败共共共共享享享享缓缓缓缓存存存存©2007Oracle版权所有第3页ExtractServers1.Extractfromsourcesystems2.Integrate,transform,anddenormalize3.Queryandanalyze4.DataaccessandpublishingETLManager2ndpairofidenticalRACclustersmeans‘noneedforbackup’foractiveonlinedata8nodesx4CPUs12TB+STAGEAmazon’sDataWarehouseGridOracleDatabase10gRACandASMonLinux16nodesx4CPUs65TBQUERY©2007Oracle版权所有第4页Oracle10gRAC的体系架构的体系架构的体系架构的体系架构publicnetworkoperatingSystemCRSOracle10gRACinstance1server1sharedstorageredologinstance1…redologinstance3…controlfilesdatabasefilesserver2operatingsystemCRSOracle10gRACInstance2clusterinterconnectcachetocacheDBcacheDBcacheocr/var/opt/oracle/ocr.locvoting/var/opt/oracle/ocr.locServer3,4,….©2007Oracle版权所有第5页ClusterWare©2007Oracle版权所有第6页OracleClusterwareRun-TimeViewinitcrsdocssdevmdactionactionactionracgevtfcalloutevmloggeroprocdcalloutcalloutOCRVotingdiskracgimonracgimonracgimonracgwrap+racgmain©2007Oracle版权所有第7页©2007Oracle版权所有第8页ManuallyControlOracleClusterwareStack•Mightbeneededforplannedoutages:#crsctlstopcrs#crsctlstartcrs#crsctldisablecrs#crsctlenablecrs©2007Oracle版权所有第9页CRSResources•AresourceisaCRS-managedapplication.•ApplicationprofileattributesarestoredinOCR:•Checkinterval•Failurepolicies•Anactionscriptmustbeableto:•Starttheapplication•Stoptheapplication•Checktheapplication•Lifecycleofaresource:crs_profilecrs_registercrs_startcrs_statcrs_relocatecrs_stopcrs_unregister•Actionscript•Privileges•Dependencies•…©2007Oracle版权所有第10页RACResources$CRSHOME/bin/crs_stat-tNameTypeTargetStateHost----------------------------------------------------------------ora.atlhp8.ASM1.asmapplicationONLINEONLINEatlhp8ora.atlhp8.LISTENER_ATLHP8.lsnrapplicationONLINEONLINEatlhp8ora.atlhp8.gsdapplicationONLINEONLINEatlhp8ora.atlhp8.onsapplicationONLINEONLINEatlhp8ora.atlhp8.vipapplicationONLINEONLINEatlhp8ora.atlhp9.ASM2.asmapplicationONLINEONLINEatlhp9ora.atlhp9.LISTENER_ATLHP9.lsnrapplicationONLINEONLINEatlhp9ora.atlhp9.gsdapplicationONLINEONLINEatlhp9ora.atlhp9.onsapplicationONLINEONLINEatlhp9ora.atlhp9.vipapplicationONLINEONLINEatlhp9ora.xwkE.JF1.csapplicationONLINEONLINEatlhp8ora.xwkE.JF1.xwkE1.srvapplicationONLINEONLINEatlhp8ora.xwkE.JF1.xwkE2.srvapplicationONLINEONLINEatlhp9ora.xwkE.dbapplicationONLINEONLINEatlhp9ora.xwkE.xwkE1.instapplicationONLINEONLINEatlhp8ora.xwkE.xwkE2.instapplicationONLINEONLINEatlhp9©2007Oracle版权所有第11页MainVotingDiskFunctionNode1Node2CSSCSSVotingdiskNode3CSSNode1Node2CSSCSSVotingdiskNode3CSSNodescanseeeachother.Node3cannolongercommunicatethroughprivateinterconnect.Othersnolongerseeitsheartbeatsandevictthatnodebyusingthevotingdisk.Idonotsee3Isee1&22see1&2=Weshouldevict3!1&Isee1&2Isee3I’vebeenevicted!I’dbetterstopWeallsee1&2&3Weallsee1&2&3Weallsee1&2&3Split-brain©2007Oracle版权所有第12页ImportantCSSParameters•MISSCOUNT:•Representsnetworkheartbeattimeouts•DeterminesdiskI/Otimeoutsduringreconfiguration•Defaultsto30seconds(60forLinux)•Defaultsto600whenusingvendor(non-Oracle)clusterware•Shouldnotbechanged•DISKTIMEOUT:•RepresentsdiskI/Otimeoutsoutsidereconfiguration•Defaultsto200seconds•CanbetemporarilychangedwhenexperiencingverylongI/Olatenciestovotingdisks:1.ShutdownOracleClusterwareonallnodesbutone.2.Asrootonavailablenode,use:crsctlsetcssdisktimeoutM+13.Rebootavailablenode.4.Restartallothernodes.©2007Oracle版权所有第13页MultiplexingVotingDisks•Votingdiskisavitalresourceforyourclusteravailability.•Useonevotingdiskifitisstoredonareliabledisk.•Otherwise,usemultiplexedvotingdisks:•Thereisnoneedtorelyonmultipathingsolutions.•Multiplexedcopiesshouldbestoredonindependentdevices.•MakesurethatthereisnoI/Ostarvationforyourvotingdisksdevices.•Useatleastthreemultiplexedcopies.•CSSusesasimplemajorityruletodecidewhethervotingdiskreadsareconsistent:v=f*2+1©2007Oracle版权所有第14页ChangeVotingDiskConfiguration•Votingdiskconfigurationcanbechangeddynamically.•Toaddanewvotingdisk:•Toremoveavotingdisk:•IfOracleClusterwareisdownonallnodes,usethe–forceoption:#crsctladdcssvotedisknewvotingdiskpath#crsctldeletecssvotediskoldvotingdiskpath#crsctldeletecssvotediskoldvotingdiskpath-force#crsctladdcssvotedisknewvotingdiskpath-force©2007Oracle版权所有第15页BackUpandRecoverYourVotingDisks•Recommendationistousesymboliclinks.•Backuponevotingdiskbyusingtheddcommand.•AfterOracleClusterwareinstallation•Afternodeadditionordeletion•Canbedoneonline•Recovervotingdisksbyrestoringthefirstoneusingtheddcommand,andthenmultiplexitifnecessary.•Ifnovotingdiskbackupisavailable,reinstallOracleClusterwar