1 / 23

Simplify your Job – Automatic Storage Management

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

dale
Download Presentation

Simplify your Job – Automatic Storage Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Session id: 40140 Simplify your Job – Automatic Storage Management Angelo

  2. Mgmt Gap Storage Management Gap Avg. Managed Capacity per Administrator In Database Sites with >100 GB Capacity

  3. 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

  4. 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

  5. 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”

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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”

  15. 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

  16. ASM Improves Performance 22,648 20,418

  17. 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

  18. 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

  19. 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

  20. 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

  21. Reminder – please complete the OracleWorld online session surveyThank you.

  22. Q & Q U E S T I O N S A N S W E R S

More Related