花費一天一夜解決RAC故障(三)
對ASM節點重新載入:節點1:
[root@rac1 ~]# /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: [ OK ]
Scanning system for ASM disks: [ OK ]
[root@rac1 ~]# /etc/init.d/oracleasm scandisks
Scanning system for ASM disks: [ OK ]
[root@rac2 clusterware]# /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: [ OK ]
Scanning system for ASM disks: [ OK ]
[root@rac2 clusterware]# /etc/init.d/oracleasm scandisks
Scanning system for ASM disks: [ OK ]
[root@rac2 clusterware]#
重新啟動叢集服務:
rac1-> crs_stop -all
Attempting to stop `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1`
Attempting to stop `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2`
Stop of `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` succeeded.
Target set to OFFLINE for `ora.dbvdb.dbvdb1.inst`
Attempting to stop `ora.rac1.ASM1.asm` on member `rac1`
Stop of `ora.rac2.LISTENER_RAC2.lsnr` on member `rac2` succeeded.
Target set to OFFLINE for `ora.dbvdb.dbvdb2.inst`
Attempting to stop `ora.rac2.ASM2.asm` on member `rac2`
Stop of `ora.rac1.ASM1.asm` on member `rac1` succeeded.
Attempting to stop `ora.rac1.vip` on member `rac1`
Stop of `ora.rac1.vip` on member `rac1` succeeded.
Stop of `ora.rac2.ASM2.asm` on member `rac2` succeeded.
Attempting to stop `ora.rac2.vip` on member `rac2`
Stop of `ora.rac2.vip` on member `rac2` succeeded.
rac1-> srvctl status nodeapps -n rac1
VIP is not running on node: rac1
GSD is not running on node: rac1
Listener is not running on node: rac1
ONS daemon is not running on node: rac1
rac1-> crs_start -all
Attempting to start `ora.rac1.vip` on member `rac1`
Attempting to start `ora.rac2.vip` on member `rac2`
Start of `ora.rac2.vip` on member `rac2` succeeded.
Start of `ora.rac1.vip` on member `rac1` succeeded.
Attempting to start `ora.rac1.ASM1.asm` on member `rac1`
Attempting to start `ora.rac2.ASM2.asm` on member `rac2`
Start of `ora.rac1.ASM1.asm` on member `rac1` succeeded.
Attempting to start `ora.dbvdb.dbvdb1.inst` on member `rac1`
Start of `ora.rac2.ASM2.asm` on member `rac2` succeeded.
Attempting to start `ora.dbvdb.dbvdb2.inst` on member `rac2`
Start of `ora.dbvdb.dbvdb1.inst` on member `rac1` succeeded.
Attempting to start `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1`
Start of `ora.rac1.LISTENER_RAC1.lsnr` on member `rac1` succeeded.
Start of `ora.dbvdb.dbvdb2.inst` on member `rac2` failed.
rac1 : CRS-1018: Resource ora.rac2.vip (application) is already running on rac2
rac1 : CRS-1018: Resource ora.rac2.vip (application) is already running on rac2
CRS-0215: Could not start resource 'ora.dbvdb.dbvdb2.inst'.
CRS-0223: Resource 'ora.rac2.LISTENER_RAC2.lsnr' has placement error.
仍有報錯,不過不去管他,
繼續檢視CRS的狀態:
rac1-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.dbvdb.db application ONLINE ONLINE rac1
ora....b1.inst application ONLINE ONLINE rac1
ora....b2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
rac1-> srvctl status nodeapps -n rac1
VIP is running on node: rac1
GSD is running on node: rac1
Listener is running on node: rac1
ONS daemon is running on node: rac1
rac1-> srvctl status nodeapps -n rac2
rac1-> srvctl status nodeapps -n rac2
VIP is running on node: rac2
GSD is running on node: rac2
Listener is running on node: rac2
ONS daemon is running on node: rac2
好象有希望了。。。
趕緊啟動啟動資料庫。。。。
rac1-> srvctl status database -d devdb
PRKR-1001 : cluster database devdb does not exist
PRKO-2005 : Application error: Failure in getting Cluster Database Configuration for: devdb
資料庫依然不能啟動。走到這個地步,也只能重新建庫了,實用DBCA重新建資料庫。最後資料庫正常啟動了。。。。。。。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8334342/viewspace-373144/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 花費一天一夜解決RAC故障(二)
- 花費一天一夜解決RAC故障(一)
- mysql的三個故障解決小結薦MySql
- NFS故障解決NFS
- 解決技術債務的花費:每行程式碼3.61美金行程
- 故障解決法(摘抄)
- 11gR2 RAC使用SCAN故障切換問題的解決方案
- 【故障解決】OGG-00446 錯誤解決
- 三菱PLC常見故障及遠端維護解決方案
- 【故障解決】enq: PS - contentionENQ
- metalink登陸故障解決!
- 【故障解決】IPCS和IPCRM使用
- eMarketer:巴西網際網路廣告佔廣告總花費第三
- 【故障解決】ORA-06502錯誤解決
- 保證金解凍費 假冒APP騙財花樣多KDYAPP
- 常見硬碟故障大全 硬碟故障解決辦法大全硬碟
- Oracle 11gR2 RAC HAIP特性相關的故障的判斷及解決方法OracleAI
- DNS 引起經典RAC故障DNS
- RAC故障診斷指令碼指令碼
- ORACLE RAC GUARD故障排除——RAC GUARD概念和管理Oracle
- 解決docker: Error response from daemon故障DockerError
- Sentinel哨兵模式解決故障轉移模式
- 【Spark篇】---Spark故障解決(troubleshooting)Spark
- ORA-10873 故障解決
- Dataguard日常維護及故障解決
- TSM故障問題解決一則
- 解決儲存硬碟故障一則硬碟
- 兩個系統故障解決薦
- 【故障-ORACLE】OSWBB不能執行解決Oracle
- 重起oracle rac三節點中rac02主機以解決鏈路noname問題Oracle
- 高三鮮花 #1
- 【故障處理】一次RAC故障處理過程
- 解決DNS解析故障的幾種方法DNS
- ORA-12516故障解決
- DVR常見故障原因及解決方法VR
- Rownum分頁故障解決一例
- TSM無法備份故障解決(續)
- 從一次故障解決想到的