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

最新推荐文章于 2024-01-12 09:14:02 发布

cpj46358

最新推荐文章于 2024-01-12 09:14:02 发布

阅读量181

点赞数

文章标签：数据库

文章参考： 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/