查看ASM磁盘组信息
|
314
|
0
|
Script

165 字
|
9 分钟 
set linesize 200 pagesize 200
col path for a20
col name for a15
col failgroup for a15
select group_number,disk_number,failgroup,name,path,state,mount_status,total_mb,free_mb,os_mb from v$asm_disk;

GROUP_NUMBER DISK_NUMBER FAILGROUP       NAME            PATH                 STATE    MOUNT_S   TOTAL_MB    FREE_MB      OS_MB
------------ ----------- --------------- --------------- -------------------- -------- ------- ---------- ---------- ----------
           0           0                                 /dev/asm-diskg       NORMAL   CLOSED           0          0      10240
           0           1                                 /dev/asm-diskh       NORMAL   CLOSED           0          0      10240
           0           2                                 /dev/asm-diskf       NORMAL   CLOSED           0          0       4096
           0           3                                 /dev/asm-diske       NORMAL   CLOSED           0          0       4096
           1           2 OCRVOTING_0002  OCRVOTING_0002  /dev/asm-diskd       NORMAL   CACHED        1024        680       1024
           1           1 OCRVOTING_0001  OCRVOTING_0001  /dev/asm-diskc       NORMAL   CACHED        1024        676       1024
           1           0 OCRVOTING_0000  OCRVOTING_0000  /dev/asm-diskb       NORMAL   CACHED        1024        676       1024

set linesize 200 pagesize 200
select group_number,name,state,type,total_mb,free_mb,required_mirror_free_mb rmfmb,usable_file_mb ufmb from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE       TYPE     TOTAL_MB    FREE_MB      RMFMB       UFMB
------------ ------------------------------ ----------- ------ ---------- ---------- ---------- ----------
           1 OCRVOTING                      MOUNTED     NORMAL       3072       2032       1024        504

col name for a40
col value for a15
select group_number,name,value from v$asm_attribute where name in ('au_size','compatible.asm','compatible.rdbms');

GROUP_NUMBER NAME                                     VALUE
------------ ---------------------------------------- ---------------
           1 au_size                                  4194304
           1 compatible.asm                           11.2.0.0.0
           1 compatible.rdbms                         10.1.0.0.0

查看磁盘是否损坏或掉盘:
set linesize 200 pagesize 200
col path for a20
col name for a15
col failgroup for a15
select group_number,disk_number,failgroup,name,path,state,mount_status,total_mb,free_mb,os_mb from v$asm_disk where mount_status<>'CACHED';

GROUP_NUMBER DISK_NUMBER FAILGROUP       NAME            PATH                 STATE    MOUNT_S   TOTAL_MB    FREE_MB      OS_MB
------------ ----------- --------------- --------------- -------------------- -------- ------- ---------- ---------- ----------
           1           5 DM01CELADM01    _DROPPED_0005_D                      FORCING  MISSING     950272     648060          0
                                         ATAC1

set pagesize 200
set linesize 150
col path format a20;
col group_name format a10
col name format a20
col FAILGROUP_TYPE format a15
col FAILGROUP format a15
select a.group_number,
       b.name as group_name,
       b.type,
       a.FAILGROUP,
       a.FAILGROUP_TYPE,
       a.name,
       a.path,
       a.state,
       a.mount_status,
       a.total_mb,
       a.free_mb
  from v$asm_disk a, v$asm_diskgroup b
 where a.group_number = b.group_number
 order by 1;

GROUP_NUMBER GROUP_NAME TYPE   FAILGROUP       FAILGROUP_TYPE  NAME                 PATH                 STATE    MOUNT_S   TOTAL_MB    FREE_MB
------------ ---------- ------ --------------- --------------- -------------------- -------------------- -------- ------- ---------- ----------
           1 DATA       EXTERN DATA_0001       REGULAR         DATA_0001            /dev/asm-diskh       NORMAL   CACHED       10240       5729
           1 DATA       EXTERN DATA_0000       REGULAR         DATA_0000            /dev/asm-diskg       NORMAL   CACHED       10240       5728
           2 FRA        EXTERN FRA_0001        REGULAR         FRA_0001             /dev/asm-diskf       NORMAL   CACHED        4096       3858
           2 FRA        EXTERN FRA_0000        REGULAR         FRA_0000             /dev/asm-diske       NORMAL   CACHED        4096       3858
           3 OCRVOTING  NORMAL OCRVOTING_0001  REGULAR         OCRVOTING_0001       /dev/asm-diskc       NORMAL   CACHED        1024        632
           3 OCRVOTING  NORMAL OCRVOTING_0000  REGULAR         OCRVOTING_0000       /dev/asm-diskb       NORMAL   CACHED        1024        636
           3 OCRVOTING  NORMAL OCRVOTING_0002  REGULAR         OCRVOTING_0002       /dev/asm-diskd       NORMAL   CACHED        1024        632

7 rows selected.

ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576     20480    11457                0           11457              0             N  DATA/
MOUNTED  EXTERN  N         512   4096  1048576      8192     7716                0            7716              0             N  FRA/
MOUNTED  NORMAL  N         512   4096  4194304      3072     1900             1024             438              0             Y  OCRVOTING/

set pagesize 300 pagesize 300
col path format a20;
col group_name format a10
col name format a20
col FAILGROUP_TYPE format a15
col FAILGROUP format a15
col REQUIRED_MIRROR_FREE_MB for 999999
select a.group_number,
       b.name as group_name,
       b.type,
       a.FAILGROUP,
       a.FAILGROUP_TYPE,
       a.name,
       a.path,
       a.state,
       a.mount_status,
       a.total_mb single_disk_mb,
       b.total_mb all_disk_mb,
       b.free_mb all_disk_free_mb,
       b.required_mirror_free_mb,
       b.usable_file_mb all_disk_usable_file_mb
  from v$asm_disk a, v$asm_diskgroup b
 where a.group_number = b.group_number
 order by 1;

GROUP_NUMBER GROUP_NAME TYPE   FAILGROUP       FAILGROUP_TYPE  NAME                 PATH                 STATE    MOUNT_S SINGLE_DISK_MB ALL_DISK_MB ALL_DISK_FREE_MB REQUIRED_MIRROR_FREE_MB ALL_DISK_USABLE_FILE_MB
------------ ---------- ------ --------------- --------------- -------------------- -------------------- -------- ------- -------------- ----------- ---------------- ----------------------- -----------------------
           1 DATA       EXTERN DATA_0001       REGULAR         DATA_0001            /dev/asm-diskh       NORMAL   CACHED           10240       20480            11457                       0                   11457
           1 DATA       EXTERN DATA_0000       REGULAR         DATA_0000            /dev/asm-diskg       NORMAL   CACHED           10240       20480            11457                       0                   11457
           2 FRA        EXTERN FRA_0001        REGULAR         FRA_0001             /dev/asm-diskf       NORMAL   CACHED            4096        8192             7716                       0                    7716
           2 FRA        EXTERN FRA_0000        REGULAR         FRA_0000             /dev/asm-diske       NORMAL   CACHED            4096        8192             7716                       0                    7716
           3 OCRVOTING  NORMAL OCRVOTING_0001  REGULAR         OCRVOTING_0001       /dev/asm-diskc       NORMAL   CACHED            1024        3072             1900                    1024                     438
           3 OCRVOTING  NORMAL OCRVOTING_0000  REGULAR         OCRVOTING_0000       /dev/asm-diskb       NORMAL   CACHED            1024        3072             1900                    1024                     438
           3 OCRVOTING  NORMAL OCRVOTING_0002  REGULAR         OCRVOTING_0002       /dev/asm-diskd       NORMAL   CACHED            1024        3072             1900                    1024                     438

7 rows selected.

FREE_MB: 就是未使用的剩余空间(MB)
REQUIRED_MIRROR_FREE_MB: 代表了如果ASM磁盘或ASM磁盘组出现了故障，要重新满足冗余度的定义，要求有多少的空闲空间，即USEABLE_MB为去除REQ_MB后剩余的空间
USABLE_FILE_MB: 代表了在满足冗余度之后，还有多少的剩余空间可以用

normal: USABLE_FILE_MB = FREE_MB - REQUIRED_MIRROR_FREE_MB
external: USABLE_FILE_MB = (FREE_MB - REQUIRED_MIRROR_FREE_MB)/2
high: USABLE_FILE_MB = (FREE_MB - REQUIRED_MIRROR_FREE_MB)/3

set linesize 500 pagesize 500
col id for 99
col path format a60;
col group_name format a10
col name format a20
col FAILGROUP_TYPE format a15
col FAILGROUP format a18
col REQUIRED_MIRROR_FREE_MB for 999999
col single_disk for a10
col diskgroup_disk for a15
col diskgroup_usable for a17
col diskgroup_free for a15
select a.group_number ID,
       b.name as group_name,
       b.type,
       a.FAILGROUP,
       ---a.FAILGROUP_TYPE,
       ---a.name,
       a.path,
       ---a.state,
       a.mount_status,
       round(a.total_mb/1024)||'GB' single_disk,
       round(b.total_mb/1024/1024)||'TB' diskgroup_disk,
       trunc(b.free_mb/1024/1024)||'TB' diskgroup_usable,
       ---b.required_mirror_free_mb,
       round(b.usable_file_mb/1024)||'GB' diskgroup_free
  from v$asm_disk a, v$asm_diskgroup b
 where a.group_number = b.group_number
 order by 1;

single_disk: 指单块磁盘空间大小
diskgroup_disk: 指每个磁盘组所有硬盘的空量总和
diskgroup_usable:  指总磁盘组容量减去冗余需要的容量后剩下的空间大小，该空间为磁盘实际能够使用的空间
diskgroup_free: 指磁盘组剩余空间
暂无评论

发送评论 编辑评论 


				

			

						

				

					

						

							

								
							

							
						

					

				

				

					

						

							

								
							

							
						

					

				

				

					

						

							

								
							

							
							
													

					

				

			

			
			

				

					
				

			

				

											

							
							
						

																				
					
											
						

	

		
|´・ω・)ノ
ヾ(≧∇≦*)ゝ
(☆ω☆)
（╯‵□′）╯︵┴─┴
￣﹃￣
(/ω＼)
∠( ᐛ 」∠)＿
(๑•̀ㅁ•́ฅ)
→_→
୧(๑•̀⌄•́๑)૭
٩(ˊᗜˋ*)و
(ノ°ο°)ノ
(´இ皿இ｀)
⌇●﹏●⌇
(ฅ´ω`ฅ)
(╯°A°)╯︵○○○
φ(￣∇￣o)
ヾ(´･ ･｀｡)ノ"
( ง ᵒ̌皿ᵒ̌)ง⁼³₌₃
(ó﹏ò｡)
Σ(っ °Д °;)っ
( ,,´･ω･)ﾉ"(´っω･｀｡)
╮(╯▽╰)╭
o(*////▽////*)q
＞﹏＜
( ๑´•ω•) "(ㆆᴗㆆ)
😂
😀
😅
😊
🙂
🙃
😌
😍
😘
😜
😝
😏
😒
🙄
😳
😡
😔
😫
😱
😭
💩
👻
🙌
🖕
👍
👫
👬
👭
🌚
🌝
🙈
💊
😶
🙏
🍦
🍉
😣
Source: github.com/k4yt3x/flowerhd
	

	

		
颜文字
Emoji
小恐龙
花!
	


									

			

			
			
		

	






上一篇
下一篇