Oracle RAC 原理 ( 40 )

Copyright©OracleCorporation,2002[e-mail]908-420-3053Copyright©OracleCorporation,2002.Allrightsreserved.TypicalJobRequirementOurclientislookingforsomeonewithStrongOracleDBAexperience.TheyareimplementingOracleApplicationsandanyexperienceinOracleAppsisahugeplus.Thispersonmusthave5-7yearsOracleDBAexperience.MusthaveproventrackrecordinallareasofOracleDatabaseAdministration.ExpertiseinRAC(RealApplicationCluster)isamust.ExperienceinimplementingOracleRAConWindowsandLinuxenvironmentsisrequired.MusthavesignificantdatabaseperformancetuningexperienceandmustbeabletoruntheOracleEnterpriseManagerandStatspacktoshowthemetricstothecustomer.Lookingforateamplayerwithexcellentcommunicationanddocumentationskills.Copyright©OracleCorporation,2002.Allrightsreserved.StateoftheOracleDatabaseIndustry•Retirepension/goldwatch•BSCS,BSEE,MIS•MCSE,NovellCertified•OCP•OracleMasters•DataGuard•LinuxandOracle•RealApplicationClusters•Oracle10gGrid•Before1980s•1980s•Early1990s•Late1990s•2000•Now!•Now!•Now!•Stayingahead.Copyright©OracleCorporation,2002.Allrightsreserved.WhyshouldIchooseRealApplicationClusters?Copyright©OracleCorporation,2002.Allrightsreserved.WhyEnhanceMyCareer?•Resilienceagainst“bench”and“downtime”•Easiertransitiontonewenvironments•EnhancedperformanceandserviceresponsetimesCopyright©OracleCorporation,2002.Allrightsreserved.GridControlManagemultiplesystemswithonesystem:•OracleApplicationServer10g•OracleDatabase10g•OracleCollaborationSuite10g•OracleEnterpriseManager10gCopyright©OracleCorporation,2002.Allrightsreserved.WhatisRAC?InRealApplicationClustersenvironments,allactiveinstancescanconcurrentlyexecutetransactionsagainstashareddatabase.Copyright©OracleCorporation,2002.Allrightsreserved.WhatisRAC?TechnicalOverviewHardware•Nodes•Interconnect•SharedstorageforyourdataOperatingSoftware•ClusterSoftware-ClusterManager•OracleSoftware•OracleDatabaseandInstancesCopyright©OracleCorporation,2002.Allrightsreserved.NodesandTheirComponentsAnodehasthefollowingmaincomponents:•CPUs•Memory•Interconnect•StorageforOS,ClusterandOracleSoftware•OperatingSystemSoftware-OS•ClusterSoftwareorClusterManagerCopyright©OracleCorporation,2002.Allrightsreserved.InterconnectHighSpeednetworkconnectionfor:•Monitoring,message•Cachetransfer•Locktransfer•Extentsinformation•Freelistsinformation•Infiniband•FastEthernet•GigabitEthernetCopyright©OracleCorporation,2002.Allrightsreserved.SharedStorageThisiswherethedataandcontrolfileswillreside•RAW•Clusterfilesystem•NetworkAttachedStorage•StorageAreaNetwork•RAID•AutomaticStorageManagement–10gCopyright©OracleCorporation,2002.Allrightsreserved.RAWDevice•Havebeeninuseforalongtime•BypassestheOperatingSystembuffercache•Canbeusedin9ior10g•Difficulttomanage•HighperformanceCopyright©OracleCorporation,2002.Allrightsreserved.RAWDeviceOnRAWDevices•Datafiles•Redologfiles•Controlfiles•OracleClusterReadyfiles•VotingDiskOnLocalFileSystem•Archivelogfiles•OracleHome•Alert,Tracefiles•ExternalTables•VotingDiskCopyright©OracleCorporation,2002.Allrightsreserved.ClusterFileSystem•Providesasharedfilesystemforallclusternodes.•CansharedatafilesonOracleHomeinsamestoragearea.•Simpletomanage•UseofOracleManagedfiles•AUTOEXTENDfeature•VotingDiskCopyright©OracleCorporation,2002.Allrightsreserved.ClusterFileSystem•Datafiles•Redologfiles•Controlfiles•OracleClusterReadyfiles•Archivelogfiles•OracleHome•Alert,Tracefiles•ExternalTablesCopyright©OracleCorporation,2002.Allrightsreserved.AutomaticStorageManagement•Newstarontheblockfor10g•EaseofAdministration•ShouldgetalmostthesameperformanceofRAW•Eliminatestheneedforclusterfilesystem•Eliminatestheneedforvolumemanagement•NoSupportfor:•ExternalTables•TransportableTables•NoExport/ImportoutputfileCopyright©OracleCorporation,2002.Allrightsreserved.NodesandTheirComponentsnode1node2node3ClusterManagerClusterManagerClusterManagerOSOSOSCopyright©OracleCorporation,2002.Allrightsreserved.OperatingSystem•Linux•Windows•Solaris•HP•IBMAIX•RedhatandUnitedLinux•2000and2003•Cluster3.x(raw)andVeritasDBE(CFS)•Itanium,Tru64andTruCluster•4.2(raw)and5.1(both)CheckOraclecertificationMatrixandvendorsupplierstochooserightcombinationofRAC.Copyright©OracleCorporation,2002.Allrightsreserved.ClusterSoftware•ClusterReadyServices•Sun3.xorVeritasDBE•HACMP•Clusterservices•WindowsandLinux•SunSolaris•IBM•HPCopyright©OracleCorporation,2002.Allrightsreserved.RealApplicationClusters-SpecificInstanceProcessesInterconnectCommunicationCopyright©OracleCorporation,2002.Allrightsreserved.RACInstanceGlobalResourceDirectory–Trackingstatusoforacleblocks.AdditionalBackgroundprocesses:•LMON-MonitorInstancestatus•LMSn-CacheFusionmanagement•LCK-Enqueuerequests•LMD-Enqueuemanagement•DIAG-HealthofRACinstances•PMONrestartifitdies.Copyright©OracleCorporation,2002.Allrightsreserved.GlobalResourceDirectory•DataBlockIdentifier•Locationofmostcurrentversion•Modeofthedatablock•Null(N),Shared(S),orExclusive(X)•TheRoleofthedatablock•InformationofBuffercachesonmultiplenodesCopyright©OracleCorporation,2002.Allri