Ara Shakian Principal Product Manager Oracle Server Technologies

2. Thinking Out of the Box Re-defining Database Storage Management Ara ShakianPrincipal Product Manager Oracle Server Technologies

3. Agenda <Insert Picture Here> • What is Automatic Storage Management (ASM) • Functionality and architecture • Admin roles and responsibilities • Managing ASM is simple • Three flexible management interfaces • ASM utilities • Oracle Database11g ASM beta features • Customer proof points • Summary

4. ASM Disk ASM Disk ASM Disk ASM Disk ASM Disk Automatic Storage Management ASMDisk Group A storage manager designed to manage Oracle Database files • Volume Manager • 1MB/128KB striping • Flexible mirroring • Online disk reconfigurations and • automatic rebalancing • File System • Even data distribution with optimal • performance • Automatic file management using • Oracle Managed Files (OMF) +DATA datafiles file1… filen controlfile redolog1 • Cluster support with Oracle Clusterware

5. LUN ASM High Level Architecture Database Instance ASM • File layout info- Update statistics- Health info SGA • An Integrated Solution • ASM manages meta-data • NOT in IO path • Optimal Performance ASM ASM file extents Service Requests DB Processes DB I/O

6. Simplifies and Automates Increases Storage Utilization Uptime & Agility Predictable Performance & Availability ASM Key Values Reduce Cost and Complexity Without CompromisingPerformance or Availability No addition cost!

7. <Insert Picture Here> Storage ManagementRoles & Responsibilities

8. ASM Admin Role Storage and ASM Administration SYS Admin Role Pre-Installation • Create LUNs • Set ownership & permissions to ‘Oracle User’ • Installation • Oracle Universal Installer (OUI) • Conf Assistants • Create disk groups • Normal Operation • Monitor capacity & availability • Provision capacity

9. ASM Reduces Management Complexity Eliminate • LVM mgt for Oracle DB • File system mgt for Oracle DB • 3rd party clustering software • File name management • Reshuffling, reallocating, moving datafiles • I/O performance tuning • Reduce significantly • LUN mgt (larger LUNs) • Less frequent DBA & sys admin interaction • Manual error prone tasks • Troubleshooting • Expanding Capacity

10. Traditional LVM/FS vs ASM Add Capacity ASM Add Disk to OS Add disk to a disk group! LVM/FS 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

11. <Insert Picture Here> Managing ASM is Simple Three Flexible Management Interfaces • EM Database Control or Grid Control • SQL*Plus interface • ASMCMD tool

12. ASM Home Page

13. ASM Performance Page

14. ASM Administration Page

15. ASM Configuration Page

16. <Insert Picture Here> Three Flexible Management Interfaces • EM Database Control or Grid Control • SQL*Plus interface • ASMCMD tool

17. ASM SQL*PLUS Command Structure 1 • Create Disk Group • SQL> create diskgroup DataDG normal redundancy 2 failgroup controller1 disk 3 ‘/devices/diska1, ‘/devices/diska2’ 4 failgroup controller2 disk 5 ‘/devices/diskb1, ‘/devices/diskb2’; • Delete a Disk Group • SQL> drop diskgroup DataDG; 2

18. Alter diskgroup SQL*Plus Command Structure Alter Disk Group 3 • alter diskgroup DataDG ADD/DROP/RESIZE disk … • alter diskgroup … MOUNT/DISMOUNT … • alter diskgroup … ADD/ALTER/DROP TEMPLATE … • alter diskgroup … ADD/DROP DIRECTORY/ALIAS/FILE … • Select all V$ASM_* views

19. ASM Views - Examples

20. <Insert Picture Here> Three Flexible Management Interfaces • EM Database Control or Grid Control • SQL*Plus interface • ASMCMD tool Empower the Sys Admin and DBA

21. ASM Command Line Interface (CLI) ASM File Management • Interactive Unix shell-like CLI for ASM file administration • ASMCMD> ls • Non-interactive CLI mode for scripting and batch processing • ASMCMD ls –lH +DATAFILE/ORCL/CONTROLFILE

22. <Insert Picture Here> ASM Utilities Simplify Data Transfer and Migration

23. ASM Migration Utility with EM Grid Control • Database migration • Migrate DB files and recovery area to ASM using RMAN • Wizard walk-through • Create migration requests • Schedule migration requests • Report/monitor status of migration

24. ASM and XML DB Interface • ASM files can be • accessed from XML DB • virtual folders /sys/asm • ASM files can be • manipulated • HTTP/WebDAV • FTP • DBMS_XDB API

25. Enhanced Migration OptionsDBMS_FILE_TRANSFER Utility • ASM to ASM • ASM to O/S file (new) • O/S file to ASM (new) • O/S file to O/S file

26. <Insert Picture Here> Oracle Database 11g ASM Beta Features

27. Manageability Enhancements SYSASM Role ASM 11gR2 Rolling Migration - Disk Group Attributes - ASMCMD lsdisk- Metadata backup/restore- Off-line faster rebalance - CONNECT / AS SYSASM Preferred Mirror Read X Transient Failures X Fast VLDB Start Fast Disk Resync - Variable File Extents- Larger AUs - Incremental Repair ASM 11g Beta Features RAC/ASM 11gR1 RAC ASM - Disk Group Attributes Network LUN LUN LUN LUN

28. Hundreds of ASM Customers In Production

29. What Talk America is Saying “ASM is the best thing that has happened to databases since SQL.” “ASM alone makes 10g worth while.” “Storage has become a commodity, I only need to present it to 10g and ASM does the rest.” Laurence Grant, Dir. of Enterprise Computing SystemsTalk America Holdings, Inc.

30. What Burlington Coat Factory is Saying “Oracle Database 10g, RAC, ASM and RMAN empower an investment payback in 12 months, 50% improved storage utilization, 100% improved CPU utilization and much faster to backup and recovery” Michael Prince Chief Technology Officer

31. Mgt Overhead RAW FS ASM Time Conclusion Which management style would you prefer? * Not based on real statistics

32. ASM Featured in OOW 2006

33. Q & A