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/，如需轉載，請註明出處，否則將追究法律責任。

ORACLE使用 DBCA 重建ASM磁碟組的相關問題總結

相關文章