11g R2替换OCR盘:
检查OCR盘信息:
[root@s2-11g grid]# ocrcheck -config
Oracle Cluster Registry configuration is :
Device/File Name : +OCRVOT
[root@s2-11g grid]# more /etc/oracle/ocr.loc
ocrconfig_loc=+OCRVOT
local_only=FALSE
新添加替换的OCR磁盘组:
[root@s2-11g grid]# ocrconfig -add +NOCRVOTE
检查添加的磁盘组:
[root@s2-11g grid]# ocrcheck -config
Oracle Cluster Registry configuration is :
Device/File Name : +OCRVOT
Device/File Name : +NOCRVOTE
[root@s2-11g grid]#
[root@s2-11g grid]#
[root@s2-11g grid]# more /etc/oracle/ocr.loc
#Device/file getting replaced by device +NOCRVOTE
ocrconfig_loc=+OCRVOT
ocrmirrorconfig_loc=+NOCRVOTE
local_only=false
删除原先磁盘组:
[root@s2-11g grid]# ocrconfig -delete +OCRVOT
[root@s2-11g grid]# more /etc/oracle/ocr.loc
#Device/file +OCRVOT getting replaced by device +NOCRVOTE
ocrconfig_loc=+NOCRVOTE
local_only=false
[root@s2-11g grid]# crs_stat -t
Name Type Target State Host
————————————————————
ora.DATA.dg ora….up.type ONLINE ONLINE s1-11g
ora….ER.lsnr ora….er.type ONLINE ONLINE s1-11g
ora….N1.lsnr ora….er.type ONLINE ONLINE s2-11g
ora….VOTE.dg ora….up.type ONLINE ONLINE s1-11g
ora.OCRVOT.dg ora….up.type ONLINE ONLINE s1-11g
ora.RECOVER.dg ora….up.type ONLINE ONLINE s1-11g
ora.asm ora.asm.type ONLINE ONLINE s1-11g
ora.cvu ora.cvu.type ONLINE ONLINE s2-11g
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora.hzmc.db ora….se.type ONLINE ONLINE s1-11g
ora….network ora….rk.type ONLINE ONLINE s1-11g
ora.oc4j ora.oc4j.type ONLINE ONLINE s2-11g
ora.ons ora.ons.type ONLINE ONLINE s1-11g
ora….SM1.asm application ONLINE ONLINE s1-11g
ora….1G.lsnr application ONLINE ONLINE s1-11g
ora.s1-11g.gsd application OFFLINE OFFLINE
ora.s1-11g.ons application ONLINE ONLINE s1-11g
ora.s1-11g.vip ora….t1.type ONLINE ONLINE s1-11g
ora….SM2.asm application ONLINE ONLINE s2-11g
ora….1G.lsnr application ONLINE ONLINE s2-11g
ora.s2-11g.gsd application OFFLINE OFFLINE
ora.s2-11g.ons application ONLINE ONLINE s2-11g
ora.s2-11g.vip ora….t1.type ONLINE ONLINE s2-11g
ora.scan1.vip ora….ip.type ONLINE ONLINE s2-11g
至此,OCR磁盘组替换完毕
11gR2 RAC vote盘替换
该操作时基于上篇OCR盘替换
首先介绍几篇metalink上关于OCRVOTE盘管理文章:
OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE) [ID 428681.1]:
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=203300063075942&type=DOCUMENT&id=428681.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=5olv7tfs7_71
增加和删除voting disk的命令在11gR2中不在被使用,所以我们在增减删除vote盘会报一下错误:
CRS-4258: Addition and deletion of voting files are not allowed because the voting files are on ASM
11g中提供replace命令: crsctl replace votedisk +XXXX
以下描述在基于OCR盘已经替换完毕的情况下替换vote盘:
[root@s2-11g grid]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
– —– —————– ——— ———
1. ONLINE 856223a123894f6bbf2a5ed3081609ae (/dev/asm-ocr_vote) [OCRVOT]
Located 1 voting disk(s).
[root@s2-11g grid]# crsctl replace votedisk +NOCRVOTE
Successful addition of voting disk 80eabd79d1864f1cbf957583c40476d7.
Successful deletion of voting disk 856223a123894f6bbf2a5ed3081609ae.
Successfully replaced voting disk group with +NOCRVOTE.
CRS-4266: Voting file(s) successfully replaced
[root@s2-11g grid]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
– —– —————– ——— ———
1. ONLINE 80eabd79d1864f1cbf957583c40476d7 (/dev/asm-nocr_vote) [NOCRVOTE]
Located 1 voting disk(s).
[root@s2-11g grid]#
替换结束后还需要修改ASM的参数文件路径:
[grid@s1-11g ~]$ sqlplus "/ as sysasm"
SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 18 10:37:14 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter str
NAME TYPE VALUE
———————————— ———– ——————————
asm_diskstring string /dev/asm*
可以看到asm_diskstring的路径为/dev/asm* 如果你新加的盘的路径不是这样,那么就需要修改该路径
SQL> show parameter spfile
NAME TYPE VALUE
———————————— ———– ——————————
spfile string +OCRVOT/s1-11g-cluster/asmpara
meterfile/registry.253.7942469
99
以上显示ASM的spfile指向的任然是老的OCRVOTE盘
SQL> create pfile='/home/grid/init.ora' from spfile;
File created.
create spfile='+NOCRVOTE' from pfile='/home/grid/init.ora'
File created.
重启双节点的HAS进程 由于spfile存储在共享存储上,只需要在一节点修改,其余节点都可以认
------------------------------------------------------------------------------------
原博客地址:http://blog.itpub.net/23732248/
原作者:应以峰 (frank-ying)
-------------------------------------------------------------------------------------
检查OCR盘信息:
[root@s2-11g grid]# ocrcheck -config
Oracle Cluster Registry configuration is :
Device/File Name : +OCRVOT
[root@s2-11g grid]# more /etc/oracle/ocr.loc
ocrconfig_loc=+OCRVOT
local_only=FALSE
新添加替换的OCR磁盘组:
[root@s2-11g grid]# ocrconfig -add +NOCRVOTE
检查添加的磁盘组:
[root@s2-11g grid]# ocrcheck -config
Oracle Cluster Registry configuration is :
Device/File Name : +OCRVOT
Device/File Name : +NOCRVOTE
[root@s2-11g grid]#
[root@s2-11g grid]#
[root@s2-11g grid]# more /etc/oracle/ocr.loc
#Device/file getting replaced by device +NOCRVOTE
ocrconfig_loc=+OCRVOT
ocrmirrorconfig_loc=+NOCRVOTE
local_only=false
删除原先磁盘组:
[root@s2-11g grid]# ocrconfig -delete +OCRVOT
[root@s2-11g grid]# more /etc/oracle/ocr.loc
#Device/file +OCRVOT getting replaced by device +NOCRVOTE
ocrconfig_loc=+NOCRVOTE
local_only=false
[root@s2-11g grid]# crs_stat -t
Name Type Target State Host
————————————————————
ora.DATA.dg ora….up.type ONLINE ONLINE s1-11g
ora….ER.lsnr ora….er.type ONLINE ONLINE s1-11g
ora….N1.lsnr ora….er.type ONLINE ONLINE s2-11g
ora….VOTE.dg ora….up.type ONLINE ONLINE s1-11g
ora.OCRVOT.dg ora….up.type ONLINE ONLINE s1-11g
ora.RECOVER.dg ora….up.type ONLINE ONLINE s1-11g
ora.asm ora.asm.type ONLINE ONLINE s1-11g
ora.cvu ora.cvu.type ONLINE ONLINE s2-11g
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora.hzmc.db ora….se.type ONLINE ONLINE s1-11g
ora….network ora….rk.type ONLINE ONLINE s1-11g
ora.oc4j ora.oc4j.type ONLINE ONLINE s2-11g
ora.ons ora.ons.type ONLINE ONLINE s1-11g
ora….SM1.asm application ONLINE ONLINE s1-11g
ora….1G.lsnr application ONLINE ONLINE s1-11g
ora.s1-11g.gsd application OFFLINE OFFLINE
ora.s1-11g.ons application ONLINE ONLINE s1-11g
ora.s1-11g.vip ora….t1.type ONLINE ONLINE s1-11g
ora….SM2.asm application ONLINE ONLINE s2-11g
ora….1G.lsnr application ONLINE ONLINE s2-11g
ora.s2-11g.gsd application OFFLINE OFFLINE
ora.s2-11g.ons application ONLINE ONLINE s2-11g
ora.s2-11g.vip ora….t1.type ONLINE ONLINE s2-11g
ora.scan1.vip ora….ip.type ONLINE ONLINE s2-11g
至此,OCR磁盘组替换完毕
11gR2 RAC vote盘替换
该操作时基于上篇OCR盘替换
首先介绍几篇metalink上关于OCRVOTE盘管理文章:
OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE) [ID 428681.1]:
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=203300063075942&type=DOCUMENT&id=428681.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=5olv7tfs7_71
增加和删除voting disk的命令在11gR2中不在被使用,所以我们在增减删除vote盘会报一下错误:
CRS-4258: Addition and deletion of voting files are not allowed because the voting files are on ASM
11g中提供replace命令: crsctl replace votedisk +XXXX
以下描述在基于OCR盘已经替换完毕的情况下替换vote盘:
[root@s2-11g grid]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
– —– —————– ——— ———
1. ONLINE 856223a123894f6bbf2a5ed3081609ae (/dev/asm-ocr_vote) [OCRVOT]
Located 1 voting disk(s).
[root@s2-11g grid]# crsctl replace votedisk +NOCRVOTE
Successful addition of voting disk 80eabd79d1864f1cbf957583c40476d7.
Successful deletion of voting disk 856223a123894f6bbf2a5ed3081609ae.
Successfully replaced voting disk group with +NOCRVOTE.
CRS-4266: Voting file(s) successfully replaced
[root@s2-11g grid]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
– —– —————– ——— ———
1. ONLINE 80eabd79d1864f1cbf957583c40476d7 (/dev/asm-nocr_vote) [NOCRVOTE]
Located 1 voting disk(s).
[root@s2-11g grid]#
替换结束后还需要修改ASM的参数文件路径:
[grid@s1-11g ~]$ sqlplus "/ as sysasm"
SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 18 10:37:14 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter str
NAME TYPE VALUE
———————————— ———– ——————————
asm_diskstring string /dev/asm*
可以看到asm_diskstring的路径为/dev/asm* 如果你新加的盘的路径不是这样,那么就需要修改该路径
SQL> show parameter spfile
NAME TYPE VALUE
———————————— ———– ——————————
spfile string +OCRVOT/s1-11g-cluster/asmpara
meterfile/registry.253.7942469
99
以上显示ASM的spfile指向的任然是老的OCRVOTE盘
SQL> create pfile='/home/grid/init.ora' from spfile;
File created.
create spfile='+NOCRVOTE' from pfile='/home/grid/init.ora'
File created.
重启双节点的HAS进程 由于spfile存储在共享存储上,只需要在一节点修改,其余节点都可以认
------------------------------------------------------------------------------------
原博客地址:http://blog.itpub.net/23732248/
原作者:应以峰 (frank-ying)
-------------------------------------------------------------------------------------
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23732248/viewspace-1455587/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23732248/viewspace-1455587/