ASM Information

Submitted by dave on Tue, 09/03/2013 - 15:07

ASM Dictionary Views

v$asm_aliasLists all aliases in all currently mounted diskgroups
v$asm_clientLists all the databases currently accessing the diskgroups
v$asm_diskLists all the disks discovered by the ASM instance
v$asm_diskgroupLists all the diskgroups discovered by the ASM instance
v$asm_fileLists all files that belong to diskgroups mounted by the ASM instance
v$asm_operationReports information about current active operations. Rebalance activity is reported in this view
v$asm_templateLists all the templates currently mounted by the ASM instance
v$asm_diskgroup_statSame as v$asm_diskgroup but does discover new diskgroups. Use this view instead of v$asm_diskgroup
v$asm_disk_statSame as v$asm_disk but does not discover new disks. Use this view instead of v$asm_disk

ASM Health Check

SET LINESIZE 200
COLUMN PATH FORMAT A30

SELECT instance_name, host_name from v$instance;

SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK ORDER BY NAME;

ASM Helpful Queries
Articles
How to replace disks online
When will my rebalance finish?

ASMLIB
Check disk details from OS

for diskn in `/etc/init.d/oracleasm listdisks`; do /etc/init.d/oracleasm querydisk -v -d $diskn; done

Add Disk Label to Raw Device

sudo /etc/init.d/oracleasm createdisk  /dev/diskdeviceref

ASM File Details

SELECT name, file_number, creation_date, modification_date, bytes From v$asm_file
JOIN v$asm_diskgroup on v$asm_file.group_number=v$asm_diskgroup.group_number
WHERE v$ASM_DISKGROUP.NAME = UPPER(TRIM(:DGNAME))
ORDER BY 4 DESC;

ASMCMD Annoyances


  • Recursive workaround for du command
  • Recursive workaorund for cp command