ORACLE RAC重建ASM磁碟組

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部落格 ” ，連結：http://blog.itpub.net/29634949/viewspace-1280908/，如需轉載，請註明出處，否則將追究法律責任。

ORACLE RAC重建ASM磁碟組

相關文章