Automatic Storage Management

Automatic Storage Management

Automatic Storage Management is a feature provided in Oracle 10g (since rev1) that aims to simplify the database files management. To do so, ASM provides file system and volume management capabilities directly inside the Oracle database kernel, allowing volumes and disks management with familiar SQL statements in Oracle. Therefore, the DBA doesn't need extra skills on specific file systems or volume managers usually provided by the operating system.

With ASM:
* IOs can take advantage of data striping
* Automatic online redistribution when you add or remove some storage
* Maintains redundant copies and provides 3rd party RAID functionalities
* Support 3rd party multipathing IO technologies (failover or load balancing to SAN access, etc.)
* Eliminates the needs for hot spares

Features:
* [http://www.oracle.com/technology/oramag/oracle/06-mar/o26asm.html ASMCMD] useful for users not familiar with SQL (you can write scripts with it)

Architecture Overview:ASM creates extents out of data, log, system, control files and other database structures. These extents are spread across all disks in the diskgroup. A diskgroup in ASM can be thought of as a volume manager and an asm disk can be thought of as logical volume. In addition to the existing background processess, ASM introduces two new background processes - ORMB and RBAL. RBAL is responsible for the opening and creation of disks in a diskgroup. ORMB provides the functionality of moving data between disks in a diskgroup.

Functionality:ASM requires an Oracle database instance to manage diskgroups. SQL*Plus can be used to connect to ASM and do the usual operations like startup and shutdown. However, ORACLE_SID needs to be set to '+ASM' and not the ORACLE_SID of the database. Views like V$ASM_DISK, V$ASM_DISKGROUP, V$ASM_FILE, V$ASM_ALIAS can be used to query for information regarding a diskgroup, disks in the diskgroup, their layout, extents etc.

External links

*http://twiki.cern.ch/twiki/pub/PSSGroup/Presentations2007/Inside_Oracle_ASM_LC_CERN_UKOUG07.ppt
*http://www.oracle.com/technology/oramag/oracle/06-mar/o26asm.html


Wikimedia Foundation. 2010.

Игры ⚽ Нужна курсовая?

Look at other dictionaries:

  • Automatic Storage Management — (ASM) est une fonctionnalité incluse dans Oracle 10g (depuis la version 10gR1), qui a pour but de simplifier la gestion des fichiers de la base de données. Pour faire cela, ASM ajoute la capacité à gérer un système de fichiers et des volumes de… …   Wikipédia en Français

  • Oracle Automatic Storage Management Cluster File System — Das Oracle Automatic Storage Management Cluster File System oder kurz ASM Cluster File System (ACFS), ist ein Cluster Dateisystem der Firma Oracle, das mit dem Oracle Datenbanksystem Version 11g Release 2 veröffentlicht wurde.[1] ASM steht für… …   Deutsch Wikipedia

  • Storage management — can refer to one of the following:* ADSTAR Distributed Storage Manager * Automatic Storage Management * Enterprise storage management * Hierarchical storage management * IBM Tivoli Storage Manager * OpenView Storage Area Manager * Storage… …   Wikipedia

  • Automatic Acoustic Management — Automatic Acoustic Management, kurz AAM, ist eine Technologie, die eine Anpassung des Geräuschniveaus einer Computerfestplatte ermöglicht. Überblick Dabei wird die Lese Schreibkopf Mechanik entweder schneller und damit lauter oder – nach… …   Deutsch Wikipedia

  • Storage virtualization — refers to the process of abstracting logical storage from physical storage. The term is today used to describe this abstraction at any layer in the storage software and hardware stack.Key conceptsAddress space remappingVirtualization of storage… …   Wikipedia

  • Automatic image annotation — (also known as automatic image tagging) is the process by which a computer system automatically assigns metadata in the form of captioning or keywords to a digital image. This application of computer vision techniques is used in image retrieval… …   Wikipedia

  • Automatic data processing equipment — Automatic data processing equipment, legally defined, is any equipment or interconnected system or subsystems of equipment that is used in the * automatic acquisition, * storage, * manipulation, * management, * movement, * control, * display, *… …   Wikipedia

  • Automatic number plate recognition — The system must be able to deal with different styles of license plates …   Wikipedia

  • Management features new to Windows Vista — This article is part of a series on Windows Vista New features Overview Technical and core system Security and safety Networking technologies I/O technologies Management and administration Removed features …   Wikipedia

  • Computer data storage — 1 GB of SDRAM mounted in a personal computer. An example of primary storage …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”