Transcript Corporate PPT Template

Extending Automatic Storage Management to
Manage ALL Data
Oracle Database 11g Release 2
Ara Shakian
Principal Product Manager
Oracle Confidential
The following is intended to outline our general
product direction. It is intended for information
purposes only, and may not be incorporated into any
contract. It is not a commitment to deliver any
material, code, or functionality, and should not be
relied upon in making purchasing decisions.
The development, release, and timing of any
features or functionality described for Oracle’s
products remains at the sole discretion of Oracle.
Oracle Confidential
Table of Contents
• Storage management challenges
• ASM Overview
• ASM in 11gR2 takes it the next level
•
•
•
•
What is it
How does it work
How do I manage it
Benefits
• How do I get from here to ASM
• ASM reference customers
Oracle Confidential
Challenges of Managing
Data Explosion
• Lack of a single optimal solution for all data
• Lack of automation to reduce complexity
• Managing multiple software layers
• Complexity of managing performance
• Eliminating hot spots
• Multi-vendor support logistics and finger
pointing
• Reducing storage Total Cost of Ownership
Oracle Confidential
ASM Is Most Popular
Storage Manager
• De-facto standard for RAC and grid
deployments, >65%
• De-facto standard for VLDB
deployments
• Large and growing adoption for
single instance deployments, >20%
• Thousands of customers using ASM
• One of the most popular features in
the database
Oracle Confidential
ASM is Storage Management Platform of Choice
An optimal storage management solution for
database and general purpose files
ASM Disk Group
ASM Disk
ASM Disk
ASM Disk
ASM Disk
ASM Disk
•
•
•
•
•
•
Simplifies and automates storage management
Integrated cluster and single node framework
Storage pooling with easy provisioning
Optimal performance by default
Best availability and scalability
Lowest TCO
• Consolidates and eliminates waste
• No additional cost
• Manages ALL data
Lowers the cost of storage management
Oracle Confidential
11.2
Dynamic Rebalancing
• Simple provisioning
• Add, drop or resize
ASM Disk
Disk
ASM
ASM Disk
Disk
ASM
Benefits:
• On-line capacity management
• Eliminates manual I/O tuning
• Maintain optimal performance
• Storage migration on line
Oracle Confidential
Disk Group
ASM Disk
Enables Storage Consolidation
Clustered Pool of Storage
Local Area Network
RAC
ASM
ERP FIN
• Shared storage across
several databases
RDBMS
ASM
CRM
RDBMS
ASM
• RAC and Single Instance
HR
• Benefits:
ERP Database
HR Database
CRM Database
FIN Database
ASM Disk Group
Oracle Confidential
• Simplified and Centralized
management
• Higher storage utilization
• Higher performance
Striping, Mirroring and Performance
• Striping designed to meet
• RDBMS I/O characteristics
• General purpose files
• Flexible file-based mirroring
• External, Normal and High
• Optimal performance
ASM
• No tuning
Non-ASM
Percentage
relative to
Baseline
(TPS)
Time
Oracle Confidential
Why You Should Care
•
Reduced complexity thru automation
•
•
Simplified solution stack
•
•
Oracle Confidential
No down-time for storage provisioning or migration
Managing storage pool vs. islands
Single vendor cross-platform integrated solution
•
•
•
No finger pointing, 3rd party LVM/FS
Increases utilization and database and
application uptime
•
•
•
No I/O tuning, reshuffling data files
Bundled and tested as one solution
Same cross platform tools to install, configure and manage
No additional cost!
Taking It To The Next Level
With
ASM in 11gR2
Oracle Confidential
Oracle Grid Infrastructure
(ASM + Oracle Clusterware)
• ASM and Oracle Clusterware integrated and installed in
a single ‘Grid Infrastructure’ home
• Integrated installation, configuration and upgrade
• Installed using Oracle Universal Installer (OUI)
• Not a part of database install
• Option to minimally configure ASM and ACFS
• Automate creation of Oracle DB Homes on ACFS
Oracle Confidential
ASM Configuration Assistant (ASMCA)
tool to initialize & manage • Manage ASM before db install
* Disk Groups
• Upgrade previous versions of ASM
* Dynamic Volumes
to the current version (11g R2)
* ACFS file systems
• One
Oracle Confidential
Extending ASM to Manage ALL Data
Database RAC
Application
3rd Party FS
Automatic Storage Management (ASM)
ACFS Snapshot
ASM Instance
Managing
Oracle DB Files
Database Files
ASM
Disk
Group
Oracle Confidential
ASM Cluster & Single
Node File System
(ACFS)
Dynamic Volume Manager
General Purpose Files
Dynamic Volumes
DB
Datafiles
DB
Datafiles
Database
files
OCR & Voting files
ACFS FS
Oracle Bin
3rd Party
FS
What is ASM Dynamic Volume Manager
OS
/dev/asm/vol1-123
ASM DG
+DATA/vol1
• A new cluster (and single host) volume
management service
• Standard disk device interface to clients
• Loadable kernel driver
• Dynamic Volume is a volume file created
in an ASM disk group (new file type
‘asmvol’)
• An OS device file is created automatically when
a dynamic volume is created
• Managed by SQL/ASMCMD and EM
Oracle Confidential
What is ASM Cluster File System
(ACFS)
• General purpose scalable file system
• Journaling, extent based
• Single node and cluster
• POSIX, X/OPEN file system solution for UNIX/Linux
• Windows file system solution for Windows platforms
•
•
•
•
•
Accessible through NAS protocols (NFS, CIFS)
Leverages ASM technology for volume mgt
Integrated with Oracle Clusterware for cluster support
Multi OS platform (Linux and Windows at initial release)
Integrated with Oracle system mgt tools
• Oracle installation and configuration
• Enterprise Manager and ASM Storage mgt tools
• Native OS File System Management tools
Oracle Confidential
What are ACFS Snapshots
• Dynamic, fast, space efficient, “point in time” read-only
copies of ACFS file system files
• Captures ASM FS file block/extent updates
• An enabler for:
• On-line, disk-based, file backup model using snapshots
• Individual file recoveries
• Up to 64 snapshot images per ASM file system
• Policy based snapshots:
Schedule snapshots on an interval basis: every 5 seconds,
every 30 minutes, daily, …
• Create an ACFS snapshots
• acfsutil snap create snap_name mountp
Oracle Confidential
Leveraging the Power of ASM
• Even distribution of data
• Dynamic provisioning
Dynamic volumes and
ACFS FS may be resized
leveraging ASM file resize
features
% asmcmd volresize dga vol1 -s 50G
ACFS File System: /usr1
ACFS file A
ACFS file B
Mirrored
Mirrored
Linux: /dev/asm/vol1
Win: \\.\asm_dgname_volname
+DATA/dga/vol1
• Can also use Enterprise
Manager for management
and threshold alerts
1
1
Primary ASM File Extent
Mirrored ASM file Extents
Oracle Confidential
3
Managing the Dymanic Volumes and
ACFS File System
Is Simple And Flexible
1. Native Linux, UNIX, and Windows OS file system
commands and extensions
2. acfsutil platform independent commands
3. ASM Configuration Assistant (ASMCA)
4. Enterprise Manager
Oracle Confidential
An Example: Creating an ACFS File
System
$ mkfs -t acfs -b 4k /dev/asm/volume1-62
; Create fs on ASM volume
$ su - root
# mount -t acfs /dev/asm/volume1-62 /tmp/images
# su – oracle_usr
$ acfsutil registry -a /dev/asm/volume1-62 /tmp/images
$ mount –t acfs –o all none none
$ cd /tmp/images
$ cp /home/my_images .
Oracle Confidential
; Mount everything in the registry
ACFS Use Cases
• Oracle Home
• Shared or node-local
• Not Grid Infrastructure home
• External files
• Application binaries
• Not an OS boot FS
Oracle Confidential
Managing
Oracle Database Files
ASM Core Enhancements
Oracle Confidential
ASM 11g Release 2 New Features
for
Database Files
• All files on ASM
• Oracle Cluster Registry,
Voting Disk and SPFILE
• Tunable Performance
• Intelligent Data Placement
(IDP)
• Improved Management
• Full Featured ASMCMD
• ASM File Access Control
• ASM Disk Group Rename
• Datafile to Disk Mapping
• Installation &
Configuration mgt
• ASM Install & Configuration
Assistant (ASMCA)
Oracle Confidential
OCR and Voting Disk on ASM
• OCR is a regular ASM file
• A new ASM file type
• Voting Disk
• Stored in selected ASM disks
• ‘crsctl’ used to specify a disk group for Voting disks
• ASM auto creates1/3/5 Voting Disks based on
Ext/Normal/High redundancy on Failure Groups
• Quorum failure group
• ASM determines redundancy for OCR and Voting Disk
based on disk group redundancy level
• ASM SPFILE is also supported on ASM now
Oracle Confidential
Intelligent Data Placement (IDP)
• Placement of files on high performance
regions of disk
Hot Files
• 50% performance difference from outer to
inner tracks
• Classify or mark an ASM file to be
HOT/COLD
• Alter diskgroup dgname modify file ‘xxx’
attributes HOT/COLD or
based on a templates at creation time
• Rebalance to migrate the ‘file’ to HOT/COLD
IDP region
• IDP regions are dynamic
• New V$ASMFILE recording IO stats
• The IDP feature better leveraged when ASM
disks are whole disks
Oracle Confidential
Disk Platter
Cold Files
Complete ASMCMD Functionality
A complete API for the system admin
• Extending ASMCMD to manage:
• ASM instance (startup/shutdown, init.ora, .)
• Disk group, disk and failure group (create, mount,
add, drop, …)
• Attribute (list, set)
• User/Group (add user, change password, …)
• Template (list, add, alter drop)
• Iostat and df
• lsof: list files that are open by ASM
lsod: list disks that are open by ASM
• Dynamic Volume
Oracle Confidential
Other Features
• ASM File Access Control (ACL)
• Introducing 3 classes of permissions:
• owner, group, and other
• ASM Disk Group Rename
• Oracle File Mapping support (OFM)
• View mapping of datafiles to physical devices
• 4k sector size disk I/O support
• Possible values are: 512b or 4096b (4k)
Oracle Confidential
In Summary…
Oracle Confidential
One Integrated Solution for ALL Data
Simple Low Cost High Performance Always On-Line
Scalable
Optimal Utilization
ACFS Snapshot
Un-structured
Data
Structured
Data
ASM Cluster FS
ASM Database files
&
Dynamic Volumes
Oracle Database
Oracle Clusterware
&
RAC
Cross Platform
Linux, Windows, Solaris,
HP-UX, AIX
Oracle Confidential
One Management
Interface
One Install and
Configure
One Clusterware
Framework
One Vendor for
Support
Some ASM Reference Customers In Production
Oracle Confidential
Oracle Confidential