1.查看要删除磁盘组的名字

2.删除ASM磁盘组

3.关闭节点的ASM实例
[oracle@rac1 ~]$ crs_stop -f ora.rac1.ASM1.asm --节点rac2的磁盘组没有挂载上
Attempting to stop `ora.rac1.ASM1.asm` on member `rac1`
Stop of `ora.rac1.ASM1.asm` on member `rac1` succeeded.
[oracle@rac1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 OFFLINE OFFLINE
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

4.删除ASM服务
[oracle@rac1 ~]$ srvctl remove asm -n rac1
5.删除节点配置文件
节点rac1操作：
[oracle@rac1 ~]$ cd /u01/app/oracle/db_1/dbs/
[oracle@rac1 dbs]$ rm *ASM*
[oracle@rac1 dbs]$ ls
arch hc_HHPEN11.dat init.ora
c-2744404128-20140901-00 hc_orcl1.dat snapcf_HHPEN11.f
c-2744404128-20140901-01 initdw.ora
[oracle@rac1 admin]$ pwd
/u01/app/oracle/admin

[oracle@rac1 admin]$ ls
+ASM
[oracle@rac1 admin]$ rm -rf *

节点rac2操作：
[oracle@rac2 ~]$ cd /u01/app/oracle/db_1/dbs/
[oracle@rac2 dbs]$ rm -rf *ASM*
[oracle@rac2 dbs]$ ls
arch hc_HHPEN11.dat initHHPEN11.ora snapcf_HHPEN11.f
c-2744404128-20140901-00 hc_orcl1.dat init.ora
c-2744404128-20140901-01 initdw.ora orapwHHPEN11

6.删除/etc/oratab实例信息
节点rac1、rac2都要操作；
7.使用dbca重新创建asm实例
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ crs_stat -t -v --查看ASM实例的创建信息，发现还是只有节点1的实例信息
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE 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

创建数据库的时候出现如下错误：

8.查看CRS资源信息，如下：

查看数据库实例状态，如下：

ITPub博客

ORACLE RAC重建ASM磁盘组

最新文章