December 16, 2024

Basic ASM Commands

Most commonly used ASM Commands


chdg :  Changes a disk group (add, drop, rebalance, or migrate on the Exadata appliance).

chkdg : Checks or repairs a disk group.

iostat : Displays I/O statistics for disks.

lsattr :  Lists the attributes of a disk group.

lsdg : Lists disk groups and their information.

lsdsk : Lists disks Oracle ASM disks.

lsod : Lists open devices.

mkdg : Creates a disk group.

mount : Mounts a disk group.

umount : Dismounts a disk group.

offline : Offlines a disk or a failure group.

online : Onlines a disk or a failure group.

rebal : Rebalances a disk group.

dropdg : Drops a disk group.



Query to check ASM Disk groups usage and free space:


set pages 300

set lines 400

select name,allocation_unit_size,Total_mb,free_mb, (free_mb/total_mb)*100 "free %", usable_file_mb, (usable_file_mb/total_mb)*100 "usable free %"  from  V$ASM_DISKGROUP_STAT;



Reference:

https://docs.oracle.com/en/database/oracle/oracle-database/21/ostmg/asmcmd-diskgroup-commands.html#GUID-3BA40908-0543-4968-B834-BD4D873E1059


No comments:

Post a Comment

If you have any queries/ any suggestion please do comment and let me know.

Recent Post

Increase Java Heap memory for OEM

 There are certain times when we observer OEM is performing slow or even unable to startup the Admin Server or OMS Server. We can look into ...