Differences between revisions 2 and 3
⇤ ← Revision 2 as of 2022-11-21 07:33:23 →
Size: 562
Editor: localhost
Comment:
← Revision 3 as of 2022-11-21 07:37:10 → ⇥
Size: 562
Editor: localhost
Comment:
Deletions are marked like this. Additions are marked like this.
Line 15: Line 15:
column PATH format a70
column NAME format a20;
select GROUP_NUMBER,DISK_NUMBER,HEADER_STATUS,MODE_STATUS,MOUNT_STATUS,STATE,total_mb,free_mb,NAME,PATH from v$asm_disk;		 column PATH format a60
column NAME format a16;
SELECT group_number,disk_number,header_status,mode_status,mount_status,state,total_mb,free_mb,name,path
FROM v$asm_disk;
Line 21: Line 22:
multipath –ll multipath -ll

前期准备工作

查看ASM磁盘组信息

  • login in as grid user

$ asmcmd lsdg

查看ASM 磁盘空间使用情况

  • login in as grid user

$ asmcmd lsdsk -k

$ sqlplus / as sysasm 

SQL>
set linesize 300
column PATH format a60
column NAME format a16;
SELECT group_number,disk_number,header_status,mode_status,mount_status,state,total_mb,free_mb,name,path 
FROM v$asm_disk;

检查多路径状态

multipath -ll

查看磁盘的分区和挂载情况

lsblk

或者

lsblk -o +fstype,label,uuid

désert/Oracle/Collection (last edited 2024-03-20 07:16:34 by merlyn)