Oracle更换存储磁盘,rac更换存储设备 - Oracle数据库管理 - ITPUB论坛－中国专业的IT技术社区...

本帖最后由 houyichong 于 2016-8-9 13:29 编辑

+DATA 磁盘组  可以

alter diskgroup data add disk

rebalance

alter diskgroup data drop disk

rebalance

实现，先要所有节点停止集群吗？crsctl stop crs，说是0宕机的呢，呵呵。

这是以前收录的文档，大牛们给建议。

5创建新的OCRNEW磁盘组su–gridsqlplus / as sysasm

CREATE DISKGROUP OCRNEW NORMAL REDUNDANCY

DISK 'ORCL:OCR_VOL4' NAME VOL4

DISK 'ORCL:OCR_VOL5' NAME VOL5

DISK 'ORCL:OCR_VOL6' NAME VOL6 ATTRIBUTE'compatible.asm'='11.2';

6添加OCR信息到OCRNEW[root@oracle1 bin]# ./ocrconfig -add +OCRNEW

[root@oracle1 bin]# ./ocrcheck -config

Oracle Cluster Registry configuration is :

Device/FileName         :       +OCR

Device/FileName         :    +OCRNEW

[root@oracle1 bin]# more /etc/oracle/ocr.loc

#Device/file  getting replaced by device+OCRNEW

ocrconfig_loc=+OCR

ocrmirrorconfig_loc=+OCRNEW

local_only=false

[root@oracle1 bin]#可以看到OCRNEW磁盘组已经成功添加到OCR磁盘信息中迁移vote文件当前votedisk信息[grid@oracle1 ~]$ crsctl query cssvotedisk

##  STATE    File Universal Id               File Name Disk group

--  -----    -----------------               --------- ---------

1. ONLINE  14f694d9d4414f9ebf85d3ce6b9aef0b (ORCL:OCR_VOL1) [OCR]

2. ONLINE  9f9ee7281c954f8abfcc6e88c33257ac (ORCL:OCR_VOL2) [OCR]

3. ONLINE  38114fd602194fa9bf4d05655b3d89b7 (ORCL:OCR_VOL3) [OCR]

Located 3 voting disk(s).

[grid@oracle1 ~]$ crsctl replace votedisk+OCRNEW

Successful addition of voting disk00634ef593ee4f92bf48e8c089cb5565.

Successful addition of voting disk232159722de04f67bf03a78b757e3bec.

Successful addition of voting diska340d5b23aac4f6fbf9f7b1d59088fa5.

Successful deletion of voting disk14f694d9d4414f9ebf85d3ce6b9aef0b.

Successful deletion of voting disk9f9ee7281c954f8abfcc6e88c33257ac.

Successful deletion of voting disk38114fd602194fa9bf4d05655b3d89b7.

Successfully replaced voting disk group with+OCRNEW.

CRS-4266: Voting file(s) successfully replaced

7创建ASM实例spfile到OCR_NEW创建ASM实例spfile到新创建的OCR_NEW ASM磁盘组上(在一个节点grid用户登录ASM实例执行)SQL> create pfile='/home/grid/asmpfile.ora'from spfile;

File created.

SQL> create spfile='+OCRNEW' frompfile='/home/grid/asmpfile.ora';

File created.

8删除ASM磁盘组OCR[root@oracle1 bin]# ./ocrconfig -delete +OCR查看OCR和VOTE新状态与位置[root@oracle1 bin]# ./ocrcheck &&./crsctl query css votedisk

Status of Oracle Cluster Registry is as follows:

Version                 :         3

Total space(kbytes)     :     262120

Used space(kbytes)      :       2768

Availablespace (kbytes) :     259352

ID                      :2006438789

Device/FileName         :    +OCRNEW

Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Clusterregistry integrity check succeeded

Logicalcorruption check succeeded

##  STATE    File Universal Id               File Name Disk group

--  -----    -----------------               --------- ---------

1. ONLINE   00634ef593ee4f92bf48e8c089cb5565(ORCL:OCR_VOL4) [OCRNEW]

2. ONLINE  232159722de04f67bf03a78b757e3bec (ORCL:OCR_VOL5) [OCRNEW]

3. ONLINE  a340d5b23aac4f6fbf9f7b1d59088fa5 (ORCL:OCR_VOL6) [OCRNEW]

Located 3 voting disk(s).

SYS@+ASM1> alter diskgroup OCR dismount;

Diskgroup altered.

SYS@+ASM2> drop diskgroup OCR includingcontents;