Oracle Database - ASM (Automatic Storage Management)

Card Puncher Data Processing

About

Starting with Oracle Database 10g (10.1.0.3 or later), Automatic Storage Management is a high-performance storage management solution. For Oracle Database files, it simplifies the management of a dynamic database environment, such as creating and laying out databases and managing disk space.

Automatic Storage Management can support multiple databases then it manages the storage of all database files, such as:

Automatic Storage Management can manage the Oracle Database executable binary files as well as any other non-database file by creating a file system with Oracle Automatic Storage Management Cluster File System. Though Oracle Automatic Storage Management Cluster File System is cluster aware it works as a file system on a single instance database also.

At a high level, implementing Automatic Storage Management involves allocating partitioned disks for Oracle Database with preferences for striping and mirroring.

Striping and Mirroring

ASM will stripe across all devices you present to it in the context of a disk group. Most importantly, if and when you expand your configuration, ASM will automatically re-balance (re-stripe) the data across all devices, so that you will always benefit from all storage devices in your configuration, without running into hot spots in the storage configuration. ASM implements Oracle's S.A.M.E. methodology (Stripe And Mirror Everything using a stripe size of 1 MB) and automatically maintains it as devices are added or removed. ASM can also be used to mirror data or it can be used with hardware RAID configurations.

Benefits

Automatic Storage Management manages the disk space for you. This helps avoid the need for traditional disk management tools, such as:

and the numerous commands necessary to manage both.

The synchronization between Automatic Storage Management and the database instance is handled by CSS.

Installation

Automatic Storage Management can be used with single database installations, multiple database installations, and in Oracle RAC environments. It can be used with databases created in Oracle Database 10g Release 1 (10.1.0.3 or later).

However, Oracle Database 11g Release 2 (11.2) databases must use Automatic Storage Management from Oracle Database 11g Release 2 (11.2) or later. Automatic Storage Management is installed as part of the grid infrastructure installation. If you plan to use Automatic Storage Management, then you must install the grid infrastructure before installing your database.

Oracle recommends that you have the Automatic Storage Management instance in its own Oracle home. Oracle also recommends that you run this instance before you start a database instance that uses Automatic Storage Management.

For an Oracle Database installation, you only need one Automatic Storage Management instance, regardless of the number of database instances on the computer.

Component

The following are components of an Automatic Storage Management installation:

The Automatic Storage Management instance is a special Oracle instance that manages Automatic Storage Management disk groups. The Automatic Storage Management instance and the ASMSNMP account are created and started, if necessary, when you install Oracle grid infrastructure. Oracle Enterprise Manager uses this account to monitor ASM instances to retrieve data from ASM-related data dictionary views. The ASMSNMP account status is set to OPEN upon creation, and it is granted the SYSDBA privilege.

Documentation / Reference





Discover More
Card Puncher Data Processing
Data Storage - Data Striping (I/O parallelism)

In computer data storage, data striping is the technique of segmenting logically sequential data, such as a file, in a way that accesses of sequential segments are made to different physical storage devices....
Data Path From Disk To Cpu
IO - Data Path / Balanced System

The data paths is the path composed of all hardware components that are needed to get the data from: a storage device (generally disk drive or network drive) to the CPU It is important to understand...
Card Puncher Data Processing
Oracle Database - (initialization|server) parameter file (init.ora | spfile.ora)

How to manage the initialization parameters when the database start. By default, the preconfigured database uses a parameter file (spfile) named spfilesid.ora, which is stored in the $ORACLE_HOME/dbs...
Card Puncher Data Processing
Oracle Database - ASM - Disk group

A disk group is a set of disk devices that Automatic Storage Management manages as a single unit. Each disk device can be: an individual physical disk, a multiple disk device, such as a RAID storage...
Card Puncher Data Processing
Oracle Database - Automating Shutdown and Startup on Linux

Automating database startup and shutdown guards against incorrect database shutdown. Since the version 11.2, it's recommended to use Oracle Restart but a single database installation doesn't install it....
Card Puncher Data Processing
Oracle Database - File System

The file system is a storage option for the database files during the installation of a database. Oracle Database Configuration Assistant creates the database files in a directory on a file system mounted...
Card Puncher Data Processing
Oracle Database - Grid Control

To simplify database administration, Oracle provides a Web-based management tool called Oracle Enterprise Manager. When you deploy Oracle Enterprise Manager 10g centrally in the environment, you use...
Card Puncher Data Processing
Oracle Database - Input/Output (I/O)

physical io (on the drive) is aimed to seed the buffer cache where the logical io (database logical) occurs. There are several ways to handle excessive I/O waits. In the order of effectiveness, these...
Oracle Database 11gr2 Typical Installation
Oracle Database - Installation 11g Release 2 (11.2) on Linux OEL 5 (X86)

Installation of Oracle Database 11g Release 2 (11.2) on Oracle Enterprise Linux 5. Linux OEL installation login as root RAM: At least 1 GB swap space The following table describes...
Oracle Database 11gr2 Os Group
Oracle Database - Operating System Group

Operating System User and Group permit to allocate privileges. The documentation talks logical OS group (OSDBA, OSOPER, OSASM). Their implementation (their creation on the OS level) may be differ in...



Share this page:
Follow us:
Task Runner