Oracle 11g RAC表決盤和OCR盤掛載失敗引發的節點故障
測試環境的一套兩節點RAC,一個節點出現故障,啟動不了例項
檢視節點1的grid日誌,發現找不到表決盤
tail -100 /opt/ora11grid/log/vgerndpud853/alertvgerndpud853.log
..
[cssd(3824)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
2016-10-17 07:56:11.768
[cssd(3824)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
2016-10-17 07:56:26.781
[cssd(3824)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
2016-10-17 07:56:41.794
[cssd(3824)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
2016-10-17 07:56:55.095
[/opt/ora11grid/bin/cssdagent(3812)]CRS-5818:Aborted command 'start' for resource 'ora.cssd'. Details at (:CRSAGF00113:) {0:34:3} in /opt/ora11grid/log/vgerndpud853/agent/ohasd/oracssdagent_root/oracssdagent_root.log.
2016-10-17 07:56:55.096
[cssd(3824)]CRS-1656:The CSS daemon is terminating due to a fatal error; Details at (:CSSSC00012:) in /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
檢視grid日誌中提到的詳細日誌,進一步驗證了表決盤丟失
tail -100 /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
..
222499 2016-10-17 08:06:58.959: [ SKGFD][257890048]Discovery with str:/voting/vot1/vot1.data,/voting/vot2/vot2.data,/voting/vot3/vot3.data:
222500
222501 2016-10-17 08:06:58.959: [ SKGFD][257890048]UFS discovery with :/voting/vot1/vot1.data:
222502
222503 2016-10-17 08:06:58.959: [ SKGFD][257890048]OSS discovery with :/voting/vot1/vot1.data:
222504
222505 2016-10-17 08:06:58.959: [ SKGFD][257890048]Discovery advancing to nxt string :/voting/vot2/vot2.data:
222506
222507 2016-10-17 08:06:58.959: [ SKGFD][257890048]UFS discovery with :/voting/vot2/vot2.data:
222508
222509 2016-10-17 08:06:58.959: [ SKGFD][257890048]OSS discovery with :/voting/vot2/vot2.data:
222510
222511 2016-10-17 08:06:58.959: [ SKGFD][257890048]Discovery advancing to nxt string :/voting/vot3/vot3.data:
222512
222513 2016-10-17 08:06:58.959: [ SKGFD][257890048]UFS discovery with :/voting/vot3/vot3.data:
222514
222515 2016-10-17 08:06:58.959: [ SKGFD][257890048]OSS discovery with :/voting/vot3/vot3.data:
222516
222517 2016-10-17 08:06:58.959: [ CSSD][257890048]clssnmvDiskVerify: Successful discovery of 0 disks
222518 2016-10-17 08:06:58.959: [ CSSD][257890048]clssnmCompleteInitVFDiscovery: Completing initial voting file discovery
登陸節點2
檢視叢集狀態,發現節點2的狀態正常
crs_stat -t -v
檢視錶決盤和crs盤的掛載情況,正常
vgerndpud852: /opt/ora11grid/bin # mount | grep vot
/dev/vx/dsk/dg_orabe/v_vot2 on /voting/vot2 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
/dev/vx/dsk/dg_orabe/v_vot1 on /voting/vot1 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
/dev/vx/dsk/dg_orabe/v_vot3 on /voting/vot3 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
vgerndpud852: /opt/ora11grid/bin # mount | grep ocr
/dev/vx/dsk/dg_orabe/v_ocr2 on /ocr/ocr2 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
/dev/vx/dsk/dg_orabe/v_ocr3 on /ocr/ocr3 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
/dev/vx/dsk/dg_orabe/v_ocr1 on /ocr/ocr1 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
在節點1,檢視錶決盤和crs盤的掛載情況,發現盤沒有掛載上
/opt/ora11grid[FRWK]:mount | grep vot
/opt/ora11grid[FRWK]:mount | grep ocr
重新掛載盤,重啟叢集,RAC恢復正常
檢視節點1的grid日誌,發現找不到表決盤
tail -100 /opt/ora11grid/log/vgerndpud853/alertvgerndpud853.log
..
[cssd(3824)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
2016-10-17 07:56:11.768
[cssd(3824)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
2016-10-17 07:56:26.781
[cssd(3824)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
2016-10-17 07:56:41.794
[cssd(3824)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds; Details at (:CSSNM00070:) in /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
2016-10-17 07:56:55.095
[/opt/ora11grid/bin/cssdagent(3812)]CRS-5818:Aborted command 'start' for resource 'ora.cssd'. Details at (:CRSAGF00113:) {0:34:3} in /opt/ora11grid/log/vgerndpud853/agent/ohasd/oracssdagent_root/oracssdagent_root.log.
2016-10-17 07:56:55.096
[cssd(3824)]CRS-1656:The CSS daemon is terminating due to a fatal error; Details at (:CSSSC00012:) in /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
檢視grid日誌中提到的詳細日誌,進一步驗證了表決盤丟失
tail -100 /opt/ora11grid/log/vgerndpud853/cssd/ocssd.log
..
222499 2016-10-17 08:06:58.959: [ SKGFD][257890048]Discovery with str:/voting/vot1/vot1.data,/voting/vot2/vot2.data,/voting/vot3/vot3.data:
222500
222501 2016-10-17 08:06:58.959: [ SKGFD][257890048]UFS discovery with :/voting/vot1/vot1.data:
222502
222503 2016-10-17 08:06:58.959: [ SKGFD][257890048]OSS discovery with :/voting/vot1/vot1.data:
222504
222505 2016-10-17 08:06:58.959: [ SKGFD][257890048]Discovery advancing to nxt string :/voting/vot2/vot2.data:
222506
222507 2016-10-17 08:06:58.959: [ SKGFD][257890048]UFS discovery with :/voting/vot2/vot2.data:
222508
222509 2016-10-17 08:06:58.959: [ SKGFD][257890048]OSS discovery with :/voting/vot2/vot2.data:
222510
222511 2016-10-17 08:06:58.959: [ SKGFD][257890048]Discovery advancing to nxt string :/voting/vot3/vot3.data:
222512
222513 2016-10-17 08:06:58.959: [ SKGFD][257890048]UFS discovery with :/voting/vot3/vot3.data:
222514
222515 2016-10-17 08:06:58.959: [ SKGFD][257890048]OSS discovery with :/voting/vot3/vot3.data:
222516
222517 2016-10-17 08:06:58.959: [ CSSD][257890048]clssnmvDiskVerify: Successful discovery of 0 disks
222518 2016-10-17 08:06:58.959: [ CSSD][257890048]clssnmCompleteInitVFDiscovery: Completing initial voting file discovery
登陸節點2
檢視叢集狀態,發現節點2的狀態正常
crs_stat -t -v
檢視錶決盤和crs盤的掛載情況,正常
vgerndpud852: /opt/ora11grid/bin # mount | grep vot
/dev/vx/dsk/dg_orabe/v_vot2 on /voting/vot2 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
/dev/vx/dsk/dg_orabe/v_vot1 on /voting/vot1 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
/dev/vx/dsk/dg_orabe/v_vot3 on /voting/vot3 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
vgerndpud852: /opt/ora11grid/bin # mount | grep ocr
/dev/vx/dsk/dg_orabe/v_ocr2 on /ocr/ocr2 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
/dev/vx/dsk/dg_orabe/v_ocr3 on /ocr/ocr3 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
/dev/vx/dsk/dg_orabe/v_ocr1 on /ocr/ocr1 type vxfs (rw,mntlock=VCS,cluster,crw,delaylog,largefiles,ioerror=mdisable)
在節點1,檢視錶決盤和crs盤的掛載情況,發現盤沒有掛載上
/opt/ora11grid[FRWK]:mount | grep vot
/opt/ora11grid[FRWK]:mount | grep ocr
重新掛載盤,重啟叢集,RAC恢復正常
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26506993/viewspace-2126822/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle RAC啟動失敗(DNS故障)OracleDNS
- Oracle RAC 遷移替換 OCR 盤Oracle
- Oracle RAC常見啟動失敗故障分析Oracle
- Oracle 11g RAC重新新增節點Oracle
- oracle 11g rac新增節點前之清除節點資訊Oracle
- oracle遷移OCR盤Oracle
- 虛擬機器搭建rac ASM盤啟動失敗虛擬機ASM
- RAC節點啟動失敗--ASM無法連線ASM
- 11g rac新增節點步驟(11g)
- Oracle RAC新增節點Oracle
- rac新增節點步驟(11g)
- ORACLE RAC 兩節點db_32k_cache_size設定不當導致表truncate失敗之ORA-00379Oracle
- 盤點敏捷專案失敗的6個主要原因敏捷
- win10更新失敗c盤滿了如何解決_win10更新失敗提示c盤滿了解決步驟Win10
- 【掛載新盤】
- 11g rac新增節點容易遇到的問題
- rac新增節點容易遇到的問題(11g)
- Oracle DG同步失敗故障處理(二)Oracle
- Oracle 12c rac ocr和votedisk管理Oracle
- Oracle RAC啟動失敗-軟連結惹的禍Oracle
- 安裝Oracle 11G RAC 遇到的2個問題——Failed to run "oifcfg" 和 找不到叢集節點OracleAI
- 19c RAC因profile.xml檔案丟失節點1啟動失敗XML
- 3節點RAC資料庫夯故障分析資料庫
- 關於Oracle 11G RAC雙節點之間存在防火牆導致只能一個節點執行Oracle防火牆
- oracle11g RAC新增節點Oracle
- 新版百度網盤經常下載檔案失敗,以及百度網盤自動更新的解決方案
- 多系統盤掛載
- Hadoop 啟動namenode節點失敗Hadoop
- 技術部如何做覆盤——“年終盤點一對一”之創業失敗的工程師創業工程師
- Linux掛載資料盤教程,Linux初始化系統盤後重新掛載資料盤方法Linux
- 車載U盤和普通U盤哪個好 車載U盤和普通U盤的區別
- Oracle RAC命中ORA-7445只能開啟一個節點故障案例分析Oracle
- Oracle RAC NFS掛載檔案系統OracleNFS
- 【故障公告】K8s CofigMap 掛載問題引發網站故障K8S網站
- namenode單節點啟動成功後自動消失/格式化失敗/fsimage載入失敗
- Oracle 11g RAC Silent Install For NFSOracleNFS
- 私有IP丟失造成Oracle 12C RAC叢集節點不能啟動Oracle
- UDEV掛載EMC多路徑盤dev
- Pod掛載Volume失敗問題分析