迁移11g Rac中OCR和VOTEDISK
来源:互联网 发布:java怎么计算时间差 编辑:程序博客网 时间:2024/05/16 23:56
环境:OEL+oracle rac 11.2.0.3
[root@ora2 ~]$ /u01/app/11.2.0/grid/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 : +DATA
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放在+DATA中了
然后Add a new OCR device/file:
[root @ora2 ~]/u01/app/11.2.0/grid/bin/ocrconfig -add +OCR_VOTE
[root @ora2 ~]$ /u01/app/11.2.0/grid/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 integrity check succeeded
+OCR_VOTE
Device/File integrity check succeeded
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check bypassed due to non-privileged user
(这时候ocr并不存在于+OCR_VOTE中)
迁移 ocr:
[root @ora2 ~]$/u01/app/11.2.0/grid/bin/ocrconfig -replace +DATA -replacement +OCR_VOTE
然后迁移votedisk:
[root @ora2 ~]$su - grid
[grid @ora2 ~]$crsctl replace votedisk +OCR_VOTE
查询一下votedisk的存放目录:
[grid @ora2 ~]$crsctl query css votedisk;
查询一下资源状态:
[grid @ora2 ~]$crsctl status resource -t
然后登录asm查看asmdisk的信息:
使用show parameter spfile查看路径,如果存放在+DATA中,可以重建spfile:
如下操作:
然后使用root用户重启crs即可
[root @ora2 ~]$/u01/app/11.2.0/grid/bin/crsctl stop crs
[root @ora2 ~]$/u01/app/11.2.0/grid/bin/crsctl start crs
然后再使用grid用户
切换root用户
/u01/app/11.2.0/grid/bin/ocrconfig -delete +DATA
迁移描述:将ocr和votedisk从+DATE上迁移到+OCR_VOTE上;
[root@ora2 ~]$ /u01/app/11.2.0/grid/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 : +DATA
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放在+DATA中了
然后Add a new OCR device/file:
[root @ora2 ~]/u01/app/11.2.0/grid/bin/ocrconfig -add +OCR_VOTE
[root @ora2 ~]$ /u01/app/11.2.0/grid/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 integrity check succeeded
+OCR_VOTE
Device/File integrity check succeeded
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check bypassed due to non-privileged user
(这时候ocr并不存在于+OCR_VOTE中)
迁移 ocr:
[root @ora2 ~]$/u01/app/11.2.0/grid/bin/ocrconfig -replace +DATA -replacement +OCR_VOTE
然后迁移votedisk:
[root @ora2 ~]$su - grid
[grid @ora2 ~]$crsctl replace votedisk +OCR_VOTE
查询一下votedisk的存放目录:
[grid @ora2 ~]$crsctl query css votedisk;
查询一下资源状态:
[grid @ora2 ~]$crsctl status resource -t
然后登录asm查看asmdisk的信息:
sqlplus / as sysasmSQL> select group_number,name,state,type from V$asm_diskgroup;SQL> select group_number,name,path from v$asm_disk;
使用show parameter spfile查看路径,如果存放在+DATA中,可以重建spfile:
如下操作:
SQL>create pfile='/u01/11.2.0/grid/dbs/asmpfile.ora' from spfile;SQL>create spfile='+OCR_VOTE' from pfile='/u01/11.2.0/grid/dbs/asmpfile.ora';
然后使用root用户重启crs即可
[root @ora2 ~]$/u01/app/11.2.0/grid/bin/crsctl stop crs
[root @ora2 ~]$/u01/app/11.2.0/grid/bin/crsctl start crs
然后再使用grid用户
su - gridSQL>alter diskgroup OCR_VOTE mount;
切换root用户
/u01/app/11.2.0/grid/bin/ocrconfig -delete +DATA
删除磁盘组+DATA:
SQL>alter diskgroup DATA dismount;SQL>drop diskgroup DATA including contents
--------------------------------------------------------------------------------------------
版权所有,转载请注明作者及原文链接,否则追究法律责任!
QQ: 584307876
作者: Seven
原文链接:http://blog.csdn.net/sunjiapeng/article/details/9791425
邮箱: seven_ginna@foxmail.com- 迁移11g Rac中OCR和VOTEDISK
- 迁移11g Rac中OCR和VOTEDISK
- 迁移11g Rac中OCR和VOTEDISK
- 关于迁移 rac中ocr votedisk
- Oracle Rac 11.2.0.3迁移OCR和VOTEDISK
- RAC votedisk和OCR还原
- RAC OCR和Votedisk文件损坏恢复
- 11.2.0.3 RAC 恢复OCR和Votedisk
- Oracle RAC 重建OCR和Votedisk
- OracleRac11.2.0.3迁移OCR和VOTEDISK
- Oracle 11g Rac Votedisk、OCR以及各种资源的管理
- 11.2 RAC环境OCR和Votedisk损坏丢失恢复
- oracle 12c rac ocr和votedisk管理
- Oracle RAC Study之--10gR2 RAC环境中在线添加、删除Votedisk和在线替换OCR的探讨
- Oracle RAC 迁移OCR(10g)
- Oracle 11gR2 RAC Votedisk and OCR Management
- Oracle 11gR2 RAC Votedisk and OCR Diskgroup Recovery
- 11gr2rac替换ocr和votedisk
- qt
- [tomcat]集群配置以及联合apache httpd实现负载均衡
- android UI显示java.util.LinkedHashMap.eldest()Ljava/util/Map$Entry;E
- Altium Designer 6 总线布线功能使用 如何一次布一组线!
- android权限大全
- 迁移11g Rac中OCR和VOTEDISK
- Corporate Identity poj3450
- pl sql整理
- SharePoint 2013 中使用 JavaScript Like 和Unlike list item/page/document
- C#笔记
- JNotify使用
- 使用JDK的keytool来为Tomcat配置SSL认证(二)
- Eclipse下设置github开发环境
- .NET设计模式(3):抽象工厂模式(Abstract Factory)