LINUX 11G RAC ASM磁盤組在線增加磁盤擴(kuò)容課件

1、LINUX 11G RAC ASM磁盤組在線增加磁盤擴(kuò)容1.操作系統(tǒng)版本 OEL 6.1rootcqltjcpt1 # more /etc/redhat-releaseRed Hat Enterprise Linux Server release 6.1 (Santiago)2.數(shù)據(jù)庫版本 oracle 11g racSQL select * from v$version;BANNER-Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - P

2、roductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 - Production3.存儲(chǔ)環(huán)境VMWARE exsi5.0虛擬EMC存儲(chǔ)4.在節(jié)點(diǎn)1，2上查看所有系統(tǒng)磁盤rootcqltjcpt1 # fdisk -l | grep sd*Disk /dev/sda: 128.8 GB, 128849018880 bytes/dev/sda1 * 1 14 103424 83 Linux/dev/sda2 14 4191 33554432

3、82 Linux swap / Solaris/dev/sda3 4191 15666 92170240 8e Linux LVMDisk /dev/sdb: 2147 MB, 2147483648 bytes/dev/sdb1 1 261 2096451 83 LinuxDisk /dev/sdc: 2147 MB, 2147483648 bytes/dev/sdc1 1 261 2096451 83 LinuxDisk /dev/sdd: 2147 MB, 2147483648 bytes/dev/sdd1 1 261 2096451 83 LinuxDisk /dev/sde: 536.

4、9 GB, 536870912000 bytes/dev/sde1 1 65270 524281243+ 83 LinuxDisk /dev/sdf: 536.9 GB, 536870912000 bytes/dev/sdf1 1 65270 524281243+ 83 LinuxDisk /dev/sdg: 536.9 GB, 536870912000 bytes/dev/sdg1 1 65270 524281243+ 83 LinuxDisk /dev/sdh: 214.7 GB, 214748364800 bytesDisk /dev/sdi: 107.4 GB, 10737418240

5、0 bytes5.當(dāng)前系統(tǒng)硬盤為sda到sdi,現(xiàn)在需要增加一塊500G的共享硬盤，來擴(kuò)容ASM磁盤組,增加新硬盤后系統(tǒng)識(shí)別應(yīng)為sdj查看偽文件系統(tǒng)下的/proc/scsi/scsi文件有scsi1,scsi2，scsi3 三個(gè)通道rootcqltjcpt1 # more /proc/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: 05Host:

6、scsi2 Channel: 00 Id: 00 Lun: 00 Vendor: VMware Model: Virtual disk Rev: 1.0 Type: Direct-Access ANSI SCSI revision: 02Host: scsi3 Channel: 00 Id: 00 Lun: 00 Vendor: VMware Model: Virtual disk Rev: 1.0 Type: Direct-Access ANSI SCSI revision: 02Host: scsi3 Channel: 00 Id: 01 Lun: 00 Vendor: VMware Mo

7、del: Virtual disk Rev: 1.0 Type: Direct-Access ANSI SCSI revision: 02Host: scsi3 Channel: 00 Id: 02 Lun: 00 Vendor: VMware Model: Virtual disk Rev: 1.0 Type: Direct-Access ANSI SCSI revision: 02Host: scsi3 Channel: 00 Id: 03 Lun: 00 Vendor: VMware Model: Virtual disk Rev: 1.0 Type: Direct-Access ANS

8、I SCSI revision: 02Host: scsi3 Channel: 00 Id: 04 Lun: 00 Vendor: VMware Model: Virtual disk Rev: 1.0 Type: Direct-Access ANSI SCSI revision: 02Host: scsi3 Channel: 00 Id: 05 Lun: 00 Vendor: VMware Model: Virtual disk Rev: 1.0 Type: Direct-Access ANSI SCSI revision: 02Host: scsi3 Channel: 00 Id: 06

9、Lun: 00 Vendor: VMware Model: Virtual disk Rev: 1.0 Type: Direct-Access ANSI SCSI revision: 02Host: scsi3 Channel: 00 Id: 08 Lun: 00 Vendor: VMware Model: Virtual disk Rev: 1.0 Type: Direct-Access ANSI SCSI revision: 026.在節(jié)點(diǎn)1,2執(zhí)行echo 命令，rootcqltjcpt1 # echo - - - /sys/class/scsi_host/host3/scan當(dāng)前的最大

10、ID號(hào)為08，執(zhí)行完echo命令后，系統(tǒng)的/proc/scsi/scsi文件下會(huì)出現(xiàn)ID為09的標(biāo)識(shí)號(hào)如下：Host: scsi3 Channel: 00 Id: 09 Lun: 00 Vendor: VMware Model: Virtual disk Rev: 1.0 Type: Direct-Access ANSI SCSI revision: 027.分別在節(jié)點(diǎn)1,2查看/proc/scsi/scsi文件，此時(shí)節(jié)點(diǎn)1,2已識(shí)別到 Host: scsi3 Channel: 00 Id: 09 Lun: 00rootcqltjcpt1 # more /proc/scsi/scsi | gr

11、ep 09Host: scsi3 Channel: 00 Id: 09 Lun: 00rootcqltjcpt2 # more /proc/scsi/scsi | grep 09Host: scsi3 Channel: 00 Id: 09 Lun: 008.在節(jié)點(diǎn)1上對(duì)sdj分區(qū)rootcqltjcpt1 #fdisk /dev/sdjrootcqltjcpt1 #partprobe9.節(jié)點(diǎn)1,2查看sdj1分區(qū)，以后成功識(shí)別rootcqltjcpt1 # fdisk -l | grep sdjDisk /dev/sdj: 536.9 GB, 536870912000 bytes/dev/sd

12、j1 1 65270 524281243+ 83 Linuxrootcqltjcpt2 # fdisk -l | grep sdjDisk /dev/sdj: 536.9 GB, 536870912000 bytes/dev/sdj110.節(jié)點(diǎn)1上用grid用戶登錄，查看當(dāng)前ASM磁盤組rootcqltjcpt1 #su - grid查看asm磁盤組gridcqltjcpt1 $sqlplus / as sysasmSQL select group_number,name,TOTAL_MB, FREE_MB from v$asm_diskgroupGROUP_NUMBER NAME TOTAL

13、_MB FREE_MB- - - - 1 CQDATA 1547972 525323 2 FRA 511993 477058 3 OCR 6141 574111.查看asm磁盤rootcqltjcpt1 # oracleasm listdisksDATA1DATA2FRAOCR_VOT1OCR_VOT2OCR_VOT312.現(xiàn)在是要將500G的磁盤擴(kuò)容到CQDATA的ASM的磁盤組中去首先需要?jiǎng)?chuàng)建新的ASM磁盤節(jié)點(diǎn)1上執(zhí)行rootcqltjcpt1 #oracleasm createdisk DATA3 /dev/sdj1rootcqltjcpt1 #oracleasm scandisksro

14、otcqltjcpt1 #oracleasm listdisksDATA1DATA2DATA3FRAOCR_VOT1OCR_VOT2OCR_VOT3節(jié)點(diǎn)2上執(zhí)行rootcqltjcpt2 # oracleasm scandisksReloading disk partitions: doneCleaning any stale ASM disks.Scanning system for ASM disks.rootcqltjcpt2 #oracleasm listdisksDATA1DATA2DATA3FRAOCR_VOT1OCR_VOT2OCR_VOT3此時(shí)，節(jié)點(diǎn)1,2都已經(jīng)識(shí)別到新的ASM

15、磁盤DATA313.節(jié)點(diǎn)1執(zhí)行，查看ASM磁盤，確定PATHrootcqltjcpt1 # su - gridgridcqltjcpt1 $ sqlplus / as sysasmSQL select name, path, mode_status, state, disk_number,failgroup from v$asm_disk;NAME PATH MODE_STATUS STATE DISK_NUMBER FAILGROUP- - - - - -DATA1 ORCL:DATA1 ONLINE NORMAL 0 DATA1DATA2 ORCL:DATA2 ONLINE NORMAL

16、1 DATA2DATA3 ORCL:DATA3 ONLINE NORMAL 2 DATA3FRA ORCL:FRA ONLINE NORMAL 0 FRAOCR_VOT1 ORCL:OCR_VOT1 ONLINE NORMAL 0 OCR_VOT1OCR_VOT2 ORCL:OCR_VOT2 ONLINE NORMAL 1 OCR_VOT214.在節(jié)點(diǎn)1上，grid用戶已sysasm登錄ASM實(shí)例，給CQDATA磁盤組增加新的ASM磁盤DATA3SQL alter diskgroup CQDATA add disk ORCL:DATA3 rebalance power 10;GROUP_NUM

17、BER OPERATION STATE POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE- - - - - - - - - - 1 REBAL RUN 1 1 130396 340324 1224 171查看當(dāng)前reblance 時(shí)間，500G 需要1小時(shí)左右SQLselect * from v$asm_opration；GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE- - - - - - - - - - 1 REBAL RUN 1 1 13327 332978 1242 5715.當(dāng)查詢v$asm_operation時(shí)無數(shù)據(jù)輸出時(shí)，意味著ASM的reblance動(dòng)作結(jié)束SQL