oracle 11.2.0.3 rac資料庫線上新增ASM儲存空間

dingzihan發表於2014-03-13
環境:oracle 11.2.0.3 RAC,linux ASM儲存,資料庫儲存空間不夠,新增ASM磁碟。整個過程不需要停叢集以及資料庫。
1、在磁碟上建分割槽
[root@RAC-1 mapper]# fdisk /dev/mapper/data15
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0x386ecaa5.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
         switch off the mode (command 'c') and change display units to
         sectors (command 'u').

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-26108, default 1): 1
Last cylinder, +cylinders or +size{K,M,G} (1-26108, default 26108): 
Using default value 26108




Command (m for help): w


2、載入已更新的塊裝置分割槽表(在rac的兩臺機器上執行)
/sbin/partprobe  /dev/mapper/data15
3、授權
chown -R oracle:oinstall  /dev/mapper/data15*
chmod -R 777 /dev/mapper/data15*


4、給磁碟組新增磁碟
su - grid
sqlplus  / as sysasm
alter diskgroup  data  add disk '/dev/mapper/data15p1';
su - grid
asmcmd
lsdg  ----可以看到磁碟組增加了200G。
5、新增完成後,進行資料庫和叢集檢查,一切正常。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22969361/viewspace-1115058/,如需轉載,請註明出處,否則將追究法律責任。

相關文章