230 likes | 427 Views
Session id: 40140. Simplify your Job – Automatic Storage Management. Angelo. Mgmt Gap. Storage Management Gap. Avg. Managed Capacity per Administrator In Database Sites with >100 GB Capacity. DBA Storage Challenges. Databases are rapidly growing in size
E N D
Session id: 40140 Simplify your Job – Automatic Storage Management Angelo
Mgmt Gap Storage Management Gap Avg. Managed Capacity per Administrator In Database Sites with >100 GB Capacity
DBA Storage Challenges • Databases are rapidly growing in size • DBAs have to manage thousands of data files • Decreasing windows of scheduled downtime • Storage resources involve many organizations • Database Admin • Systems Admin • Storage Admin • Network Admin • Management of database storage is increasing in complexity and cost
Automatic Storage Management (ASM) • Portable, high performance cluster file system • Data is spread across disks to balance load • Integrated mirroring across disks • Removes need for third-party volume manager and file system Automatic Storage Management
0010 0010 0010 0010 0010 0010 0010 0010 0010 0010 The Operational Stack ASM TODAY Tables Tables Tablespace Oracle ASM Tablespace Files Files File System File System Logical Vol Logical Vol Disks Disk Group “The best way to lower mgmt costs is to remove complexity”
Data Mirroring with ASM • ASM can mirror data across storage arrays • No additional logging or expensive NVRAM to recover mirrors • Database logging recovers mirrors • Designed to tolerate component failures
Disk Groups & Failure Groups • Storage resources organized into Disk Groups and Failure Groups • A Disk Group is a collection of disks managed as a logical unit in which ASM files are stored • Disk Groups assigned by DBAs • A Failure Group is a set of disks sharing a common resource whose failure needs to be tolerated • Redundant copies of an extent are stored in separate Failure Groups • Failure Groups assigned by DBAs or automatically by ASM Controller 1 Controller 2 Failure Group 1 Failure Group 2 Disk Group
Determine required storage capacity Install Volume Manager, File System Architect data layout to avoid hot spot Create logical volumes Create file systems Install database Create database Determine required storage capacity Install ASM Create Disk Groups Install database Create database Traditional vs ASM - Setup
Add Disk to OS Create volume(s) with Volume Manager Create File System over volume Figure out data to move to new disk Move data to new files Rename files in database Re-tune I/O Add Disk to OS Issue the Add Disk command Traditional vs ASM – Add Disk
List all data that is on disk Choose existing filesystem to hold data from dropped disk Move data to new files Rename files in database Remove disk from OS Re-tune I/O Issue drop disk command Remove the disk from OS when Oracle says it is done Traditional vs ASM – Remove Disk
Add new disks to OS Figure out new location on other disks Create volume(s) with Volume Manager Create new FS Move data to new files Rename files in database Remove old disks from OS Re-tune I/O Add new disks to OS Issue Add disk command for new disks Issue Drop Disk command for old disks Remove old disks from OS when Oracle says it is done Traditional vs ASM – Migrate Data
Daily monitor I/O performance Discover hot spots Figure out how to remove hot spots Move data to new files Rename files in database Verify that hot spot is gone This space intentionally left blank Traditional vs ASM – Tune I/O
Daily monitor storage utilization Discover fragmentation Figure out how to remove fragmentation Move data to new files Rename files in database Verify that fragmentation is gone This space intentionally left blank Traditional vs ASM – Manage Space
ASM Lowers Management Costs 8 7 7 6 6 6 5 4 2 2 0 0 “Best way to save costs is to remove complexity”
ASM Enables Consolidated Clustered Storage ASM Instance ASM Instance ASM Instance ASM Instance ASM Instance Oracle DB Instance Oracle DB Instance Oracle DB Instance Oracle DB Instance Oracle DB Instance Non – RAC Databases Clustered Servers ASM – Clustered Pool of Storage
ASM Improves Performance 22,648 20,418
ASM - Integrated with Key Storage Hardware • ASM-Lib is an Open Interface extending ASM • Vendor library for disk discovery and I/O • Efficient I/O interface • Data description allows end-to-end validation (HARD Initiative) • Several participating storage vendors and others are in the process of joining
ASM - Summary New capability in Oracle 10g Database • Provides a vertical integration of the file system and volume manager for Oracle database files • Spreads database files across all available storage for optimal performance and resource utilization • Enables simple and non-intrusive resource allocation and provides automatic rebalancing
ASM Benefits Increases the productivity of the DBA • Simplified management interface for storage resources • Eliminates manual I/O performance tuning tasks • Virtualizes the storage to a set of disk groups • Provides mainframe class performance at lower cost
Next Steps…. • Automatic Storage Management Demo in the Oracle DEMOgrounds • Pod 5DD • Pod 5QQ • Technical Paper on ASM – The New Best Practice (room 103 at 1:00 today) • Steve Adams – IXORA • Rich Long – Oracle • Watch OTN for more details on ASM
Reminder – please complete the OracleWorld online session surveyThank you.
Q & Q U E S T I O N S A N S W E R S