LINUX 11G RAC ASM磁盘组在线增加磁盘扩容Word文档格式.docx

1、Disk /dev/sda: 128.8 GB, 128849018880 bytes/dev/sda1 * 1 14 103424 83 Linux/dev/sda2 4191 33554432 82 Linux swap / Solaris/dev/sda3 15666 92170240 8e Linux LVMDisk /dev/sdb: 2147 MB, 2147483648 bytes/dev/sdb1 261 2096451Disk /dev/sdc:/dev/sdc1Disk /dev/sdd:/dev/sdd1Disk /dev/sde: 536.9 GB, 536870912

2、000 bytes/dev/sde1 65270 524281243+Disk /dev/sdf:/dev/sdf1Disk /dev/sdg:/dev/sdg1Disk /dev/sdh: 214.7 GB, 214748364800 bytesDisk /dev/sdi: 107.4 GB, 107374182400 bytes5.当前系统硬盘为sda到sdi,现在需要增加一块500G的共享硬盘，来扩容ASM磁盘组,增加新硬盘后系统识别应为sdj查看伪文件系统下的/proc/scsi/scsi文件有scsi1,scsi2，scsi3 三个通道rootcqltjcpt1 # more /pr

3、oc/scsi/scsiAttached devices:Host: scsi1 Channel: 00 Id: 00 Lun: 00 Vendor: NECVMWar Model: VMware IDE CDR10 Rev: 1.00 Type: CD-ROM ANSI SCSI revision: 05 scsi2 Channel: VMware Model: Virtual disk Rev: 1.0 Direct-Access 02 scsi3 Channel: 01 Lun: 02 Lun: 03 Lun: 04 Lun: 05 Lun: 06 Lun: 08 Lun:6.在节点1,

4、2执行echo 命令，rootcqltjcpt1 # echo - - - /sys/class/scsi_host/host3/scan当前的最大ID号为08，执行完echo命令后，系统的/proc/scsi/scsi文件下会出现ID为09的标识号如下： 09 Lun:7.分别在节点1,2查看/proc/scsi/scsi文件，此时节点1,2已识别到 Host: | grep 09rootcqltjcpt2 # more /proc/scsi/scsi8.在节点1上对sdj分区rootcqltjcpt1 #fdisk /dev/sdjrootcqltjcpt1 #partprobe9.节点1

5、,2查看sdj1分区，以后成功识别rootcqltjcpt1 # fdisk -l sdjDisk /dev/sdj:/dev/sdj1rootcqltjcpt2 # fdisk -l10.节点1上用grid用户登录，查看当前ASM磁盘组rootcqltjcpt1 #su - grid查看asm磁盘组gridcqltjcpt1 $sqlplus / as sysasm select group_number,name,TOTAL_MB, FREE_MB from v$asm_diskgroupGROUP_NUMBER NAME TOTAL_MB FREE_MB- - - - 1 CQDATA

6、1547972 525323 2 FRA 511993 477058 3 OCR 6141 574111.查看asm磁盘rootcqltjcpt1 # oracleasm listdisksDATA1DATA2FRAOCR_VOT1OCR_VOT2OCR_VOT312.现在是要将500G的磁盘扩容到CQDATA的ASM的磁盘组中去首先需要创建新的ASM磁盘节点1上执行rootcqltjcpt1 #oracleasm createdisk DATA3 /dev/sdj1rootcqltjcpt1 #oracleasm scandisksrootcqltjcpt1 #oracleasm listd

7、isksDATA3节点2上执行rootcqltjcpt2 # oracleasm scandisksReloading disk partitions: doneCleaning any stale ASM disks.Scanning system for ASM disks.rootcqltjcpt2 #oracleasm此时，节点1,2都已经识别到新的ASM磁盘DATA313.节点1执行，查看ASM磁盘，确定PATHrootcqltjcpt1 # su - gridgridcqltjcpt1 $ sqlplus / as sysasm select name, path, mode_st

8、atus, state, disk_number,failgroup from v$asm_disk;NAME PATH MODE_STATUS STATE DISK_NUMBER FAILGROUP- - - - - - ORCL: ONLINE NORMAL 0 DATA1 1 DATA2 2 DATA3 0 FRA 0 OCR_VOT1 1 OCR_VOT214.在节点1上，grid用户已sysasm登录ASM实例，给CQDATA磁盘组增加新的ASM磁盘DATA3 alter diskgroup CQDATA add disk ORCL:DATA3 rebalance power 10;

9、GROUP_NUMBER OPERATION POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE- - - - - - - - - - 1 REBAL RUN 130396 340324 1224 171查看当前reblance 时间，500G 需要1小时左右select * from v$asm_opration；- - - - - - - - - - 13327 332978 1242 5715.当查询v$asm_operation时无数据输出时，意味着ASM的reblance动作结束 select * from v$asm_operation;no rows selected修改reblance 参数为默认 ALTER DISKGROUP DATA1 REBALANCE POWER 1;16.在节点1,2上分别查询，以下结果 SELECT,NAME,FREE_MB,TOTAL_MB FROM V$ASM_DISKGROUP- - -CQDATA 1025323 2047972OCRCQDATA磁盘组已经成功完成扩容