一、查找voting disk 的4种方法
方法1:
[root@RAC1 ~]# crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 983f5a2d804d4f81bfddc68e5bcf6e65 (/dev/asm-diskc) [DATA] Located 1 voting disk(s). [root@RAC1 ~]#
方法2:
[grid@RAC1 ~]$ asmcmd dsget parameter:/dev/asm* profile:/dev/asm* [grid@RAC1 ~]$
方法3:
[grid@RAC1 ~]$ gpnptool get
Warning: some command line parameters were defaulted. Resulting command line:
/u01/11.2.0/grid/bin/gpnptool.bin get -o-
<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="4" ClusterUId="4c62524e6a7dff62ffdae005dc6a08d6" ClusterName="racdb" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" IP="192.168.56.0" Adapter="eth0" Use="public"/><gpnp:Network id="net2" IP="192.168.88.0" Adapter="eth1" Use="cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="/dev/asm*" SPFile="+DATA/racdb/asmparameterfile/registry.253.814453247"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>NMq7bQ3EHBa9wKwma65k60q9+lo=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>hkf1TmKQMdERaBHuHx57vN/GxywzzxuZn0FjO0WqYpFWquF2mc+Pu0isVUHLvdhxzJ1snDmP+vVZ5V8Q1aaBi2KctXvHS1d81mY9PlXj47+/wIy38qZtg0vmazXscDG7rVfQb3jCtpa9vWE7S4Lq9p9Jq73emHvHk9FeTzYAs18=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>
Success.
[grid@RAC1 ~]$
方法4:
[grid@RAC1 ~]$ kfed dev=/dev/asm-diskc op=READ | egrep "kfdhdb.vf|ausize" kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000 kfdhdb.vfstart: 192 ; 0x0ec: 0x000000c0 kfdhdb.vfend: 224 ; 0x0f0: 0x000000e0 [grid@RAC1 ~]$
这里可以看到au是1M,voting disk从AU 192开始,到AU 224结束,共32个AU :
[grid@RAC1 ~]$ dd if=/dev/asm-diskc bs=1M skip=192 count=32 | od -c > /tmp/vote.out 32+0 records in 32+0 records out 33554432 bytes (34 MB) copied, 1.30292 seconds, 25.8 MB/s [grid@RAC1 ~]$
跳过了头上的192M,dump了后面的32M内容,也就是我们需要的VOTING DISK的32个AU的内容
二、查找ocr的方法
方法1:
[grid@RAC1 ~]$ cat /etc/oracle/ocr.loc ocrconfig_loc=+DATA local_only=FALSE [grid@RAC1 ~]$
方法2:
[grid@RAC1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 3056
Available space (kbytes) : 259064
ID : 1280092817
Device/File Name : +DATA
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check bypassed due to non-privileged user
[grid@RAC1 ~]$
方法3: ocrdump
方法4:
set lines 120
set pages 100
column name format a40 wra
column type format a10 tru
select af.group_number, af.file_number, aa.name, af.type, af.redundancy
from v$asm_file af, v$asm_alias aa
where aa.file_number = af.file_number and aa.group_number=af.group_number and af.type = 'OCRFILE' ;
SYS% racdb1> select af.group_number, af.file_number, aa.name, af.type, af.redundancy
2 from v$asm_file af, v$asm_alias aa
3 where aa.file_number = af.file_number and aa.group_number=af.group_number and af.type = 'OCRFILE' ;
GROUP_NUMBER FILE_NUMBER NAME TYPE REDUND
------------ ----------- ---------------------------------------- ---------- ------
2 255 REGISTRY.255.814453249 OCRFILE UNPROT
Elapsed: 00:00:08.70
SYS% racdb1>
这里看到ocr的文件号是255,可以根据文件号查询AU:
SQL> set lines 120
SQL> set pages 100
SQL> column name format a40 wra
SQL> column type format a10 tru
SQL> select af.group_number, af.file_number, aa.name, af.type, af.redundancy
2 from v$asm_file af, v$asm_alias aa
3 where aa.file_number = af.file_number and aa.group_number=af.group_number and af.type = 'OCRFILE' ;
GROUP_NUMBER FILE_NUMBER NAME TYPE REDUND
------------ ----------- ---------------------------------------- ---------- ------
2 255 REGISTRY.255.814453249 OCRFILE UNPROT
SQL>
SQL> select NUMBER_KFFXP, XNUM_KFFXP, DISK_KFFXP, AU_KFFXP from X$KFFXP where NUMBER_KFFXP = 255;
NUMBER_KFFXP XNUM_KFFXP DISK_KFFXP AU_KFFXP
------------ ---------- ---------- ----------
255 0 1 29
255 1 0 32
255 2 1 30
255 3 0 33
255 4 1 31
255 5 0 34
255 6 1 32
255 7 0 35
255 8 1 33
255 9 0 36
255 10 1 34
255 11 0 37
255 12 1 35
255 13 0 38
255 14 1 36
255 15 0 39
255 16 1 37
255 17 0 40
255 18 1 38
255 19 0 41
255 20 1 39
255 21 0 42
255 22 1 40
255 23 0 43
255 24 1 41
255 25 0 44
255 26 1 42
255 27 0 45
255 28 1 43
255 29 0 46
255 30 1 44
255 31 0 47
255 32 1 45
255 33 0 48
255 34 1 46
255 35 0 49
255 36 1 47
255 37 0 50
255 38 1 48
255 39 0 51
255 40 1 49
255 41 0 52
255 42 1 50
255 43 0 53
255 44 1 51
255 45 0 54
255 46 1 52
255 47 0 55
255 48 1 53
255 49 0 56
255 50 1 54
255 51 0 57
255 52 1 55
255 53 0 58
255 54 1 56
255 55 0 59
255 56 1 57
255 57 0 60
255 58 1 58
255 59 0 61
255 60 1 59
255 61 0 63
255 62 1 60
255 63 0 64
255 64 1 61
255 65 0 65
255 66 1 62
255 67 0 66
255 68 1 63
255 69 0 67
255 70 1 64
255 71 0 68
255 72 1 65
255 73 0 69
255 74 1 66
255 75 0 70
255 76 1 67
255 77 0 71
255 78 1 68
255 79 0 72
255 80 1 69
255 81 0 73
255 82 1 70
255 83 0 74
255 84 1 71
255 85 0 75
255 86 1 72
255 87 0 76
255 88 1 73
255 89 0 77
255 90 1 74
255 91 0 78
255 92 1 75
255 93 0 79
255 94 1 76
255 95 0 80
255 96 1 77
NUMBER_KFFXP XNUM_KFFXP DISK_KFFXP AU_KFFXP
------------ ---------- ---------- ----------
255 97 0 81
255 98 1 78
255 99 0 82
255 100 1 79
255 101 0 83
255 102 1 80
255 103 0 84
255 104 1 81
255 105 0 85
255 106 1 82
255 107 0 86
255 108 1 83
255 109 0 87
255 110 1 84
255 111 0 88
255 112 1 85
255 113 0 89
255 114 1 86
255 115 0 90
255 116 1 87
255 117 0 91
255 118 1 88
255 119 0 92
255 120 1 89
255 121 0 93
255 122 1 90
255 123 0 94
255 124 1 91
255 125 0 95
255 126 1 92
255 127 0 96
255 128 1 93
255 129 0 97
255 130 1 94
255 131 0 98
255 132 1 95
255 133 0 99
255 134 1 96
255 135 0 100
255 136 1 97
255 137 0 101
255 138 1 98
255 139 0 102
255 140 1 99
255 141 0 103
255 142 1 100
255 143 0 104
255 144 1 101
255 145 0 105
255 146 1 102
255 147 0 106
255 148 1 103
255 149 0 107
255 150 1 104
255 151 0 108
255 152 1 105
255 153 0 109
255 154 1 106
255 155 0 110
255 156 1 107
255 157 0 111
255 158 1 108
255 159 0 112
255 160 1 109
255 161 0 113
255 162 1 110
255 163 0 114
255 164 1 111
255 165 0 115
255 166 1 112
255 167 0 116
255 168 1 113
255 169 0 117
255 170 1 114
255 171 0 118
255 172 1 115
255 173 0 119
255 174 1 116
255 175 0 120
255 176 1 117
255 177 0 121
255 178 1 118
255 179 0 122
255 180 1 119
255 181 0 123
255 182 1 120
255 183 0 124
255 184 1 121
255 185 0 125
255 186 1 122
255 187 0 126
255 188 1 123
255 189 0 127
255 190 1 124
255 191 0 128
255 192 1 125
255 193 0 129
NUMBER_KFFXP XNUM_KFFXP DISK_KFFXP AU_KFFXP
------------ ---------- ---------- ----------
255 194 1 126
255 195 0 130
255 196 1 127
255 197 0 131
255 198 1 128
255 199 0 132
255 200 1 129
255 201 0 133
255 202 1 130
255 203 0 134
255 204 1 131
255 205 0 135
255 206 1 132
255 207 0 136
255 208 1 133
255 209 0 137
255 210 1 134
255 211 0 138
255 212 1 135
255 213 0 139
255 214 1 136
255 215 0 140
255 216 1 137
255 217 0 141
255 218 1 138
255 219 0 142
255 220 1 139
255 221 0 143
255 222 1 140
255 223 0 144
255 224 1 141
255 225 0 145
255 226 1 142
255 227 0 146
255 228 1 143
255 229 0 147
255 230 1 144
255 231 0 148
255 232 1 145
255 233 0 149
255 234 1 146
255 235 0 150
255 236 1 147
255 237 0 151
255 238 1 148
255 239 0 152
255 240 1 149
255 241 0 153
255 242 1 150
255 243 0 154
255 244 1 151
255 245 0 155
255 246 1 152
255 247 0 156
255 248 1 153
255 249 0 157
255 250 1 154
255 251 0 158
255 252 1 155
255 253 0 159
255 254 1 156
255 255 0 160
255 256 1 157
255 257 0 161
255 258 1 158
255 259 0 162
255 260 1 159
255 2147483648 0 62
262 rows selected.
SQL>
