10gRAC在安装了DB的情况下重建CRS
10gRAC由于误操作,导致votedisk出现如下情况,以至CRS不能正常运行
[root@rach1 ~]# crsctl query css votedisk
0. 0 /dev/raw/raw2
1. 0 0
2. 0 0
由于没有相关备份,所以决定重做。而该RAC已经安装了DB,DB上已经存在数据,最后决定采用下面的方法重做。
[root@rach1 ~]# dd if=/dev/raw/raw1 of=/u01/app/oracle/voteraw1.bak
如果不放心,再执行以下命令
/etc/init.d/init.crs stop
注意:第2个节点root时可能会报错,所以需要先设置oifcfg,如下:
[root@rach2 bin]# oifcfg getif
[root@rach2 bin]# oifcfg iflist
eth0 192.168.150.0
eth1 172.168.146.0
[root@rach2 bin]# oifcfg setif -global eth0/192.168.150.0:public
[root@rach2 bin]# oifcfg setif -global eth1/172.168.146.0:cluster_interconnect
[root@rach2 bin]# oifcfg getif
eth0 192.168.150.0 global public
eth1 172.168.146.0 global cluster_interconnect
Name Type Target State Host
------------------------------------------------------------
ora.rach1.gsd application ONLINE ONLINE rach1
ora.rach1.ons application ONLINE ONLINE rach1
ora.rach1.vip application ONLINE ONLINE rach1
ora.rach2.gsd application ONLINE ONLINE rach2
ora.rach2.ons application ONLINE ONLINE rach2
ora.rach2.vip application ONLINE ONLINE rach2
[root@rach1 bin]# crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
[root@rach1 bin]# crsctl query css votedisk
0. 0 /dev/raw/raw2
located 1 votedisk(s).
[root@rach1 bin]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 524184
Used space (kbytes) : 1960
Available space (kbytes) : 522224
ID : 298999898
Device/File Name : /dev/raw/raw1
Device/File integrity check succeeded
Device/File not configured
Cluster registry integrity check succeeded
/u01/app/oracle/product/10.2.0/crs/log/rach1/racg
rach1->more ora.rach1.ons.log
rach1-> racgons add_config rach1:6200 rach2:6200
用netca添加监听
rach1->crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....H1.lsnr application ONLINE ONLINE rach1
ora.rach1.gsd application ONLINE ONLINE rach1
ora.rach1.ons application ONLINE ONLINE rach1
ora.rach1.vip application ONLINE ONLINE rach1
ora....H2.lsnr application ONLINE ONLINE rach2
ora.rach2.gsd application ONLINE ONLINE rach2
ora.rach2.ons application ONLINE ONLINE rach2
ora.rach2.vip application ONLINE ONLINE rach2
用srvctl 添加asm,db,instance
rach1-> srvctl add asm -n rach2 -i +ASM2 -o /u01/app/oracle/product/10.2.0/db_1
rach1->srvctl start asm -n rach1
rach1->srvctl start asm -n rach2
rach1->crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rach1
ora....H1.lsnr application ONLINE ONLINE rach1
ora.rach1.gsd application ONLINE ONLINE rach1
ora.rach1.ons application ONLINE ONLINE rach1
ora.rach1.vip application ONLINE ONLINE rach1
ora....SM2.asm application ONLINE ONLINE rach2
ora....H2.lsnr application ONLINE ONLINE rach2
ora.rach2.gsd application ONLINE ONLINE rach2
ora.rach2.ons application ONLINE ONLINE rach2
ora.rach2.vip application ONLINE ONLINE rach2
rach1-> srvctl add instance -d RACDB -i RACDB1 -n rach1
rach1-> srvctl add instance -d RACDB -i RACDB2 -n rach2
rach1->srvctl start database -d racdb
rach1->crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE rach1
ora....B2.inst application ONLINE ONLINE rach2
ora.RACDB.db application ONLINE ONLINE rach1
ora....SM1.asm application ONLINE ONLINE rach1
ora....H1.lsnr application ONLINE ONLINE rach1
ora.rach1.gsd application ONLINE ONLINE rach1
ora.rach1.ons application ONLINE ONLINE rach1
ora.rach1.vip application ONLINE ONLINE rach1
ora....SM2.asm application ONLINE ONLINE rach2
ora....H2.lsnr application ONLINE ONLINE rach2
ora.rach2.gsd application ONLINE ONLINE rach2
ora.rach2.ons application ONLINE ONLINE rach2
ora.rach2.vip application ONLINE ONLINE rach2
至此,RAC恢复正常。
一。说明
10gRAC由于误操作,导致votedisk出现如下情况,以至CRS不能正常运行
[root@rach1 ~]# crsctl query css votedisk
0. 0 /dev/raw/raw2
1. 0 0
2. 0 0
由于没有相关备份,所以决定重做。而该RAC已经安装了DB,DB上已经存在数据,最后决定采用下面的方法重做。
二。重做CRS
1.备份ocr和votedisk,以防万一
[root@rach1 ~]# ocrconfig -export /u01/app/oracle/ocrbak.20140307.bak[root@rach1 ~]# dd if=/dev/raw/raw1 of=/u01/app/oracle/voteraw1.bak
2.两个节点关闭CRS
crsctl stop crs如果不放心,再执行以下命令
/etc/init.d/init.crs stop
3.两个节点都运行rootdelete
[root@rach1 install]# ./rootdelete.sh4.节点1运行rootdeinstall:
[root@rach1 install]# ./rootdeinstall.sh5.两个节点先后运行root以重建CRS
[root@rach1 crs]# ./root.sh注意:第2个节点root时可能会报错,所以需要先设置oifcfg,如下:
[root@rach2 bin]# oifcfg getif
[root@rach2 bin]# oifcfg iflist
eth0 192.168.150.0
eth1 172.168.146.0
[root@rach2 bin]# oifcfg setif -global eth0/192.168.150.0:public
[root@rach2 bin]# oifcfg setif -global eth1/172.168.146.0:cluster_interconnect
[root@rach2 bin]# oifcfg getif
eth0 192.168.150.0 global public
eth1 172.168.146.0 global cluster_interconnect
6.在运行Vipca
7.检查CRS
[root@rach1 bin]# crs_stat -tName Type Target State Host
------------------------------------------------------------
ora.rach1.gsd application ONLINE ONLINE rach1
ora.rach1.ons application ONLINE ONLINE rach1
ora.rach1.vip application ONLINE ONLINE rach1
ora.rach2.gsd application ONLINE ONLINE rach2
ora.rach2.ons application ONLINE ONLINE rach2
ora.rach2.vip application ONLINE ONLINE rach2
[root@rach1 bin]# crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
[root@rach1 bin]# crsctl query css votedisk
0. 0 /dev/raw/raw2
located 1 votedisk(s).
[root@rach1 bin]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 524184
Used space (kbytes) : 1960
Available space (kbytes) : 522224
ID : 298999898
Device/File Name : /dev/raw/raw1
Device/File integrity check succeeded
Device/File not configured
Cluster registry integrity check succeeded
三。向OCR中添加应用
1.添加racgon
检查端口:
rach1->pwd/u01/app/oracle/product/10.2.0/crs/log/rach1/racg
rach1->more ora.rach1.ons.log
rach1-> racgons add_config rach1:6200 rach2:6200
2.添加或重建监听
用netca添加监听
rach1->crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....H1.lsnr application ONLINE ONLINE rach1
ora.rach1.gsd application ONLINE ONLINE rach1
ora.rach1.ons application ONLINE ONLINE rach1
ora.rach1.vip application ONLINE ONLINE rach1
ora....H2.lsnr application ONLINE ONLINE rach2
ora.rach2.gsd application ONLINE ONLINE rach2
ora.rach2.ons application ONLINE ONLINE rach2
ora.rach2.vip application ONLINE ONLINE rach2
用srvctl 添加asm,db,instance
3. 添加asm
rach1-> srvctl add asm -n rach1 -i +ASM1 -o /u01/app/oracle/product/10.2.0/db_1rach1-> srvctl add asm -n rach2 -i +ASM2 -o /u01/app/oracle/product/10.2.0/db_1
rach1->srvctl start asm -n rach1
rach1->srvctl start asm -n rach2
rach1->crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rach1
ora....H1.lsnr application ONLINE ONLINE rach1
ora.rach1.gsd application ONLINE ONLINE rach1
ora.rach1.ons application ONLINE ONLINE rach1
ora.rach1.vip application ONLINE ONLINE rach1
ora....SM2.asm application ONLINE ONLINE rach2
ora....H2.lsnr application ONLINE ONLINE rach2
ora.rach2.gsd application ONLINE ONLINE rach2
ora.rach2.ons application ONLINE ONLINE rach2
ora.rach2.vip application ONLINE ONLINE rach2
4. 添加db和相应instance
rach1-> srvctl add database -d RACDB -o /u01/app/oracle/product/10.2.0/db_1rach1-> srvctl add instance -d RACDB -i RACDB1 -n rach1
rach1-> srvctl add instance -d RACDB -i RACDB2 -n rach2
rach1->srvctl start database -d racdb
rach1->crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE rach1
ora....B2.inst application ONLINE ONLINE rach2
ora.RACDB.db application ONLINE ONLINE rach1
ora....SM1.asm application ONLINE ONLINE rach1
ora....H1.lsnr application ONLINE ONLINE rach1
ora.rach1.gsd application ONLINE ONLINE rach1
ora.rach1.ons application ONLINE ONLINE rach1
ora.rach1.vip application ONLINE ONLINE rach1
ora....SM2.asm application ONLINE ONLINE rach2
ora....H2.lsnr application ONLINE ONLINE rach2
ora.rach2.gsd application ONLINE ONLINE rach2
ora.rach2.ons application ONLINE ONLINE rach2
ora.rach2.vip application ONLINE ONLINE rach2
至此,RAC恢复正常。