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
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 ~]$ 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 *
+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
[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
查看数据库实例状态,如下:
节点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博客 ” ,链接:http://blog.itpub.net/29634949/viewspace-1280908/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29634949/viewspace-1280908/