补充实例 Oracle存储管理PPT

OracleDatabase10g:ARevolutioninDatabaseTechnology,Problem:IslandsofComputation,Limitedscalability,noresourcesharingMustbeconfiguredforpeakloadsSinglepointoffailureSlowtoadjusttobusinessneeds,Financials,Procurement,Service,SupplyChain,Files,Sales,HR,GridComputingEliminatesIslandsofComputation,Highh/w&s/wcostsSeparateserversConfiguredforpeakSinglepointoffailureHardtochangeDifficulttomanage,LowcostcomponentsSharedserversCapacityondemandFaulttolerantFlexibleUnifiedmanagement,GridSolution,Coordinateduseofmanysmallserversactingasonelargecomputer.,ITProblem,AutomaticStorageManagement,AutomaticStorageManagement,EliminatesneedforconventionalfilesystemandvolumemanagerCapacityondemandAdd/dropdisksonlineAutomaticI/OloadbalancingStripesdataacrossdiskstobalanceloadBestI/OthroughputAutomaticmirroringEasy,ASMHowitWorks,AutomaticStorageManagement,Novolumes:justapoolofstoragePartitionstotaldiskspaceintouniformsizedmegabyteunits,ASMHowitWorks,AutomaticStorageManagement,Novolumes:justapoolofstoragePartitionstotaldiskspaceintouniformsizedmegabyteunitsEfficient,onlineadd/removeofdiskwithautomaticrebalancing,ASMHowitWorks,Novolumes:justapoolofstoragePartitionstotaldiskspaceintouniformsizedmegabyteunitsEfficient,onlineadd/removeofdiskwithautomaticrebalancing,AutomaticStorageManagement,AutomaticStorageManagementSummary,LowCostEliminatesneedforvolumemanagerandfilesystemsWorkswellwithinexpensive,modularstorageGivesbetterstorageutilizationEasyupto50%lessDBA/SysAdminworkFaulttolerantRawdiskperformanceCapacityondemandAutomaticI/Oloadbalancing,DataGuardSiteFailureProtection,StorageGrid-HighestDataProtectionatLowestCost,ERP,CRM,DW,DatabaseServerGridRealApplicationClusters,RunsRealApplicationsProvenOver500productionsitesCertifiedwithleadingApplicationsRunsonstandard,lowcostserversFaulttolerant,DatabaseServerGrid-IntegratedClusterware,PortabletoallplatformsLowCostNoneedtopurchaseadditionalsoftwareEasytoinstall,manageEasyDeploysinhoursnotdaysImprovedsinglesystemimageSingle-vendorsupportRemainsopentothird-partyclusterware,DatabaseServerGridAutomaticWorkloadManagement,Push-button,onlineadd/dropservertoclusterviaGridControlAutomaticWorkloadManagementBasedon“service”conceptAutomaticroutingofserviceconnectionrequeststoappropriateserverwithlowestloadOnserverfailure,automaticre-allocationofsurvivingserverstoservices,AutomaticWorkloadManagement,NormalServerAllocation,OrderEntry,SupplyChain,Spare,AutomaticWorkloadManagement,EndofQuarter,OrderEntry,SupplyChain,AutomaticWorkloadManagement,NormalServerAllocation,OrderEntry,SupplyChain,Spare,AutomaticWorkloadManagement,ServerFails,OrderEntry,SupplyChain,Spare,AutomaticWorkloadManagement,ReallocateSpareservertoOrderEntry,OrderEntry,SupplyChain,AutomaticWorkloadManagement,OrderEntry,SupplyChain,Spare,FailedServerRestored,FailureNotification,Fast,coordinatedrecoverywithouthumaninterventionOracleRAC10gsignalsApplicationServer10gwheninstancesfailuresoccurImmediaterecoveryformid-tiers4secondsfrom15minutesselfcorrecting,BusinessChallengeHowtoScaleDBAstotheGrid?,SoftwareMaintenance6%,OngoingSystemManagement55%,Installation6%,Others15%,Creation&Configuration12%,Source:IOUG2001DBASurvey,DataLoading6%,OracleDatabaseSelf-ManagingDatabase,Built-inIntelligentInfrastructureCodeinstrumentationWorkloadrepositoryAutomationofRoutineTasksAutomaticdisk-basedBackupandRecoveryAutomaticoptimizerstatisticscollectionAutomaticMemoryManagementAutomaticStorageManagementToolstoEmpowertheDBAAutomaticDatabaseDiagnosticMonitorAutomaticTuningOptimizerLotsmore,OracleOEMGridControl,ManagestheOracleGridenvironmentScalestothousandsofserversApplicationServiceLevelManagementMeasureSLAsConfigurationManagementProvisioningCloningPatchManagement,BusinessIntelligenceontheGrid,LowerCostLeveragehardware,software,laborsavingsManagemillionsofterabytesIntelligencewhenyouneeditCross-platformtransportabletablespacesAsynchronouschangedatacaptureMorevaluefromyourdataMatureOLAP,DataMiningImprovedSQLAnalyticsSQLModelClause,HTMLDBR