OracleRac11.2.0.3迁移OCR和VOTEDISK
来源:互联网 发布:淘宝客推爆款 编辑:程序博客网 时间:2024/05/21 12:44
环境: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;
迁移描述:今天在装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;
0 0
- OracleRac11.2.0.3迁移OCR和VOTEDISK
- 迁移11g Rac中OCR和VOTEDISK
- Oracle Rac 11.2.0.3迁移OCR和VOTEDISK
- 迁移11g Rac中OCR和VOTEDISK
- 迁移11g Rac中OCR和VOTEDISK
- OCR,VOTEDISK各种测试之一OCR,VOTEDISK的迁移
- 关于迁移 rac中ocr votedisk
- RAC votedisk和OCR还原
- RAC OCR和Votedisk文件损坏恢复
- 11.2.0.3 RAC 恢复OCR和Votedisk
- Oracle RAC 重建OCR和Votedisk
- 11gr2rac替换ocr和votedisk
- OCR和votedisk备份与还原
- 管理OCR与VoteDisk
- 如何恢复损坏的表决磁盘(votedisk)和OCR
- Oracle 10g下ocr和votedisk的管理
- 11.2 RAC环境OCR和Votedisk损坏丢失恢复
- 11Gr2RAC使用备份恢复ocr和votedisk
- hive sequencefile 和rcfile 效率对比
- 线程之间的通信、加锁解锁
- Jenkins系列之—04 email-ext邮件通知模板
- 邮箱格式
- gitlab的用户使用手册
- OracleRac11.2.0.3迁移OCR和VOTEDISK
- linux下解压命令大全
- string转integer
- Gentoo网络管理方法
- 阿里CEO张勇致股东信:对阿里和中国有信心
- Qt5版本的例子去哪儿了?
- perl
- Gentoo双网卡同时启用上内外网
- 马云:阿里是水电和土地之后的第四大基础设施 苹果树与苹果