ara shakian principal product manager oracle server technologies thinking out of the box re-defining...
TRANSCRIPT
![Page 1: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/1.jpg)
![Page 2: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/2.jpg)
Ara ShakianPrincipal Product ManagerOracle Server Technologies
Thinking Out of the BoxRe-defining Database Storage Management
![Page 3: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/3.jpg)
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
![Page 4: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/4.jpg)
Automatic Storage Management A storage manager designed to manage
Oracle Database files
• Cluster support with Oracle Clusterware
• 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)
ASM DiskASM Disk
ASM DiskASM Disk
ASM Disk
ASMDisk Group
+DATA datafiles file1… filen controlfile redolog1
![Page 5: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/5.jpg)
ASM High Level Architecture
Database Instance ASM
DB Processes
ASM
- File layout info- Update statistics- Health info
ASM file extents
ServiceRequests
• An Integrated Solution
• ASM manages meta-data• NOT in IO path• Optimal Performance
LUNDB I/O
SGA
![Page 6: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/6.jpg)
Predictable Performance &
Availability
Increases Storage Utilization
Uptime & Agility
Simplifies and Automates
Reduce Cost and Complexity Without Compromising
Performance or Availability
No addition cost!
ASM Key Values
![Page 7: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/7.jpg)
Storage ManagementRoles & Responsibilities
<Insert Picture Here>
![Page 8: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/8.jpg)
ASM 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
SYS Admin Role
Storage and ASM Administration
![Page 9: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/9.jpg)
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
![Page 10: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/10.jpg)
Traditional LVM/FS vs ASM Add Capacity
LVM/FS
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
ASM
1. Add Disk to OS
2. Add disk to a disk group!
![Page 11: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/11.jpg)
Managing ASM is Simple
1. EM Database Control or Grid Control
2. SQL*Plus interface
3. ASMCMD tool
<Insert Picture Here>Three Flexible Management Interfaces
![Page 12: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/12.jpg)
ASM Home Page
![Page 13: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/13.jpg)
ASM Performance Page
![Page 14: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/14.jpg)
ASM Administration Page
![Page 15: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/15.jpg)
ASM Configuration Page
![Page 16: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/16.jpg)
Three Flexible Management Interfaces
1. EM Database Control or Grid Control
2. SQL*Plus interface
3. ASMCMD tool
<Insert Picture Here>
![Page 17: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/17.jpg)
ASM SQL*PLUS Command Structure
• 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;
1
2
![Page 18: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/18.jpg)
Alter diskgroup SQL*Plus Command Structure
• 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
3 Alter Disk Group
![Page 19: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/19.jpg)
ASM Views - ExamplesView 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
![Page 20: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/20.jpg)
Empower the Sys Admin and DBA
Three Flexible Management Interfaces
1. EM Database Control or Grid Control
2. SQL*Plus interface
3. ASMCMD tool
<Insert Picture Here>
![Page 21: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/21.jpg)
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
![Page 22: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/22.jpg)
ASM Utilities
Simplify Data Transfer and Migration
<Insert Picture Here>
![Page 23: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/23.jpg)
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
![Page 24: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/24.jpg)
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
![Page 25: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/25.jpg)
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
![Page 26: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/26.jpg)
Oracle Database 11g ASM Beta Features
<Insert Picture Here>
![Page 27: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/27.jpg)
ASM 11g Beta Features
RACASM
LUN LUN
RAC/ASM 11gR1
LUN LUN
NetworkPreferred
Mirror Read
ManageabilityEnhancements
- Disk Group Attributes - ASMCMD lsdisk- Metadata backup/restore- Off-line faster rebalance- Disk Group Attributes
Fast VLDBStart
- Variable File Extents- Larger AUs
XXTransientFailures
Fast Disk Resync
- Incremental Repair
SYSASM Role
- CONNECT / AS SYSASMRolling
Migration
ASM11gR2
![Page 28: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/28.jpg)
Hundreds of ASM Customers In Production
![Page 29: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/29.jpg)
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.
![Page 30: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/30.jpg)
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 PrinceChief Technology Officer
![Page 31: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/31.jpg)
Conclusion
FS
Mgt
Overhead
Time
RAW
Which management style would you prefer?
ASM
* Not based on real statistics
![Page 32: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/32.jpg)
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
![Page 33: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/33.jpg)
AQ&
![Page 34: Ara Shakian Principal Product Manager Oracle Server Technologies Thinking Out of the Box Re-defining Database Storage Management](https://reader036.vdocuments.us/reader036/viewer/2022062716/56649dd05503460f94ac5d13/html5/thumbnails/34.jpg)