Corporate PPT Template

1
(No Transcript)
2
Thinking Out of the Box Re-defining Database
Storage Management
Ara ShakianPrincipal Product Manager Oracle
Server Technologies
3
Agenda
ltInsert Picture Heregt

• 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
Automatic Storage Management

• A storage manager designed to manage Oracle
  Database files

ASMDisk Group

• 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
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
ASM Key Values
Reduce Cost and Complexity Without
CompromisingPerformance or Availability
No addition cost!
7
Storage ManagementRoles Responsibilities
ltInsert Picture Heregt
8
ASM Admin Role
Storage and ASM Administration
SYS Admin Role

• Pre-Installation
• Create LUNs
• Set ownership permissions to Oracle User

• Normal Operation
• Monitor capacity availability
• Provision capacity

• Installation
• Oracle Universal Installer (OUI)
• Conf Assistants
• Create disk groups

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
Managing ASM is Simple
ltInsert Picture Heregt
Three Flexible Management Interfaces

1. EM Database Control or Grid Control
2. SQLPlus interface
3. ASMCMD tool

12
ASM Home Page
13
ASM Performance Page
14
ASM Administration Page
15
ASM Configuration Page
16
ltInsert Picture Heregt
Three Flexible Management Interfaces

1. EM Database Control or Grid Control
2. SQLPlus interface
3. ASMCMD tool

17
ASM SQLPLUS Command Structure

• Create Disk Group
• SQLgt 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
• SQLgt drop diskgroup DataDG

1
2
18
Alter diskgroup SQLPlus 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 VASM_ views

19
ASM Views - Examples
View Description
VASM_DISKGROUP Describes a disk group (number, name, size related info, state, and redundancy type)
VASM_DISK Contains one row for every disk discovered by the ASM instance, including disks that are not part of any disk group.
VASM_DISKGROUP_STAT Has the same columns as VASM_DISKGROUP, but to reduce overhead, does not perform a discovery when it is queried.
VASM_DISK_STAT Has the same columns as VASM_DISK, but to reduce overhead, does not perform a discovery when it is queried.
VASM_FILE Contains one row for every ASM file in every disk group mounted by the ASM instance.
VASM_TEMPLATE Contains one row for every template present in every disk group mounted by the ASM
VASM_ALIAS Contains one row for every alias present in every disk group mounted by the ASM
VASM_OPERATION Contains one row for every active ASM long running operation executing in the ASM
VASM_CLIENT identifies databases using disk groups managed by the ASM instance
20
ltInsert Picture Heregt
Three Flexible Management Interfaces

1. EM Database Control or Grid Control
2. SQLPlus interface
3. 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
• ASMCMDgt ls
• Non-interactive CLI mode for scripting and batch
  processing
• ASMCMD ls lH DATAFILE/ORCL/CONTROLFILE

22
ASM Utilities Simplify Data Transfer and
Migration
ltInsert Picture Heregt
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
ltInsert Picture Heregt
Oracle Database 11g ASM Beta Features
27
ASM 11g Beta Features
RAC ASM
RAC/ASM 11gR1
- 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
Conclusion
Which management style would you prefer?
Not based on real statistics
32
ASM Featured in OOW 2006
ID Time Room Title
S281246 Wed 230 PM 303 South ASM Architecture
S281247 Wed 400 PM 303 South Dell IT User proven ASM deployments
S281258 Thurs 800 AM 303 South Fidelity National Financials Migrating and consolidating DB2 and SQL Server onto RAC/ASM 10g
33
Q

A
34
(No Transcript)