10gRAC在安装了DB的情况下重建CRS
来源:互联网 发布:淘宝修改发货地 编辑:程序博客网 时间:2024/05/17 07:34
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恢复正常。
0 0
- 10gRAC在安装了DB的情况下重建CRS
- hpunix下11gRac的安装
- 10g,11gRAC CRS集群
- Pear-DB在CentOS下的安装
- 11GRAC CRS启动失败
- 如何在安装了VS2010的情况下安装SQL Server 2008
- 关于10grac 11grac 修改hostname的问题
- 如何在dsp文件丢失的情况下重建MFC工程?
- Oracle 重建控制文件(在丢失控制文件的情况下,如何恢复数据库)
- *项目HPUNIX+SERVICEGUARD+10GRAC安装
- oracle 10gRAC安装---oracle RAC
- Oracle10g下手工重建CRS和RAC数据库
- 在忍无可忍的情况下,我终于抛弃了remoting
- Div在设置了浮动的情况下水平居中
- 有备份的情况下重建ocr磁盘
- 【简单的案例分享,停机10分钟】10204升级CRS&DB的PSU至102044
- 11gR2重建crs
- VMWARE虚拟机在迁移10gRAC VOTEDISK时出现问题,从网上搜的解决方法
- C++ String类的实现
- 隐藏NGINX banner 和版本号
- EAGLE 输出gerber
- myeclipse复制粘贴快捷键不可用的解决办法
- webveiw加载html
- 10gRAC在安装了DB的情况下重建CRS
- android中如何更新adt
- 【Objective-C】06-点语法
- C++ 异常 与 ”为什么析构函数不能抛出异常“ 问题
- hello moto!
- (libgdx小结)TTF字库的使用(优美字体的绘制)
- 转载:linux 块驱动学习(-)
- SpingAOP案例(一)注解(Annotation)方式
- 如何在网页中屏蔽右键