ASM

There are plenty of bugs I've come across in earlier (no longer supported) versions of ASM. I chose not to use my old notes to document them here. If you are starting with ASM now then you really should be using a supported (and less buggy) version of the software.

Check

To check ASM status using srvctl...

srvctl status asm

To check that ASM is running and to see which user owns it...

ps -ef | grep -i ASM

All further commands on this page assume you are logged in to the OS as this user

Diskgroup Summary

State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  NameMOUNTED  EXTERN  N         512             512   4096  4194304    524288   333264                0          333264              0             Y  DATA/MOUNTED  EXTERN  N         512             512   4096  4194304    262144    44916                0           44916              0             N  RECO/

asmcmd

asmcmd

lsdg

exit

sqlplus

sqlplus / as sysdba

SET LINESIZE 132

SELECT  state                   AS "State", 

        type                    AS "Type",

        NULL                    AS "Rebal", 

        sector_size             AS "Sector",

        logical_sector_size     AS "Logical_Sector",

        block_size              AS "Block",

        allocation_unit_size    AS "AU",

        total_mb                AS "Total_MB",

        free_mb                 AS "Free_MB",

        required_mirror_free_mb AS "Req_mir_free_MB",

        usable_file_mb          AS "Usable_file_MB",

        offline_disks           AS "Offline_disks",

        voting_files            AS "Voting_files",

        name                    AS "Name"

   FROM v$asm_diskgroup;

EXIT

The SQL script on the right does not currently include the Rebal information.

ASM Summary Report (HTML)

See Note: 470211.1

sqlplus / as sysdba

@asm_first.sql

@asm_second.sql

Disk Usage Report

Example Output

+------------------------------------------------------------------------+| Report   : ASM Disks                                                   || Instance : +ASM1                                                       |+------------------------------------------------------------------------+
Disk Group Name           Path                 File Name            Fail Group           File Size (MB) Used Size (MB) Pct. Used------------------------- -------------------- -------------------- -------------------- -------------- -------------- ---------DATA                      /dev/DATADISK3       DATA_0000            DATA_0000                    65,536         61,864     94.40                          /dev/DATADISK4       DATA_0003            DATA_0003                    65,536         61,780     94.27                          /dev/DATADISK2       DATA_0001            DATA_0001                    65,536         61,808     94.31                          /dev/DATADISK1       DATA_0002            DATA_0002                    65,536         61,780     94.27*************************                                                                -------------- --------------                                                                                                262,144        247,232
RECO                      /dev/RECODISK1       RECODISK1            RECODISK1                    65,536         53,616     81.81                          /dev/RECODISK4       RECODISK4            RECODISK4                    65,536         53,564     81.73                          /dev/RECODISK3       RECODISK3            RECODISK3                    65,536         53,440     81.54                          /dev/RECODISK2       RECODISK2            RECODISK2                    65,536         53,472     81.59*************************                                                                -------------- --------------                                                                                                262,144        214,092
                                                                                         -------------- --------------Grand Total:                                                                                    524,288        461,324

sqlplus / as sysasm

@/u01/dba/asm/asm_disks1.sql

As above, but with the STATE column added to the output
+------------------------------------------------------------------------+| Report   : ASM Disks                                                   || Instance : +ASM1                                                       |+------------------------------------------------------------------------+
Disk Group Name           Path                 File Name            STATE    Fail Group           File Size (MB) Used Size (MB) Pct. Used------------------------- -------------------- -------------------- -------- -------------------- -------------- -------------- ---------DATA                      /dev/DATADISK6       DATA_0005            NORMAL   DATA_0005                   131,072         51,588     39.36                          /dev/DATADISK5       DATA_0004            NORMAL   DATA_0004                   131,072         51,620     39.38                          /dev/DATADISK8       DATA_0007            NORMAL   DATA_0007                   131,072         51,576     39.35                          /dev/DATADISK4       DATA_0003            DROPPING DATA_0003                    65,536         14,264     21.77                          /dev/DATADISK2       DATA_0001            DROPPING DATA_0001                    65,536         14,264     21.77                          /dev/DATADISK7       DATA_0006            NORMAL   DATA_0006                   131,072         51,596     39.36                          /dev/DATADISK3       DATA_0000            DROPPING DATA_0000                    65,536         14,296     21.81                          /dev/DATADISK1       DATA_0002            DROPPING DATA_0002                    65,536         14,272     21.78*************************                                                                         -------------- --------------                                                                                                         786,432        263,476
RECO                      /dev/RECODISK1       RECODISK1            NORMAL   RECODISK1                    65,536         53,648     81.86                          /dev/RECODISK2       RECODISK2            NORMAL   RECODISK2                    65,536         53,660     81.88                          /dev/RECODISK3       RECODISK3            NORMAL   RECODISK3                    65,536         53,628     81.83                          /dev/RECODISK4       RECODISK4            NORMAL   RECODISK4                    65,536         53,672     81.90*************************                                                                         -------------- --------------                                                                                                         262,144        214,608
                                                                                                  -------------- --------------Grand Total:                                                                                           1,048,576        478,084

Disk Performance Report

Sample Output

+------------------------------------------------------------------------+| Report   : ASM Disk Performance                                        || Instance : +ASM1                                                       |+------------------------------------------------------------------------+
                                                                                   Read        Write             Read            Write                Bytes                BytesDisk Group Name      Disk Path                       Reads           Writes      Errors       Errors             Time             Time                 Read              Written-------------------- -------------------- ---------------- ---------------- ----------- ------------ ---------------- ---------------- -------------------- --------------------DATA                 /dev/DATADISK3             33,709,905       16,896,461           0            0           59,185        1,200,442    2,359,301,932,544      430,127,716,352                     /dev/DATADISK4            240,370,335       16,700,470           0            0          182,227          853,981    5,206,277,542,400      430,156,206,080                     /dev/DATADISK2             36,368,437       19,004,162           0            0           60,565          969,628    2,416,323,789,312      455,628,063,744                     /dev/DATADISK1            586,927,755       19,404,473           0            0          390,070        1,758,182   11,879,652,850,176      459,077,994,496********************                      ---------------- ---------------- ----------- ------------ ---------------- ---------------- -------------------- --------------------                                               897,376,432       72,005,566           0            0          692,047        4,782,233   21,861,556,114,432    1,774,989,980,672

RECO                 /dev/RECODISK1             23,759,995       40,243,950           0            0           45,413           98,794      960,918,323,200      626,679,333,376                     /dev/RECODISK4             15,172,482       39,790,749           0            0           36,704           85,572      815,737,315,328      611,133,980,160                     /dev/RECODISK3             41,840,544       42,804,028           0            0           53,521           71,348    1,257,232,960,000      660,393,681,408                     /dev/RECODISK2            134,442,316       48,838,567           0            0          103,199           93,326    1,474,106,978,816      762,312,910,848********************                      ---------------- ---------------- ----------- ------------ ---------------- ---------------- -------------------- --------------------                                               215,215,337      171,677,294           0            0          238,837          349,040    4,507,995,577,344    2,660,519,905,792

                                          ---------------- ---------------- ----------- ------------ ---------------- ---------------- -------------------- --------------------Grand Total:                                 1,112,591,769      243,682,860           0            0          930,885        5,131,273   26,369,551,691,776    4,435,509,886,464

Other Reports

Startup

srvctl start asm

Stop

srvctl stop asm

Create Diskgroup

ALTER SYSTEM SET ASM_DISKSTRING = '/dev/rhdisk2*' , '/dev/asm*' SCOPE=BOTH;

CREATE DISKGROUP oradata2 EXTERNAL REDUNDANCY DISK '/dev/asm69','/dev/asm70','/dev/asm103','/dev/asm104','/dev/asm105';

ALTER Diskgroup

ALTER DISKGROUP oradata REBALANCE POWER 10;

ADD DISK

ALTER DISKGROUP oradata ADD DISK '/dev/rhdisk28';

To add a disk to a specific failgroup...

ALTER DISKGROUP oradata ADD FAILGROUP controller2 DISK '/dev/rhdisk28';

If you don't specify a failgroup then per disk failgroups are used

You should run a rebalance after adding a disk...

ALTER DISKGROUP oradata REBALANCE;

You can track rebalance progress using...

SELECT * FROM v$asm_operation;

See the section on v$asm_operatioon later on this page for more information

DROP Disks

ALTER DISKGROUP oradata DROP DISK oradata1_0004;

ALTER DISKGROUP oradata DROP DISKS IN FAILGROUP controller1;

DROP Diskgroup

For RAC, shutdown ASM instances on other nodes, leaving just one instance, then:

 DROP DISKGROUP oradata INCLUDING CONTENTS;

Parameters

Set in the ASM Instance

ASM_DISKGROUPS

ASM_DISKSTRING

ASM_PREFREERD_READ_FAILURE_GROUPS

ASM_POWER_LIMIT

Sets the default rebalance power. Permitted value from 0 to 11, where 0 stops the rebalance operation and 11 permits Automatic Storage Management to execute the rebalance as fast as possible

Views

V$ASM_ALIAS

ASM Instance Only

Displays a row for each alias in every disk group mounted by ASM

V$ASM_CLIENT

Displays a row for each database instance using a disk group managed by ASM.

V$ASM_DISK

Reduced functionality if acces via database instance

Displays a row for each disk discovered by the ASM instance

V$ASM_DISK_STAT

Same as V$ASM_DISK without performing discovery of new disks

V$ASM_DISKGROUP

Displays a row for each disk group discovered by the ASM instance.

V$ASM_DISKGROUP_STAT

Same as V$ASM_DISKGROUP without performing discovery of new diskgroups

V$ASM_FILE

ASM Instance Only

Displays a row for each file for each disk group mounted by ASM

V$ASM_OPERATION

ASM Instance Only

Displays a row for each file for each long running operation executing in ASM

SELECT *

  FROM v$asm_operation;

OPERATION can be:
  • REBAL - Rebalance pending for this group. The diskgroup needs rebalance to complete.
  • COD - COD recovery pending for group. There are COD's that need to be recovered, These could be CODs which are part of the rebalance or CODs which are rolling back operations, such as file creations
  • DSCV - Disk rediscovery pending. RBAL is doing disk discovery, probing the system for devices that ASM can use.
  • ACD - ACD grow chunk pending for group. New ASM instance has joined the cluster and this instance is growing the ACD to accommodate it.
  • RFRSH - PST refresh/disk expel required. Requesting PST refresh and asking the disk to be expelled after it is refreshed.
  • EXPEL - End of rebalance expel required. Background operation complete, winding down.
STATE can be:
  • WAIT - No operations running for the group
  • RUN - Operation running for the group
  • REAP - Operation is being run down
  • HALT - Operation halted by admin
  • ERRORS - Operation halted by errors

GV$ASM_OPERATION

ASM Instance Only

Cluster wide implementation of V$ASM_OPERATION

V$ASM_TEMPLATE

Displays a row for each template present in each disk group mounted by ASM