设为首页 加入收藏

TOP

OracleRac11.2.0.3迁移OCR和VOTEDISK
2015-07-24 11:00:54 来源: 作者: 【 】 浏览:1
Tags: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;
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇OracleRAC重建OCR和Votedisk 下一篇Install Goldengate On Oracle Ra..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·Redis 分布式锁全解 (2025-12-25 17:19:51)
·SpringBoot 整合 Red (2025-12-25 17:19:48)
·MongoDB 索引 - 菜鸟 (2025-12-25 17:19:45)
·What Is Linux (2025-12-25 16:57:17)
·Linux小白必备:超全 (2025-12-25 16:57:14)