补充实例-Oracle存储管理PPT.ppt

Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,Click to edit Master title style,Oracle Database 10,g,:,A Revolution in Database Technology,Problem:Islands of Computation,Limited scalability,no resource sharing,Must be configured for peak loads,Single point of failure,Slow to adjust to business needs,Financials,Procurement,Service,Supply,Chain,Files,Sales,HR,Grid Computing Eliminates Islands of Computation,High h/w&s/w costs,Separate servers,Configured for peak,Single point of failure,Hard to change,Difficult to manage,Low cost components,Shared servers,Capacity on demand,Fault tolerant,Flexible,Unified management,Grid Solution,Coordinated use of many small servers acting as one large computer.,IT Problem,Automatic Storage,Management,Automatic Storage Management,Eliminates need for conventional file system and volume manager,Capacity on demand,Add/drop disks online,Automatic I/O load balancing,Stripes data across disks to balance load,Best I/O throughput,Automatic mirroring,Easy,ASM How it Works,Automatic Storage,Management,No volumes:just a pool of storage,Partitions total disk space into uniform sized megabyte units,ASM How it Works,Automatic Storage,Management,No volumes:just a pool of storage,Partitions total disk space into uniform sized megabyte units,Efficient,online add/remove of disk with automatic rebalancing,ASM How it Works,No volumes:just a pool of storage,Partitions total disk space into uniform sized megabyte units,Efficient,online add/remove of disk with automatic rebalancing,Automatic Storage,Management,Automatic Storage Management Summary,Low Cost,Eliminates need for volume manager and file systems,Works well with inexpensive,modular storage,Gives better storage utilization,Easy up to 50%less DBA/Sys Admin work,Fault tolerant,Raw disk performance,Capacity on demand,Automatic I/O load balancing,ASM Mirroring,Storage Failure,Protection,Flashback,Human Error,Protection,Data Guard,Site Failure Protection,Flash Recovery Area,Corruption,Protection,Storage Grid-Highest Data Protection at Lowest Cost,ERP,CRM,DW,Database Server Grid Real Application Clusters,Runs Real Applications,Proven,Over 500 production sites,Certified with leading Applications,Runs on standard,low cost servers,Fault tolerant,Database Server Grid-Integrated Clusterware,Portable to all platforms,Low Cost,No need to purchase additional software,Easy to install,manage,Easy,Deploys in hours not days,Improved single system image,Single-vendor support,Remains open to third-party clusterware,Database Server Grid Automatic Workload Management,Push-button,online add/drop server to cluster via Grid Control,Automatic Workload Management,Based on“service”concept,Automatic routing of service connection requests to appropriate server with lowest load,On server failure,automatic re-allocation of surviving servers to services,Automatic Workload Management,Normal Server Allocation,Order Entry,Supply Chain,Spare,Automatic Workload Management,End of Quarter,Order Entry,Supply Chain,Automatic Workload Management,Normal Server Allocation,Order Entry,Supply Chain,Spare,Automatic Workload Management,Server Fails,Order Entry,Supply Chain,Spare,Automatic Workload Management,Reallocate Spare server to Order Entry,Order Entry,Supply Chain,Automatic Workload Management,Order Entry,Supply Chain,Spare,Failed Server Restored,Failure Notification,Fast,coordinated recovery without human intervention,Oracle RAC 10g signals Application Server 10g when instances failures occur,Immediate recovery for mid-tiers,4 seconds from 15 minutes,self correcting,ERP,CRM,DW,Business Challenge How to Scale DBAs to the Grid?,Software Maintenance 6%,Ongoing System Management 55%,Installation 6%,Others,15%,Creation&Configuration 12%,Source:IOUG 2001 DBA Survey,DataLoading 6%,Oracle Database Self-Managing Database,Built-in Intelligent Infrastructure,Code instrumentation,Workload repository,Automation of Routine Tasks,Automatic disk-based Backup and Recovery,Automatic optimizer statistics collection,Automatic Memory Management,Automatic Storage Management,Tools to Empower the DBA,Automatic Database Diagnostic Monitor,Automatic Tuning Optimizer,Lots more,Oracle OEM Grid Control,Manages the Oracle Grid environment,Scales to thousands of servers,Application Service Level Management,Measure SLAs,Configuration Management,Provisioning,Cloning,Patch Management,ERP,CRM,DW,Business Intelligence on the Grid,Lower Cost,Leverage hardware,software,labor savings,Manage millions of terabytes,Intelligence when you need it,Cross-platform transportable tablespaces,Asynchronous change data capture,More value from your data,Mature OLAP,Data Mining,Improved SQL Analytics SQL Model Clause,HTML DB Rapid Web Development Tool,Builds database-driven Web applications,For non-programmers,App developers and app users just need a web browser,Addresses MS Access proliferation problem,Supports hosted development and deployment environment,