LINUX 11G RAC ASM磁盘组在线增加磁盘扩容Word文档格式.docx
《LINUX 11G RAC ASM磁盘组在线增加磁盘扩容Word文档格式.docx》由会员分享，可在线阅读，更多相关《LINUX 11G RAC ASM磁盘组在线增加磁盘扩容Word文档格式.docx（5页珍藏版）》请在冰豆网上搜索。
Disk/dev/sda:
128.8GB,128849018880bytes
/dev/sda1
*
1
14
103424
83
Linux
/dev/sda2
4191
33554432
82
Linuxswap/Solaris
/dev/sda3
15666
92170240
8e
LinuxLVM
Disk/dev/sdb:
2147MB,2147483648bytes
/dev/sdb1
261
2096451
Disk/dev/sdc:
/dev/sdc1
Disk/dev/sdd:
/dev/sdd1
Disk/dev/sde:
536.9GB,536870912000bytes
/dev/sde1
65270
524281243+
Disk/dev/sdf:
/dev/sdf1
Disk/dev/sdg:
/dev/sdg1
Disk/dev/sdh:
214.7GB,214748364800bytes
Disk/dev/sdi:
107.4GB,107374182400bytes
5.当前系统硬盘为sda到sdi,现在需要增加一块500G的共享硬盘，来扩容ASM磁盘组,增加新硬盘后系统识别应为sdj
查看伪文件系统下的/proc/scsi/scsi文件有scsi1,scsi2，scsi3三个通道
[root@cqltjcpt1~]#more/proc/scsi/scsi
Attacheddevices:
Host:
scsi1Channel:
00Id:
00Lun:
00
Vendor:
NECVMWarModel:
VMwareIDECDR10Rev:
1.00
Type:
CD-ROM
ANSI
SCSIrevision:
05
scsi2Channel:
VMware
Model:
Virtualdisk
Rev:
1.0
Direct-Access
02
scsi3Channel:
01Lun:
02Lun:
03Lun:
04Lun:
05Lun:
06Lun:
08Lun:
6.在节点1,2执行echo命令，
[root@cqltjcpt1~]#echo"
---"
>
/sys/class/scsi_host/host3/scan
当前的最大ID号为08，执行完echo命令后，系统的/proc/scsi/scsi文件下会出现ID为09的标识号
如下：
09Lun:
7.分别在节点1,2查看/proc/scsi/scsi文件，此时节点1,2已识别到Host:
|grep
09
[root@cqltjcpt2~]#more/proc/scsi/scsi
8.在节点1上对sdj分区
[root@cqltjcpt1~]#fdisk/dev/sdj
[root@cqltjcpt1~]#partprobe
9.节点1,2查看sdj1分区，以后成功识别
[root@cqltjcpt1~]#fdisk-l
sdj
Disk/dev/sdj:
/dev/sdj1
[root@cqltjcpt2~]#fdisk-l
10.节点1上用grid用户登录，查看当前ASM磁盘组
[root@cqltjcpt1~]#su-grid
查看asm磁盘组
[grid@cqltjcpt1~]$sqlplus/assysasm
selectgroup_number,name,TOTAL_MB,FREE_MBfromv$asm_diskgroup
GROUP_NUMBERNAME
TOTAL_MB
FREE_MB
-------------------------------------------------
1CQDATA
1547972
525323
2FRA
511993
477058
3OCR
6141
5741
11.查看asm磁盘
[root@cqltjcpt1~]#oracleasmlistdisks
DATA1
DATA2
FRA
OCR_VOT1
OCR_VOT2
OCR_VOT3
12.现在是要将500G的磁盘扩容到CQDATA的ASM的磁盘组中去
首先需要创建新的ASM磁盘
节点1上执行
[root@cqltjcpt1~]#oracleasmcreatediskDATA3/dev/sdj1
[root@cqltjcpt1~]#oracleasmscandisks
[root@cqltjcpt1~]#oracleasm
listdisks
DATA3
节点2上执行
[root@cqltjcpt2~]#oracleasm
scandisks
Reloadingdiskpartitions:
done
CleaninganystaleASMdisks...
ScanningsystemforASMdisks...
[root@cqltjcpt2~]#oracleasm
此时，节点1,2都已经识别到新的ASM磁盘DATA3
13.节点1执行，查看ASM磁盘，确定PATH
[root@cqltjcpt1~]#su-grid
[grid@cqltjcpt1~]$sqlplus
/assysasm
selectname,path,mode_status,state,disk_number,failgroupfromv$asm_disk;
NAME
PATH
MODE_STATUS
STATE
DISK_NUMBERFAILGROUP
--------
----------------------------------------------------------------
ORCL:
ONLINE
NORMAL
0DATA1
1DATA2
2DATA3
0FRA
0OCR_VOT1
1OCR_VOT2
14.在节点1上，grid用户已sysasm登录ASM实例，给CQDATA磁盘组增加新的ASM磁盘DATA3
alterdiskgroupCQDATA
adddisk
'
ORCL:
DATA3'
rebalancepower10;
GROUP_NUMBEROPERATION
POWER
ACTUAL
SOFAR
EST_WORK
EST_RATEEST_MINUTESERROR_CODE
-----------------------------------------------------------------------------------------------------
1REBAL
RUN
130396
340324
1224
171
查看当前reblance时间，500G需要1小时左右
select*fromv$asm_opration；
-------------------------------------------------------------------------------------------------------------------------
13327
332978
1242
57
15.当查询v$asm_operation时无数据输出时，意味着ASM的reblance动作结束
select*fromv$asm_operation;
norowsselected
修改reblance参数为默认
ALTERDISKGROUPDATA1REBALANCEPOWER1;
16.在节点1,2上分别查询，以下结果
SELECT,NAME,FREE_MB,TOTAL_MBFROMV$ASM_DISKGROUP
----------------------------------------
CQDATA
1025323
2047972
OCR
CQDATA磁盘组已经成功完成扩容
升级会员 