ORACLE使用 DBCA 重建ASM磁盘组的相关问题总结

文章参考： http://www.linuxidc.com/Linux/2013-12/93454.htm
ORACLE 10G使用DBCA重建ASM报如下错误：

解决办法：
重新建立ASM磁盘组的完整过程
1.停止实例
[oracle@rac1 ~]$ srvctl stop  asm -n rac1
[oracle@rac1 ~]$ srvctl stop  asm -n rac2

2.删除服务

[oracle@rac1 ~]$ srvctl remove asm -n rac1
[oracle@rac1 ~]$ srvctl remove asm -n rac2

3.删除配置文件(两个节点都做)

$ cd /u01/app/oracle/db_1/dbs/
$ ls
init+ASM1.ora  initdw.ora  init.ora  orapw+ASM1
$ rm -rf *ASM*

$ pwd
/u01/app/oracle/admin
$ ls
+ASM
$ rm -rf *ASM

4.删除/etc/oratab 实例信息(两个节点都要做)
$ grep -v "^#" /etc/oratab |grep -v "^$"
+ASM1:/u01/app/oracle/db_1:N                                     #删除这条信息

补充：
在执行 srvctl remove asm -n node 时如果遭遇如下错误错误提示：

[oracle@rac1 dbs]$ srvctl remove asm -n rac1 PRKS-1033 : Failed to remove configuration for ASM instance "+ASM1" on node "rac1" from cluster registry, [PRKS-1023 : Failed to remove CRS resource for ASM instance "+ASM1" on node "rac1", [CRS-0214: Could not unregister resource 'ora.rac1.ASM1.asm'.]] [PRKS-1023 : Failed to remove CRS resource for ASM instance "+ASM1" on node "rac1", [CRS-0214: Could not unregister resource 'ora.rac1.ASM1.asm'.]]

查看当前crs状态信息：

[oracle@rac1 dbs]$ crs_stat -t -v Name           Type           R/RA   F/FT   Target    State     Host ---------------------------------------------------------------------- ora....SM1.asm application    0/5    0/0    ONLINE    UNKNOWN   rac1 ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1 ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1 ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1 ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1 ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2 ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2 ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2 ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2

解决办法：
在节点rac1上执行 /etc/init.d/init.crs stop (root用户执行)

[root@rac1 ~]# /etc/init.d/init.crs stop Shutting down Oracle Cluster Ready Services (CRS): Stopping resources. Successfully stopped CRS resources Stopping CSSD. Shutting down CSS daemon. Shutdown request successfully issued. Shutdown has begun. The daemons should exit soon.

在节点rac2上执行删除操作  srvctl remove asm -n rac1 -f

[oracle@rac2 ~]$ srvctl remove asm -n rac1 -f [oracle@rac2 ~]$ crs_stat -t -v                                     --查看状态 Name           Type           R/RA   F/FT   Target    State     Host ---------------------------------------------------------------------- ora....C1.lsnr application    0/5    0/0    ONLINE    OFFLINE ora.rac1.gsd   application    0/5    0/0    ONLINE    OFFLINE ora.rac1.ons   application    0/3    0/0    ONLINE    OFFLINE ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac2         --节点rac1的 vip 移到了节点rac2上面 ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2 ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2 ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2 ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2

启动rac1节点的crs服务：

[root@rac1 ~]# /etc/init.d/init.crs start Startup will be queued to init within 90 seconds. [root@rac1 ~]# su - oracle [oracle@rac1 ~]$  crsctl check crs CSS appears healthy CRS appears healthy EVM appears healthy [oracle@rac1 ~]$ crs_stat -t -v Name           Type           R/RA   F/FT   Target    State     Host ---------------------------------------------------------------------- ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    rac1 ora.rac1.gsd   application    0/5    0/0    ONLINE    ONLINE    rac1 ora.rac1.ons   application    0/3    0/0    ONLINE    ONLINE    rac1 ora.rac1.vip   application    0/0    0/0    ONLINE    ONLINE    rac1               --落叶归根，rac1的vip又回到了该节点上 ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    rac2 ora.rac2.gsd   application    0/5    0/0    ONLINE    ONLINE    rac2 ora.rac2.ons   application    0/3    0/0    ONLINE    ONLINE    rac2 ora.rac2.vip   application    0/0    0/0    ONLINE    ONLINE    rac2

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29634949/viewspace-1249204/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29634949/viewspace-1249204/