Oracle 11g rac asm磁盘扩容

来源：这里教程网时间：2026-03-03 16:52:12 作者：
给的存储ID是：WWN:60:06:01:60:87:F0:48:00:9E:77:14:61:E6:9A:7E:FF  500G multipath
节点1：
[root@datacenter1-srv ~]# cd /dev/disk/
[root@datacenter1-srv ~]# cd /dev/disk/
[root@datacenter1-srv disk]# ls
by-id  by-path  by-uuid
[root@datacenter1-srv disk]# cd by-id/
[root@datacenter1-srv by-id]# ls -ltr
[root@datacenter1-srv by-id]# multipath -ll
[root@datacenter1-srv by-id]# cd /sys/class/scsi_host/
[root@datacenter1-srv scsi_host]# ls
host0  host1  host10  host11  host12  host13  host14  host15  host16  host2  host3  host4  host5  host6  host7  host8  host9
[root@datacenter1-srv scsi_host]# echo "- - -" >host0/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host1/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host10/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host11/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host12/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host13/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host14/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host15/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host16/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host2/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host3/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host4/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host5/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host6/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host7/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host8/scan
[root@datacenter1-srv scsi_host]# echo "- - -" >host9/scan
[root@datacenter1-srv scsi_host]# ip r
192.168.1.0/24 dev bond1  proto kernel  scope link  src 192.168.1.21
10.16.7.0/24 dev bond0  proto kernel  scope link  src 10.16.7.21
169.254.0.0/16 dev bond1  proto kernel  scope link  src 169.254.123.32
default via 10.16.7.254 dev bond0
[root@datacenter1-srv scsi_host]# cd /dev/disk/by-id/
[root@datacenter1-srv by-id]# ls -ltr
lrwxrwxrwx 1 root root 10 Aug 12 20:40 scsi-36006016087f048009e771461e69a7eff -> ../../sddl
lrwxrwxrwx 1 root root 10 Aug 12 20:40 wwn-0x6006016087f048009e771461e69a7eff -> ../../sddl
lrwxrwxrwx 1 root root 11 Aug 12 20:40 dm-uuid-mpath-36006016087f048009e771461e69a7eff -> ../../dm-30
[root@datacenter1-srv by-id]# multipath -ll|grep 36006016087f048009e771461e69a7eff
[root@datacenter1-srv by-id]# multipath -ll|grep -C 3  36006016087f048009e771461e69a7eff
`-+- policy='round-robin 0' prio=10 status=enabled
|- 15:0:0:8  sdr  65:16  active ready running
`- 16:0:1:8  sdw  65:96  active ready running
mpathad (36006016087f048009e771461e69a7eff) dm-30 DGC,VRAID
size=500G features='1 retain_attached_hw_handler' hwhandler='1 alua' wp=rw
|-+- policy='round-robin 0' prio=50 status=active
| |- 15:0:0:28 sddj 71:16  active ready running
--写绑定
[root@datacenter1-srv by-id]# vi /etc/multipath.conf   ---加一行
multipath {
wwid                    36006016087f048009e771461e69a7eff
alias                   data23
}
[root@datacenter1-srv by-id]# cat /etc/multipath.conf|grep 36006016087f048009e771461e69a7eff
wwid                    36006016087f048009e771461e69a7eff
[root@datacenter1-srv by-id]# cat /etc/multipath.conf|grep data
[root@datacenter1-srv by-id]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.9 (Santiago)
[root@datacenter1-srv by-id]#  service multipathd reload
[root@datacenter1-srv by-id]# multipath -ll|grep -C 3 36006016087f048009e771461e69a7eff
`-+- policy='round-robin 0' prio=10 status=enabled
|- 15:0:0:12 sdz  65:144 active ready running
`- 16:0:1:12 sdcc 69:0   active ready running
data23 (36006016087f048009e771461e69a7eff) dm-30 DGC,VRAID
size=500G features='1 retain_attached_hw_handler' hwhandler='1 alua' wp=rw
|-+- policy='round-robin 0' prio=50 status=active
| |- 15:0:0:28 sddj 71:16  active ready running
[root@datacenter1-srv by-id]# cd /etc/udev/rules.d/
[root@datacenter1-srv rules.d]# cp 99-oracle-asmdevices.rules 99-oracle-asmdevices.rules.20210812 --加一行刚才添加的
[root@datacenter1-srv rules.d]#  cat 99-oracle-asmdevices.rules |grep 36006016087f048009e771461e69a7eff
KERNEL=="dm-*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36006016087f048009e771461e69a7eff", NAME="asmdata23", OWNER="grid", GROUP="dba", MODE="0660"
[root@datacenter1-srv rules.d]# udevadm control --reload-rules
[root@datacenter1-srv rules.d]#  udevadm trigger --type=devices --action=change
[root@datacenter1-srv rules.d]# ls -ltr /dev/asmdata23
brw-rw---- 1 grid dba 253, 30 Aug 12 20:54 /dev/asmdata23
切换到节点2：
[root@datacenter2-srv ~]# cd /sys/class/scsi_host/
[root@datacenter2-srv scsi_host]# echo "- - -" >host0/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host1/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host10/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host11/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host12/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host13/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host14/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host15/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host16/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host2/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host3/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host4/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host5/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host6/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host7/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host8/scan
[root@datacenter2-srv scsi_host]# echo "- - -" >host9/scan
[root@datacenter2-srv scsi_host]# cd /dev/disk/by-id/
[root@datacenter2-srv by-id]# ls -ltr
[root@datacenter2-srv by-id]# multipath -ll|grep 36006016087f048009e771461e69a7eff
[root@datacenter2-srv by-id]# vi /etc/multipath.conf
multipath {
wwid                    36006016087f048009e771461e69a7eff
alias                   data23
}
[root@datacenter2-srv by-id]# service multipathd reload
Reloading multipathd:                                      [  OK  ]
[root@datacenter2-srv by-id]# multipath -ll|grep -C 3 36006016087f048009e771461e69a7eff
`-+- policy='round-robin 0' prio=10 status=enabled
|- 16:0:1:10 sdal 66:80  active ready running
`- 15:0:1:10 sdcn 69:176 active ready running
data23 (36006016087f048009e771461e69a7eff) dm-30 DGC,VRAID
size=500G features='1 retain_attached_hw_handler' hwhandler='1 alua' wp=rw
|-+- policy='round-robin 0' prio=50 status=active
| |- 15:0:1:28 sddk 71:32  active ready running
[root@datacenter2-srv by-id]# cd /etc/udev/rules.d/
[root@datacenter2-srv rules.d]# cp 99-oracle-asmdevices.rules 99-oracle-asmdevices.rules.20210812
[root@datacenter2-srv rules.d]# vi 99-oracle-asmdevices.rules
[root@datacenter2-srv rules.d]# cat 99-oracle-asmdevices.rules |grep 36006016087f048009e771461e69a7eff
KERNEL=="dm-*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36006016087f048009e771461e69a7eff", NAME="asmdata23", OWNER="grid", GROUP="dba", MODE="0660"
[root@datacenter2-srv rules.d]# udevadm control --reload-rules
udevadm trigger --type=devices --action=change[root@datacenter2-srv rules.d]#  udevadm trigger --type=devices --action=change
[root@datacenter2-srv rules.d]# ls -ltr /dev/asmdata23
brw-rw----. 1 grid dba 253, 30 Aug 12 20:55 /dev/asmdata23
切回到节点1：
[root@datacenter1-srv rules.d]# su - grid
[grid@datacenter1-srv ~]$ sqlplus / as sysasm
SQL> col name for a20
SQL> col path for a30
SQL> select name,path,OS_MB,total_mb,free_mb from v$asm_disk;  --可以看到asmdata23扫出来了，但是没名字
NAME		     PATH				 OS_MB	 TOTAL_MB    FREE_MB
-------------------- ------------------------------ ---------- ---------- ----------
		/dev/asmdata23			512000		0	   0
DATA_0014	     /dev/asmdata15			204800	   204800      11416
DATA_0010	     /dev/asmdata11			204800	   204800      11415
DATA_0018	     /dev/asmdata19			409600	   409600      22836
DATA_0019	     /dev/asmdata20			409600	   409600      22836
DATA_0013	     /dev/asmdata14			204800	   204800      11405
DATA_0016	     /dev/asmdata17			204800	   204800      11415
DATA_0012	     /dev/asmdata13			204800	   204800      11426
DATA_0015	     /dev/asmdata16			204800	   204800      11409
DATA_0017	     /dev/asmdata18			204800	   204800      11415
ARCH_0001	     /dev/asmarch02			204800	   204800     204086
DATA_0002	     /dev/asmdata03			204800	   204800      11409
DATA_0000	     /dev/asmdata01			204800	   204800      11416
DATA_0003	     /dev/asmdata04			204800	   204800      11404
DATA_0005	     /dev/asmdata06			204800	   204800      11413
DATA_0008	     /dev/asmdata09			204800	   204800      11412
DATA_0009	     /dev/asmdata10			204800	   204800      11409
DATA_0006	     /dev/asmdata07			204800	   204800      11421
DATA_0007	     /dev/asmdata08			204800	   204800      11427
ARCH_0002	     /dev/asmarch03			204800	   204800     204089
ARCH_0000	     /dev/asmarch01			204800	   204800     204085
DATA_0011	     /dev/asmdata12			204800	   204800      11413
DATA_0004	     /dev/asmdata05			204800	   204800      11404
OCR_0000	     /dev/asmocr1			  1024	     1024	 716
DATA_0001	     /dev/asmdata02			204800	   204800      11416
OCR_0002	     /dev/asmocr3			  1024	     1024	 715
OCR_0001	     /dev/asmocr2			  1024	     1024	 715
DATA_0021	     /dev/asmdata22			409600	   409600      23817
DATA_0020	     /dev/asmdata21			409600	   409600      23817
SQL> alter diskgroup DATA add disk '/dev/asmdata23' rebalance power 8;  --rebalance
Diskgroup altered.
SQL> select * from V$ASM_OPERATION; --等这个查不出结果了就代表结束了
GROUP_NUMBER OPERATION	     STATE	       POWER	 ACTUAL      SOFAR   EST_WORK	EST_RATE EST_MINUTES ERROR_CODE
------------ --------------- ------------ ---------- ---------- ---------- ---------- ---------- ----------- ------------------------------------------------------------------------------------------------------------------------------------
	2 REBAL	     RUN		   8	      8 	 3     440853	     180	2449
然后切到节点2，看asm的空间
SQL> @asm_diskgroups
+------------------------------------------------------------------------+
| Report   : ASM Disk Groups						 |
| Instance : edw2							 |
+------------------------------------------------------------------------+
Disk Group		   Sector   Block   Allocation
Name			     Size    Size    Unit Size State	   Type   COMPATIBILI DATABASE_CO Total Size (MB) USABLE_FILE_MB Used Size (MB) Pct. Used
------------------------- ------- ------- ------------ ----------- ------ ----------- ----------- --------------- -------------- -------------- ---------
ARCH			      512   4,096    1,048,576 CONNECTED   EXTERN 11.2.0.0.0  10.1.0.0.0	  614,400	  612260	  2,140       .35
DATA			      512   4,096    1,048,576 CONNECTED   EXTERN 11.2.0.0.0  10.1.0.0.0	5,836,800	  810745      5,026,055     86.11
OCR			      512   4,096    1,048,576 MOUNTED	   NORMAL 11.2.0.0.0  10.1.0.0.0	    3,072	     561	    926     30.14
编辑推荐：

返回列表
Oracle 11g rac asm磁盘扩容

编辑推荐：

相关推荐

excel表格怎样在数字前输入0

excel表格里怎么替换数据

excel表格里面如何插入圆形

excel表格里怎么添加表格数据透视表

excel表格中怎么添加线边框

excel表格里怎样设置条件自动排序

excel表格例怎样导入数据库

Excel表格如何设置数据排序

excel表格里怎么选择性粘贴快捷键

excel表格怎么插入分隔符号

excel表格怎么设置多行多列数据内容排序

Excel表格如何设置行和列相互转换

excel表格连接公式怎么使用

excel表格怎样链接到cad中

雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效

制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用

最新软件资讯

热文推荐

天极热推
