OracleRac11.2.0.3迁移OCR和VOTEDISK

环境:AIX7.1+ Oracle  Rac 11.2.0.3
迁移描述:今天在装Oracle Rac的时候,错误的将500G的数据盘用作OCRDG了,遂后续比较麻烦,只能讲ocr和votedisk迁移到新建的OCRDG上,并把DATADG删除并格式化该盘。(OCRDG为normal 冗余) 操作如下: 
grid@rac1:/home/grid>/oraapp/grid/gridhome/bin/ocrcheck Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 1469612 Used space (kbytes) : 3784 Available space (kbytes) : 1465828 ID : 1820175369 Device/File Name : +DATADG Device/File integrity check succeeded Device/File not configured Device/File not configured Cluster registry integrity check succeeded Logical corruption check bypassed due to non-privileged user 添加ocr信息到+OCRDG中: root@rac1:./root>/oraapp/grid/gridhome/bin/ocrconfig -add +OCRDG 
删除+DATADG中ocr: root@rac1:./root>/oraapp/grid/gridhome/bin/ocrconfig -delete +DATADG 
然后迁移votedisk: grid@rac1:/home/grid>crsctl replace votedisk +OCRDG 查看votedisk的信息: grid@rac1:/home/grid>crsctl query css votedisk; 
查看diskgroup的信息:  sqlplus / as sysasm SQL> select group_number,name,state,type from V$asm_diskgroup; 
此时spfile存放在+DATADG中,需要重建spfile:  SQL>create pfile='/tmp/asmpfile.ora' from  spfile; SQL>create spfile='+OCRDG' from pfile='/tmp/asmpfile.ora'; 
然后使用root用户重启crs即可(两边顺序重启) 
root@rac1:./root>/oraapp/grid/gridhome/bin/crsctl stop crs root@rac1:./root>/oraapp/grid/gridhome/bin/crsctl start crs 
删除磁盘组+DATADG: 
SQL>alter diskgroup DATADG dismount; SQL>drop diskgroup DATADG including contents;
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值