OUTPUT: asmcmd_script.OUT ASMCMD commands to gather complementary metadata information: ================================== $ asmcmd -p ls -ls --- display extended file information State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 1048576 40944 18471 10236 4117 0 N DATA/ MOUNTED EXTERN N 512 4096 1048576 40952 31211 0 31211 0 N FRA2/ MOUNTED NORMAL N 512 4096 4194304 6132 4960 2044 1458 0 Y OCR/ MOUNTED NORMAL N 512 4096 1048576 2046 1746 0 873 0 N TEST_NEW/ ================================== Attributes for Diskgroup : DATA $ asmcmd lsattr -G DATA -l Name Value access_control.enabled FALSE access_control.umask 066 au_size 1048576 cell.smart_scan_capable FALSE compatible.asm 11.2.0.0.0 compatible.rdbms 10.1.0.0.0 disk_repair_time 3.6h sector_size 512 ------------------------------------------ Attributes for Diskgroup : FRA2 $ asmcmd lsattr -G FRA2 -l Name Value access_control.enabled FALSE access_control.umask 066 au_size 1048576 cell.smart_scan_capable FALSE compatible.asm 11.2.0.0.0 compatible.rdbms 11.2.0.0.0 disk_repair_time 3.6h sector_size 512 ------------------------------------------ Attributes for Diskgroup : OCR $ asmcmd lsattr -G OCR -l Name Value access_control.enabled FALSE access_control.umask 066 au_size 4194304 cell.smart_scan_capable FALSE compatible.asm 11.2.0.0.0 compatible.rdbms 11.2.0.0.0 disk_repair_time 3.6h sector_size 512 ------------------------------------------ Attributes for Diskgroup : TEST_NEW $ asmcmd lsattr -G TEST_NEW -l Name Value access_control.enabled FALSE access_control.umask 066 au_size 1048576 cell.smart_scan_capable FALSE compatible.asm 11.2.0.0.0 compatible.rdbms 10.1.0.0.0 disk_repair_time 3.6h sector_size 512 ------------------------------------------ ================================== $ asmcmd -p lsct --- Lists information about current Oracle ASM clients from the V$ASM_CLIENT view DB_Name Status Software_Version Compatible_version Instance_Name Disk_Group +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0 +ASM1 OCR +ASM CONNECTED 11.2.0.4.0 11.2.0.4.0 +ASM1 DATA grac4 CONNECTED 11.2.0.4.0 11.2.0.4.0 grac41 DATA grac4 CONNECTED 11.2.0.4.0 11.2.0.4.0 grac41 FRA2 ================================== $ asmcmd -p lsdg --- List Diskgroup details State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 1048576 40944 18471 10236 4117 0 N DATA/ MOUNTED EXTERN N 512 4096 1048576 40952 31211 0 31211 0 N FRA2/ MOUNTED NORMAL N 512 4096 4194304 6132 4960 2044 1458 0 Y OCR/ MOUNTED NORMAL N 512 4096 1048576 2046 1746 0 873 0 N TEST_NEW/ ================================== $ asmcmd -p lsdsk --- List ASM disk details Path /dev/asm_data_10G_disk0 /dev/asm_data_10G_disk1 /dev/asm_data_10G_disk2 /dev/asm_data_10G_disk3 /dev/asm_ocr_11204_2G_disk1 /dev/asm_ocr_11204_2G_disk2 /dev/asm_ocr_11204_2G_disk3 /dev/asm_test_1G_disk1 /dev/asm_test_1G_disk2 /dev/asmdisk_fra1 /dev/asmdisk_fra2 ================================== $ asmcmd -p lsof --- Lists the open files of the local clients DB_Name Instance_Name Path +ASM +ASM1 +ocr.255.4294967295 grac4 grac41 +data/grac4/controlfile/current.260.826111693 grac4 grac41 +data/grac4/datafile/sysaux.257.826111425 grac4 grac41 +data/grac4/datafile/system.256.826111425 grac4 grac41 +data/grac4/datafile/undotbs1.258.826111425 grac4 grac41 +data/grac4/datafile/undotbs2.264.826111755 grac4 grac41 +data/grac4/datafile/undotbs3.268.826220083 grac4 grac41 +data/grac4/datafile/users.259.826111427 grac4 grac41 +data/grac4/onlinelog/group_1.274.852650227 grac4 grac41 +data/grac4/onlinelog/group_2.273.852651533 grac4 grac41 +data/grac4/onlinelog/group_3.272.852652849 grac4 grac41 +data/grac4/onlinelog/group_4.266.852652635 grac4 grac41 +data/grac4/onlinelog/group_5.270.852652251 grac4 grac41 +data/grac4/onlinelog/group_6.269.852652289 grac4 grac41 +data/grac4/tempfile/temp.263.826111719 grac4 grac41 +fra2/grac4/controlfile/current.338.852722827 grac4 grac41 +fra2/grac4/onlinelog/group_1.285.852650241 grac4 grac41 +fra2/grac4/onlinelog/group_2.298.852651537 grac4 grac41 +fra2/grac4/onlinelog/group_3.318.852652859 grac4 grac41 +fra2/grac4/onlinelog/group_4.294.852652647 grac4 grac41 +fra2/grac4/onlinelog/group_5.305.852652263 grac4 grac41 +fra2/grac4/onlinelog/group_6.306.852652301 ================================== $ asmcmd -p lsod --- Lists the open Oracle ASM disks Instance Process OSPID Path 1 oracle@grac41.example.com (DBW0) 5200 /dev/asm_data_10G_disk0 1 oracle@grac41.example.com (DBW0) 5200 /dev/asm_data_10G_disk1 1 oracle@grac41.example.com (DBW0) 5200 /dev/asm_data_10G_disk2 1 oracle@grac41.example.com (DBW0) 5200 /dev/asm_data_10G_disk3 1 oracle@grac41.example.com (DBW0) 5200 /dev/asm_ocr_11204_2G_disk1 1 oracle@grac41.example.com (DBW0) 5200 /dev/asm_ocr_11204_2G_disk2 1 oracle@grac41.example.com (DBW0) 5200 /dev/asm_ocr_11204_2G_disk3 1 oracle@grac41.example.com (DBW0) 5200 /dev/asm_test_1G_disk1 1 oracle@grac41.example.com (DBW0) 5200 /dev/asm_test_1G_disk2 1 oracle@grac41.example.com (DBW0) 5200 /dev/asmdisk_fra1 1 oracle@grac41.example.com (DBW0) 5200 /dev/asmdisk_fra2 1 oracle@grac41.example.com (GMON) 5210 /dev/asm_data_10G_disk0 1 oracle@grac41.example.com (GMON) 5210 /dev/asm_data_10G_disk1 1 oracle@grac41.example.com (GMON) 5210 /dev/asm_data_10G_disk2 1 oracle@grac41.example.com (GMON) 5210 /dev/asm_data_10G_disk3 1 oracle@grac41.example.com (GMON) 5210 /dev/asm_ocr_11204_2G_disk1 1 oracle@grac41.example.com (GMON) 5210 /dev/asm_ocr_11204_2G_disk2 1 oracle@grac41.example.com (GMON) 5210 /dev/asm_ocr_11204_2G_disk3 1 oracle@grac41.example.com (GMON) 5210 /dev/asm_test_1G_disk1 1 oracle@grac41.example.com (GMON) 5210 /dev/asm_test_1G_disk2 1 oracle@grac41.example.com (GMON) 5210 /dev/asmdisk_fra1 1 oracle@grac41.example.com (GMON) 5210 /dev/asmdisk_fra2 1 oracle@grac41.example.com (LGWR) 5202 /dev/asm_data_10G_disk0 1 oracle@grac41.example.com (LGWR) 5202 /dev/asm_data_10G_disk1 1 oracle@grac41.example.com (LGWR) 5202 /dev/asm_data_10G_disk2 1 oracle@grac41.example.com (LGWR) 5202 /dev/asm_data_10G_disk3 1 oracle@grac41.example.com (LGWR) 5202 /dev/asm_ocr_11204_2G_disk1 1 oracle@grac41.example.com (LGWR) 5202 /dev/asm_ocr_11204_2G_disk2 1 oracle@grac41.example.com (LGWR) 5202 /dev/asm_ocr_11204_2G_disk3 1 oracle@grac41.example.com (LGWR) 5202 /dev/asm_test_1G_disk1 1 oracle@grac41.example.com (LGWR) 5202 /dev/asm_test_1G_disk2 1 oracle@grac41.example.com (LGWR) 5202 /dev/asmdisk_fra1 1 oracle@grac41.example.com (LGWR) 5202 /dev/asmdisk_fra2 1 oracle@grac41.example.com (RBAL) 5208 /dev/asm_data_10G_disk0 1 oracle@grac41.example.com (RBAL) 5208 /dev/asm_data_10G_disk1 1 oracle@grac41.example.com (RBAL) 5208 /dev/asm_data_10G_disk1 1 oracle@grac41.example.com (RBAL) 5208 /dev/asm_data_10G_disk2 1 oracle@grac41.example.com (RBAL) 5208 /dev/asm_data_10G_disk3 1 oracle@grac41.example.com (RBAL) 5208 /dev/asm_ocr_11204_2G_disk1 1 oracle@grac41.example.com (RBAL) 5208 /dev/asm_ocr_11204_2G_disk2 1 oracle@grac41.example.com (RBAL) 5208 /dev/asm_ocr_11204_2G_disk3 1 oracle@grac41.example.com (RBAL) 5208 /dev/asmdisk_fra1 1 oracle@grac41.example.com (RBAL) 5208 /dev/asmdisk_fra1 1 oracle@grac41.example.com (TNS V1-V3) 25030 /dev/asm_data_10G_disk0 1 oracle@grac41.example.com (TNS V1-V3) 6023 /dev/asm_data_10G_disk0 1 oracle@grac41.example.com (TNS V1-V3) 6027 /dev/asm_data_10G_disk0 1 oracle@grac41.example.com (TNS V1-V3) 25030 /dev/asm_data_10G_disk1 1 oracle@grac41.example.com (TNS V1-V3) 6023 /dev/asm_data_10G_disk1 1 oracle@grac41.example.com (TNS V1-V3) 6027 /dev/asm_data_10G_disk1 1 oracle@grac41.example.com (TNS V1-V3) 25030 /dev/asm_data_10G_disk2 1 oracle@grac41.example.com (TNS V1-V3) 6023 /dev/asm_data_10G_disk2 1 oracle@grac41.example.com (TNS V1-V3) 6027 /dev/asm_data_10G_disk2 1 oracle@grac41.example.com (TNS V1-V3) 25030 /dev/asm_data_10G_disk3 1 oracle@grac41.example.com (TNS V1-V3) 6023 /dev/asm_data_10G_disk3 1 oracle@grac41.example.com (TNS V1-V3) 6027 /dev/asm_data_10G_disk3 1 oracle@grac41.example.com (TNS V1-V3) 25030 /dev/asm_ocr_11204_2G_disk1 1 oracle@grac41.example.com (TNS V1-V3) 5764 /dev/asm_ocr_11204_2G_disk1 1 oracle@grac41.example.com (TNS V1-V3) 6023 /dev/asm_ocr_11204_2G_disk1 1 oracle@grac41.example.com (TNS V1-V3) 6027 /dev/asm_ocr_11204_2G_disk1 1 oracle@grac41.example.com (TNS V1-V3) 25030 /dev/asm_ocr_11204_2G_disk2 1 oracle@grac41.example.com (TNS V1-V3) 6023 /dev/asm_ocr_11204_2G_disk2 1 oracle@grac41.example.com (TNS V1-V3) 6027 /dev/asm_ocr_11204_2G_disk2 1 oracle@grac41.example.com (TNS V1-V3) 25030 /dev/asm_ocr_11204_2G_disk3 1 oracle@grac41.example.com (TNS V1-V3) 5764 /dev/asm_ocr_11204_2G_disk3 1 oracle@grac41.example.com (TNS V1-V3) 6023 /dev/asm_ocr_11204_2G_disk3 1 oracle@grac41.example.com (TNS V1-V3) 6027 /dev/asm_ocr_11204_2G_disk3 1 oracle@grac41.example.com (TNS V1-V3) 25030 /dev/asm_test_1G_disk1 1 oracle@grac41.example.com (TNS V1-V3) 6023 /dev/asm_test_1G_disk1 1 oracle@grac41.example.com (TNS V1-V3) 25030 /dev/asm_test_1G_disk2 1 oracle@grac41.example.com (TNS V1-V3) 6023 /dev/asm_test_1G_disk2 1 oracle@grac41.example.com (TNS V1-V3) 25030 /dev/asmdisk_fra1 1 oracle@grac41.example.com (TNS V1-V3) 6023 /dev/asmdisk_fra1 1 oracle@grac41.example.com (TNS V1-V3) 25030 /dev/asmdisk_fra2 1 oracle@grac41.example.com (TNS V1-V3) 6023 /dev/asmdisk_fra2 ================================== $ asmcmd -p iostat --- Displays I/O statistics for Oracle ASM disks in mounted disk groups Group_Name Dsk_Name Reads Writes DATA DATA_0000 11907802112 984553472 DATA DATA_0001 2966020096 2555700736 DATA DATA_0002 6684483072 2632183296 DATA DATA_0003 5571596800 2595161088 FRA2 FRA2_0000 13695417856 4735993856 FRA2 FRA2_0001 13467484160 3110062080 OCR DISK1 5160960 32256 OCR DISK2 684032 24576 OCR DISK3 727552 32256 TEST_NEW TEST_0000 2641920 129859584 TEST_NEW TEST_0001 1482752 129859584 ================================== $ asmcmd -p dsget --- Retrieves the discovery diskstring value that is used by the Oracle ASM instance and its clients parameter:/dev/asm* profile:/dev/asm* ================================== $ asmcmd -p lsop --- Lists the current operations on a disk group in an Oracle ASM instance Group_Name Dsk_Num State Power EST_WORK EST_RATE EST_TIME ================================== $ asmcmd -p spget --- Retrieves the location of the Oracle ASM SPFILE from the GPnP profile +OCR/grac4/asmparameterfile/spfileASM.ora ================================== Templates for Diskgroup : DATA $ asmcmd lstmpl -G DATA Group_Name Group_Num Name DATA 1 ARCHIVELOG DATA 1 ASMPARAMETERFILE DATA 1 AUTOBACKUP DATA 1 BACKUPSET DATA 1 CHANGETRACKING DATA 1 CONTROLFILE DATA 1 DATAFILE DATA 1 DATAGUARDCONFIG DATA 1 DUMPSET DATA 1 FLASHBACK DATA 1 FLASHFILE DATA 1 OCRFILE DATA 1 ONLINELOG DATA 1 PARAMETERFILE DATA 1 TEMPFILE DATA 1 XTRANSPORT DATA 1 XTRANSPORT BACKUPSET ------------------------------------------ Templates for Diskgroup : FRA2 $ asmcmd lstmpl -G FRA2 Group_Name Group_Num Name FRA2 2 ARCHIVELOG FRA2 2 ASMPARAMETERFILE FRA2 2 AUTOBACKUP FRA2 2 BACKUPSET FRA2 2 CHANGETRACKING FRA2 2 CONTROLFILE FRA2 2 DATAFILE FRA2 2 DATAGUARDCONFIG FRA2 2 DUMPSET FRA2 2 FLASHBACK FRA2 2 FLASHFILE FRA2 2 OCRFILE FRA2 2 ONLINELOG FRA2 2 PARAMETERFILE FRA2 2 TEMPFILE FRA2 2 XTRANSPORT FRA2 2 XTRANSPORT BACKUPSET ------------------------------------------ Templates for Diskgroup : OCR $ asmcmd lstmpl -G OCR Group_Name Group_Num Name OCR 3 ARCHIVELOG OCR 3 ASMPARAMETERFILE OCR 3 AUTOBACKUP OCR 3 BACKUPSET OCR 3 CHANGETRACKING OCR 3 CONTROLFILE OCR 3 DATAFILE OCR 3 DATAGUARDCONFIG OCR 3 DUMPSET OCR 3 FLASHBACK OCR 3 FLASHFILE OCR 3 OCRFILE OCR 3 ONLINELOG OCR 3 PARAMETERFILE OCR 3 TEMPFILE OCR 3 XTRANSPORT OCR 3 XTRANSPORT BACKUPSET ------------------------------------------ Templates for Diskgroup : TEST_NEW $ asmcmd lstmpl -G TEST_NEW Group_Name Group_Num Name TEST_NEW 4 ARCHIVELOG TEST_NEW 4 ASMPARAMETERFILE TEST_NEW 4 AUTOBACKUP TEST_NEW 4 BACKUPSET TEST_NEW 4 CHANGETRACKING TEST_NEW 4 CONTROLFILE TEST_NEW 4 DATAFILE TEST_NEW 4 DATAGUARDCONFIG TEST_NEW 4 DUMPSET TEST_NEW 4 FLASHBACK TEST_NEW 4 FLASHFILE TEST_NEW 4 OCRFILE TEST_NEW 4 ONLINELOG TEST_NEW 4 PARAMETERFILE TEST_NEW 4 TEMPFILE TEST_NEW 4 XTRANSPORT TEST_NEW 4 XTRANSPORT BACKUPSET ------------------------------------------ ================================== List ASM users in Diskgroup : DATA $ asmcmd lsusr -G DATA User_Num OS_ID OS_Name ------------------------------------------ List ASM users in Diskgroup : FRA2 $ asmcmd lsusr -G FRA2 User_Num OS_ID OS_Name ------------------------------------------ List ASM users in Diskgroup : OCR $ asmcmd lsusr -G OCR User_Num OS_ID OS_Name ------------------------------------------ List ASM users in Diskgroup : TEST_NEW $ asmcmd lsusr -G TEST_NEW User_Num OS_ID OS_Name ------------------------------------------ ================================== $ asmcmd -p lsgrp -a --- Lists all Oracle ASM user groups DG_Name Grp_Name Owner Members ================================== $ asmcmd -p lspwusr --- List the users from the local Oracle ASM password file Username sysdba sysoper sysasm SYS TRUE TRUE TRUE ASMSNMP TRUE FALSE FALSE ================================== List ASM users in Diskgroup : DATA $ asmcmd -p volinfo -G DATA -a diskgroup DATA has no volumes or is not mounted ------------------------------------------ List ASM users in Diskgroup : FRA2 $ asmcmd -p volinfo -G FRA2 -a diskgroup FRA2 has no volumes or is not mounted ------------------------------------------ List ASM users in Diskgroup : OCR $ asmcmd -p volinfo -G OCR -a diskgroup OCR has no volumes or is not mounted ------------------------------------------ List ASM users in Diskgroup : TEST_NEW $ asmcmd -p volinfo -G TEST_NEW -a diskgroup TEST_NEW has no volumes or is not mounted ------------------------------------------