Transcript Corporate PPT Template

Thinking Out of the Box
Re-defining Database Storage Management
Ara Shakian
Principal Product Manager
Oracle Server Technologies
Agenda
• 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
<Insert Picture Here>
Automatic Storage Management
ASM
Disk Group
ASM Disk
ASM Disk
ASM Disk
ASM Disk
ASM Disk
+DATA
datafiles
file1… filen
controlfile
redolog1
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)
• Cluster support with Oracle Clusterware
ASM High Level Architecture
Database Instance
SGA
ASM
- File layout info
- Update statistics
- Health info
ASM file
extents
• An Integrated Solution
ASM
Service
Requests
DB
Processes
DB I/O
LUN
• ASM manages meta-data
• NOT in IO path
• Optimal Performance
ASM Key Values
Reduce Cost and Complexity Without Compromising
Performance or Availability
Simplifies and
Automates
Increases
Storage Utilization
Uptime & Agility
Predictable
Performance &
Availability
No addition cost!
<Insert Picture Here>
Storage Management
Roles & Responsibilities
Storage and ASM Administration
SYS Admin Role
Pre-Installation
• Create LUNs
• Set ownership &
permissions to
‘Oracle User’
ASM Admin Role
Installation
• Oracle Universal
Installer (OUI)
• Conf Assistants
• Create disk
groups
Normal Operation
• Monitor capacity &
availability
• Provision capacity
ASM Reduces Management
Complexity
Eliminate
Reduce significantly
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
• LUN mgt (larger LUNs)
• Less frequent DBA & sys
admin interaction
• Manual error prone tasks
• Troubleshooting
• Expanding Capacity
•
•
•
•
•
Traditional LVM/FS vs ASM
Add Capacity
1.
2.
3.
4.
5.
6.
7.
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
ASM
1. Add Disk to OS
2. Add disk to a disk
group!
Three Flexible
Management Interfaces
1. EM Database Control or
Grid Control
2. SQL*Plus interface
3. ASMCMD tool
Managing ASM is Simple
<Insert Picture Here>
ASM Home Page
ASM Performance Page
ASM Administration Page
ASM Configuration Page
Three Flexible
Management Interfaces
<Insert Picture Here>
1. EM Database Control or Grid Control
2. SQL*Plus interface
3. ASMCMD tool
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’;
2• Delete a Disk Group
• SQL> drop diskgroup DataDG;
Alter diskgroup SQL*Plus
Command Structure
3
•
•
•
•
•
Alter Disk Group
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
ASM Views - Examples
View
Description
V$ASM_DISKGROUP
Describes a disk group (number, name, size related info, state,
and redundancy type)
V$ASM_DISK
Contains one row for every disk discovered by the ASM
instance, including disks that are not part of any disk group.
V$ASM_DISKGROUP_STAT
Has the same columns as V$ASM_DISKGROUP, but to
reduce overhead, does not perform a discovery when it is
queried.
V$ASM_DISK_STAT
Has the same columns as V$ASM_DISK, but to reduce
overhead, does not perform a discovery when it is queried.
V$ASM_FILE
Contains one row for every ASM file in every disk group
mounted by the ASM instance.
V$ASM_TEMPLATE
Contains one row for every template present in every disk
group mounted by the ASM
V$ASM_ALIAS
Contains one row for every alias present in every disk group
mounted by the ASM
V$ASM_OPERATION
Contains one row for every active ASM long running operation
executing in the ASM
V$ASM_CLIENT
identifies databases using disk groups managed by the ASM
instance
Three Flexible
Management Interfaces
<Insert Picture Here>
1. EM Database Control or Grid Control
2. SQL*Plus interface
3. ASMCMD tool
Empower the Sys Admin and DBA
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
<Insert Picture Here>
ASM Utilities
Simplify Data Transfer
and Migration
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
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
Enhanced Migration Options
DBMS_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
<Insert Picture Here>
Oracle Database 11g ASM
Beta Features
ASM 11g Beta Features
Manageability
Enhancements
Rolling
Migration
- Disk Group Attributes
- ASMCMD lsdisk
- Metadata backup/restore
- Off-line faster rebalance
RAC
ASM
X
- Disk Group Attributes
Network
LUN
LUN
Fast VLDB
Start
- Variable File Extents
- Larger AUs
Transient
Failures
SYSASM
Role
- CONNECT / AS SYSASM
RAC/ASM
11gR1
X
LUN
Preferred
Mirror Read
LUN
Fast Disk
Resync
- Incremental Repair
Hundreds of ASM Customers In Production
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 Systems
Talk America Holdings, Inc.
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
Conclusion
M
g
t
O
v
e
r
h
e
a
d
RAW
Which management style
would you prefer?
FS
ASM
Time
* Not based on real statistics
ASM Featured in OOW 2006
ID
Time
Room
Title
S281246
Wed 2:30
PM
303 – South
ASM Architecture
S281247
Wed 4:00
PM
303 – South
Dell IT: User proven ASM deployments
S281258
Thurs
8:00 AM
303 – South
Fidelity National Financials: Migrating and
consolidating DB2 and SQL Server onto RAC/ASM
10g