作業系統版本 : OEL6.5 x64
資料庫版本 : Oracle 11.2.0.4 x64 RAC
本文針對oracle 11.2.0.4 x64 RAC for OEL6.5上添加存一塊存儲磁盤，并入原ASM卷組用于擴充存儲空間。詳細修改過程如下。
給兩節點node1,node2 10GB磁盤空間，添加過程略。确認兩節點磁盤識别。
[root@node1 ~]# fdisk -l
Disk /dev/sda: 32.2 GB, 32212254720 bytes
255 heads, 63 sectors/track, 3916 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x0008c7f6
Device Boot Start End Blocks Id System
/dev/sda1 * 1 64 512000 83 Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2 64 3917 30944256 8e Linux LVM
Disk /dev/mapper/vg_node1-LogVol01: 27.4 GB, 27388805120 bytes
255 heads, 63 sectors/track, 3329 cylinders
Disk identifier: 0x00000000
Disk /dev/mapper/vg_node1-swap: 4294 MB, 4294967296 bytes
255 heads, 63 sectors/track, 522 cylinders
Disk /dev/sdb: 2147 MB, 2147483648 bytes
67 heads, 62 sectors/track, 1009 cylinders
Units = cylinders of 4154 * 512 = 2126848 bytes
Disk /dev/sdc: 2147 MB, 2147483648 bytes
Disk /dev/sdd: 2147 MB, 2147483648 bytes
Disk /dev/sde: 2147 MB, 2147483648 bytes
Disk /dev/sdf: 2147 MB, 2147483648 bytes
Disk /dev/sdg: 21.5 GB, 21474836480 bytes
64 heads, 32 sectors/track, 20480 cylinders
Units = cylinders of 2048 * 512 = 1048576 bytes
Disk /dev/sdh: 21.5 GB, 21474836480 bytes
Disk /dev/sdj: 10.7 GB, 10737418240 bytes
64 heads, 32 sectors/track, 10240 cylinders
Disk /dev/sdi: 21.5 GB, 21474836480 bytes
[root@node1 ~]#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<code>for</code> <code>i </code><code>in</code> <code>b c d e f g h i j;</code>
<code>do</code>
<code>echo </code><code>"KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\""</code>
<code>done</code>
<code>KERNEL==</code><code>"sd*"</code><code>, BUS==</code><code>"scsi"</code><code>, PROGRAM==</code><code>"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name"</code><code>, RESULT=="14f504e46494c4552395a55706766</code>
<code>2d52366a5a2d684a5445</code><code>", NAME="</code><code>asm-diskj</code><code>", OWNER="</code><code>grid</code><code>", GROUP="</code><code>asmadmin</code><code>", MODE="</code><code>0660</code><code>"</code>
<code>KERNEL==</code><code>"sd*"</code><code>, BUS==</code><code>"scsi"</code><code>, PROGRAM==</code><code>"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name"</code><code>, RESULT=="14f504e46494c45523768705a5241</code>
<code>2d46576d6a2d6a424f52</code><code>", NAME="</code><code>asm-diskb</code><code>", OWNER="</code><code>grid</code><code>", GROUP="</code><code>asmadmin</code><code>", MODE="</code><code>0660</code><code>"</code>
<code>KERNEL==</code><code>"sd*"</code><code>, BUS==</code><code>"scsi"</code><code>, PROGRAM==</code><code>"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name"</code><code>, RESULT=="14f504e46494c45524944414b6731</code>
<code>2d7433474f2d4c424553</code><code>", NAME="</code><code>asm-diskc</code><code>", OWNER="</code><code>grid</code><code>", GROUP="</code><code>asmadmin</code><code>", MODE="</code><code>0660</code><code>"</code>
<code>KERNEL==</code><code>"sd*"</code><code>, BUS==</code><code>"scsi"</code><code>, PROGRAM==</code><code>"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name"</code><code>, RESULT=="14f504e46494c4552496b55307865</code>
<code>2d306747442d64755064</code><code>", NAME="</code><code>asm-diskd</code><code>", OWNER="</code><code>grid</code><code>", GROUP="</code><code>asmadmin</code><code>", MODE="</code><code>0660</code><code>"</code>
<code>KERNEL==</code><code>"sd*"</code><code>, BUS==</code><code>"scsi"</code><code>, PROGRAM==</code><code>"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name"</code><code>, RESULT=="14f504e46494c4552564759334841</code>
<code>2d69635a682d784f6e57</code><code>", NAME="</code><code>asm-diske</code><code>", OWNER="</code><code>grid</code><code>", GROUP="</code><code>asmadmin</code><code>", MODE="</code><code>0660</code><code>"</code>
<code>KERNEL==</code><code>"sd*"</code><code>, BUS==</code><code>"scsi"</code><code>, PROGRAM==</code><code>"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name"</code><code>, RESULT=="14f504e46494c45523647627a3946</code>
<code>2d494d4c472d4b687276</code><code>", NAME="</code><code>asm-diskf</code><code>", OWNER="</code><code>grid</code><code>", GROUP="</code><code>asmadmin</code><code>", MODE="</code><code>0660</code><code>"</code>
<code>KERNEL==</code><code>"sd*"</code><code>, BUS==</code><code>"scsi"</code><code>, PROGRAM==</code><code>"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name"</code><code>, RESULT=="14f504e46494c4552756354627076</code>
<code>2d426a4c5a2d64753163</code><code>", NAME="</code><code>asm-diskg</code><code>", OWNER="</code><code>grid</code><code>", GROUP="</code><code>asmadmin</code><code>", MODE="</code><code>0660</code><code>"</code>
<code>KERNEL==</code><code>"sd*"</code><code>, BUS==</code><code>"scsi"</code><code>, PROGRAM==</code><code>"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name"</code><code>, RESULT=="14f504e46494c4552436b35585371</code>
<code>2d324e646c2d75386f45</code><code>", NAME="</code><code>asm-diskh</code><code>", OWNER="</code><code>grid</code><code>", GROUP="</code><code>asmadmin</code><code>", MODE="</code><code>0660</code><code>"</code>
<code>KERNEL==</code><code>"sd*"</code><code>, BUS==</code><code>"scsi"</code><code>, PROGRAM==</code><code>"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name"</code><code>, RESULT=="14f504e46494c4552577651593537</code>
<code>2d6b644c592d6c326c39</code><code>", NAME="</code><code>asm-diski</code><code>", OWNER="</code><code>grid</code><code>", GROUP="</code><code>asmadmin</code><code>", MODE="</code><code>0660</code><code>"</code>
# vi /etc/udev/rules.d/99-oracle-asmdevices.rules
<a href="http://koumm.blog.51cto.com/attachment/201401/22/703525_1390396200N9Ql.jpg" target="_blank"></a>
<a href="http://koumm.blog.51cto.com/attachment/201401/22/703525_1390396203DfnZ.jpg" target="_blank"></a>
[root@node1 ~]# su - grid
[grid@node1 ~]$ sqlplus / as sysasm
SQL> set pagesize 999;
SQL> set linesize 200;
SQL> col name format a20;
SQL> select group_number,name,TOTAL_MB, FREE_MB from v$asm_diskgroup;
<a href="http://koumm.blog.51cto.com/attachment/201401/22/703525_1390396205FUR0.jpg" target="_blank"></a>
SQL> col name format a20;
SQL> col path format a20;
SQL> select name,path,mode_status,state,disk_number,failgroup from v$asm_disk;
<a href="http://koumm.blog.51cto.com/attachment/201401/22/703525_1390396207pbZD.jpg" target="_blank"></a>
<a href="http://koumm.blog.51cto.com/attachment/201401/22/703525_1390396209M63V.jpg" target="_blank"></a>
SQL>
SQL> alter diskgroup DATA add disk '/dev/asm-diskj' rebalance power 1;
Diskgroup altered.
SQL>
<a href="http://koumm.blog.51cto.com/attachment/201401/22/703525_1390396210k13X.jpg" target="_blank"></a>
NAME PATH MODE_STATUS STATE DISK_NUMBER FAILGROUP
-------------------- -------------------- --------------------- ------------------------ ----------- --------------
CRS_0003 /dev/asm-diske ONLINE NORMAL 3 CRS_0003
RECOVERY_0000 /dev/asm-diski ONLINE NORMAL 0 RECOVERY_0000
CRS_0000 /dev/asm-diskb ONLINE NORMAL 0 CRS_0000
CRS_0004 /dev/asm-diskf ONLINE NORMAL 4 CRS_0004
CRS_0002 /dev/asm-diskd ONLINE NORMAL 2 CRS_0002
CRS_0001 /dev/asm-diskc ONLINE NORMAL 1 CRS_0001
DATA_0001 /dev/asm-diskh ONLINE NORMAL 1 DATA_0001
DATA_0000 /dev/asm-diskg ONLINE NORMAL 0 DATA_0000
DATA_0002 /dev/asm-diskj ONLINE NORMAL 2 DATA_0002
磁盤容量有增加
<a href="http://koumm.blog.51cto.com/attachment/201401/22/703525_13903962126RYt.png" target="_blank"></a>
發現兩節點監點不正常，下面正常啟動一下。
<a href="http://koumm.blog.51cto.com/attachment/201401/22/703525_1390396214ashs.jpg" target="_blank"></a>
通過crs_stat檢視監聽全名稱，通過下面的方式重新開機。
<a href="http://koumm.blog.51cto.com/attachment/201401/22/703525_1390396218iJrp.jpg" target="_blank"></a>
<a href="http://koumm.blog.51cto.com/attachment/201401/22/703525_1390396220j9ZU.jpg" target="_blank"></a>
<a href="http://koumm.blog.51cto.com/attachment/201401/22/703525_1390396223WTgx.jpg" target="_blank"></a>
叢集正常。
本文轉自 koumm 51CTO部落格，原文連結：http://blog.51cto.com/koumm/1353927，如需轉載請自行聯系原作者
![阿裡雲天池龍珠計劃SQL訓練營day1[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)