1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
| 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 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';
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
查看ASM磁盘组信息:
SQL> set linesize 300 pagesize 300
SQL> select * from v_disksize;
GROUP_NUMBER NAME STATE TYPE TOTAL_GB FREE_GB
1 DATA CONNECTED EXTERN 8000 5072.18
2 OCR MOUNTED NORMAL 90 89.1
|
