This article contains the list of useful asmcmd commands which will come handy in your day to day operations.

1. List all diskgroups:


ASMCMD> <span style="color: #ff0000;"><strong>lsdg</strong></span>


-- Include dismounted diskgroups:

ASMCMD> <span style="color: #ff0000;"><strong>lsdg --discovery</strong></span>

-- List diskgroups across all nodes of cluster:

ASMCMD> <span style="color: #ff0000;"><strong>lsdg -g --discovery


</strong></span>

2. List asm disks:

-- List all asm disks

ASMCMD> <span style="color: #ff0000;"><strong>lsdsk -k</strong> </span>

-- List disks of a diskgroup(CDATA) with free and total MB
ASMCMD> <span style="color: #ff0000;"><strong>lsdsk -k -G CDATA</strong></span>

-- List disks of a diskgroup(CDATA) with group and disk number
ASMCMD> <span style="color: #ff0000;"><strong>lsdsk -p -G CDATA</strong></span>

-- List disks with disk creation date 
ASMCMD> <span style="color: #ff0000;"><strong>lsdsk -t -G CDATA</strong></span>

-- List candidiate disks only

ASMCMD>  <span style="color: #ff0000;"><strong>lsdsk --candidate -k</strong></span>

-- List member disks only
ASMCMD> <span style="color: #ff0000;"><strong> lsdsk --candidate -p

</strong></span>

3. Get attributes of ASM diskgroups:



-- List attribute of all diskgroups:

ASMCMD> <span style="color: #ff0000;"><strong>lsattr -lm</strong> </span>

-- List attribute of specific diskgroup(DMARCH)

ASMCMD> <span style="color: #ff0000;"><strong>lsattr -lm -G  DMARCH</strong></span>
Group_Name  Name                     Value       RO  Sys
DMARCH      access_control.enabled   FALSE       N   Y
DMARCH      access_control.umask     066         N   Y
DMARCH      au_size                  1048576     Y   Y
DMARCH      cell.smart_scan_capable  FALSE       N   N


-- List attributes with specific pattern

ASMCMD> <span style="color: #ff0000;"><strong>lsattr -lm %au_size%</strong></span>
Group_Name  Name     Value    RO  Sys
CDATA       au_size  1048576  Y   Y
BDM         au_size  1048576  Y   Y
CRMG        au_size  1048576  Y   Y
PMARCH      au_size  1048576  Y   Y
BCMS        au_size  1048576  Y   Y

4. unmount diskgroup:

unmount command works only on the local node. So if you want to unmount the diskgroup from all nodes of cluster, then run this command from all the nodes.



-- unmount all diskgroups
ASMCMD> <span style="color: #ff0000;"><strong>umount -a</strong></span>

--- unmount specific diskgroup(ARCH)
ASMCMD> <span style="color: #ff0000;"><strong>umount ARCH

</strong></span>

4. Mount diskgroup:

Mount command works only on the local node. So if you want to Mount the diskgroup from all nodes of cluster, then run this command from all the nodes.



-- mount all diskgroups on local node
ASMCMD> <span style="color: #ff0000;"><strong>mount -a</strong></span>

--- mount a specific diskgroup on local node
ASMCMD> <span style="color: #ff0000;"><strong>mount ARCH

</strong></span>

5. Rebalance a diskgroup:




-- here asm_power_limit is 8 and diskgroup is ARCH

ASMCMD> <span style="color: #ff0000;"><strong>rebal --power 8 ARCH</strong></span>
Rebal on progress.

-- Monitor progress

ASMCMD> <span style="color: #ff0000;"><strong>lsop</strong></span>
Group_Name  Pass       State  Power  EST_WORK  EST_RATE  EST_TIME
ARCH        COMPACT    RUN    8      0         16831     0
ARCH        REBALANCE  DONE   8      0         0         0

6. Get password file of database



ASMCMD> <span style="color: #ff0000;"><strong>pwget --dbuniquename DBACLASS</strong></span>
+CDATA/DBACLASS/PASSWORD/pwddbaclass.256.899912377

8 .Get password file of asm :


ASMCMD> <span style="color: #ff0000;"><strong>pwget --asm</strong></span>
+MGMT/orapwASM

9. Get asm template info of a diskgroup:




ASMCMD> <span style="color: #ff0000;"><strong>lstmpl -l -G ARCH</strong></span>
Group_Name  Group_Num  Name                       Stripe  Sys  Redund  PriReg  MirrReg
ARCH        1          ARCHIVELOG                 COARSE  Y    UNPROT  COLD    COLD
ARCH        1          ASMPARAMETERFILE           COARSE  Y    UNPROT  COLD    COLD
ARCH        1          AUDIT_SPILLFILES           COARSE  Y    UNPROT  COLD    COLD
ARCH        1          AUTOBACKUP                 COARSE  Y    UNPROT  COLD    COLD
ARCH        1          AUTOLOGIN_KEY_STORE        COARSE  Y    UNPROT  COLD    COLD
ARCH        1          BACKUPSET                  COARSE  Y    UNPROT  COLD    COLD

10. Check whether flex asm is enabled or not



ASMCMD> <span style="color: #ff0000;"><strong>showclustermode</strong></span>
ASM cluster : Flex mode disabled

11.Check cluster state:


ASMCMD> <span style="color: #ff0000;"><strong>showclusterstate</strong></span>
Normal

12. View asm version:



ASMCMD> <span style="color: #ff0000;"><strong>showversion</strong></span>
ASM version         : 12.1.0.2.0

13. Get asm spfile location:


ASMCMD> <span style="color: #ff0000;"><strong>spget</strong></span>
+MGMT/DBACLASS-cluster/ASMPARAMETERFILE/registry.253.899644763

14. Take backup of asm spfile:

-- copy backup of spfile to a specific location

ASMCMD><span style="color: #ff0000;"><strong> spbackup +MGMT/DBACLASS-cluster/ASMPARAMETERFILE/registry.253.899644763 /home/oracle/asmspfile.ora

</strong></span>

15. Find clients connected to a diskgroup:

ASMCMD> <span style="color: #ff0000;"><strong>lsct DMARCH</strong></span>
DB_Name  Status     Software_Version  Compatible_version  Instance_Name  Disk_Group
DBACLASS  CONNECTED        12.1.0.2.0          12.1.0.2.0  DBACLASS1       DMARCH

16. Get asm diskstring

ASMCMD> <span style="color: #ff0000;"><strong>dsget</strong></span>
parameter:ORCL:*
profile:ORCL:*

17. List asm users with password:

ASMCMD> <span style="color: #ff0000;"><strong>lspwusr</strong></span>
Username sysdba sysoper sysasm
     SYS   TRUE    TRUE   TRUE
 ASMSNMP   TRUE   FALSE  FALSE

18. List open files of a diskgroup:

— Open files of a diskgroup ( ARCH)

ASMCMD><span style="color: #ff0000;"><strong>lsof -G ARCH
</strong></span>

19 . List open files related to a database

-- Open files of a database( DBACLASS)
ASMCMD><span style="color: #ff0000;"><strong>lsof --dbname DBACLASS
</strong></span>

20. Check filter driver is enabled or not:

ASMCMD> <span style="color: #ff0000;"><strong>afd_state</strong></span>
ASMCMD-9526: The AFD state is 'NOT INSTALLED' and filtering is 'DEFAULT' on host 'b20e4bay01'

filter driver disks:

21. List filter driver disks(if enabled)

ASMCMD> <span style="color: #ff0000;"><strong>afd_lsdsk

</strong></span>

22. Get filter driver asm diskstring

ASMCMD> <span style="color: #ff0000;"><strong>afd_dsget</strong></span>
AFD discovery string:

 

Do let us know if you have any useful asmcmd commands in mind. I will include them in the list.

SEE ALSO: