Simplify your Job

1
Simplify your Job Automatic Storage Management
Session id 40140

• Angelo

2
Storage Management Gap
Avg. Managed Capacity per Administrator In
Database Sites with gt100 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
ASM How it Works

• No volumes just a pool of storage

Automatic Storage Management
6
ASM How it Works

• No volumes just a pool of storage
• Partitions total disk space into uniform sized
  megabyte units

Automatic Storage Management
7
ASM How it Works

• No volumes just a pool of storage
• Partitions total disk space into uniform sized
  megabyte units
• Units assigned to a file are managed and tracked
  by ASM

Automatic Storage Management
8
ASM How it Works

• No volumes just a pool of storage
• Partitions total disk space into uniform sized
  megabyte units
• Units assigned to a file are managed and tracked
  by ASM
• Online add/remove of disk with automatic
  rebalancing

Automatic Storage Management
9
ASM How it Works

• No volumes just a pool of storage
• Partitions total disk space into uniform sized
  megabyte units
• Units assigned to a file are managed and tracked
  by ASM
• Online add/remove of disk with automatic
  rebalancing

Automatic Storage Management
10
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
11
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

12
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
13
Where DBAs Spend Their Time
Installation 6
Others 15
DataLoading 6
Ongoing System Management 55
Source IOUG 2001 DBA Survey
14
ASM Functions Drill Down

• Getting started
• Defining a DB
• Adding/deleting/migrating storage
• Hot spots
• Storage fragmentation

15
Traditional vs ASM - Setup

1. Determine required storage capacity
2. Install Volume Manager, File System
3. Architect data layout to avoid hot spot
4. Create logical volumes
5. Create file systems
6. Install database
7. Create database

1. Determine required storage capacity
2. Install ASM
3. Create Disk Groups
4. Install database
5. Create database

16
Traditional vs ASM Add Disk

1. Add Disk to OS
2. Create volume(s) with Volume Manager
3. Create File System over volume
4. Figure out data to move to new disk
5. Move data to new files
6. Rename files in database
7. Re-tune I/O

1. Add Disk to OS
2. Issue the Add Disk command

17
Traditional vs ASM Remove Disk

1. List all data that is on disk
2. Choose existing filesystem to hold data from
   dropped disk
3. Move data to new files
4. Rename files in database
5. Remove disk from OS
6. Re-tune I/O

1. Issue drop disk command
2. Remove the disk from OS when Oracle says it is
   done

18
Traditional vs ASM Migrate Data

1. Add new disks to OS
2. Figure out new location on other disks
3. Create volume(s) with Volume Manager
4. Create new FS
5. Move data to new files
6. Rename files in database
7. Remove old disks from OS
8. Re-tune I/O

1. Add new disks to OS
2. Issue Add disk command for new disks
3. Issue Drop Disk command for old disks
4. Remove old disks from OS when Oracle says it is
   done

19
Traditional vs ASM Tune I/O

1. Daily monitor I/O performance
2. Discover hot spots
3. Figure out how to remove hot spots
4. Move data to new files
5. Rename files in database
6. Verify that hot spot is gone

• This space intentionally left blank

20
Traditional vs ASM Manage Space

1. Daily monitor storage utilization
2. Discover fragmentation
3. Figure out how to remove fragmentation
4. Move data to new files
5. Rename files in database
6. Verify that fragmentation is gone

• This space intentionally left blank

21
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
22
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
23
ASM Improves Performance
22,648
20,418
24
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

25
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

26
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

27
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 100 today)
• Steve Adams IXORA
• Rich Long Oracle
• Watch OTN for more details on ASM

28
Reminder please complete the OracleWorld
online session surveyThank you.
29
(No Transcript)
30
(No Transcript)