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

Check progress on expdp and impdp

 Check progress on expdp and impdp: In few cases we need to monitor the progress of an export or import job in oracle. below are the steps c...