最新文章專題視頻專題問(wèn)答1問(wèn)答10問(wèn)答100問(wèn)答1000問(wèn)答2000關(guān)鍵字專題1關(guān)鍵字專題50關(guān)鍵字專題500關(guān)鍵字專題1500TAG最新視頻文章推薦1 推薦3 推薦5 推薦7 推薦9 推薦11 推薦13 推薦15 推薦17 推薦19 推薦21 推薦23 推薦25 推薦27 推薦29 推薦31 推薦33 推薦35 推薦37視頻文章20視頻文章30視頻文章40視頻文章50視頻文章60 視頻文章70視頻文章80視頻文章90視頻文章100視頻文章120視頻文章140 視頻2關(guān)鍵字專題關(guān)鍵字專題tag2tag3文章專題文章專題2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章專題3
問(wèn)答文章1 問(wèn)答文章501 問(wèn)答文章1001 問(wèn)答文章1501 問(wèn)答文章2001 問(wèn)答文章2501 問(wèn)答文章3001 問(wèn)答文章3501 問(wèn)答文章4001 問(wèn)答文章4501 問(wèn)答文章5001 問(wèn)答文章5501 問(wèn)答文章6001 問(wèn)答文章6501 問(wèn)答文章7001 問(wèn)答文章7501 問(wèn)答文章8001 問(wèn)答文章8501 問(wèn)答文章9001 問(wèn)答文章9501
當(dāng)前位置: 首頁(yè) - 科技 - 知識(shí)百科 - 正文

添加磁盤導(dǎo)致的ASM實(shí)例crash

來(lái)源:懂視網(wǎng) 責(zé)編:小采 時(shí)間:2020-11-09 13:01:41
文檔

添加磁盤導(dǎo)致的ASM實(shí)例crash

添加磁盤導(dǎo)致的ASM實(shí)例crash:今天核心系統(tǒng)將一塊磁盤(EMC DMX4)添加到了ASM dg中,然后數(shù)據(jù)庫(kù)RAC兩個(gè)節(jié)點(diǎn)雙雙crash掉了,頓時(shí)嚇了一身冷汗。 檢查日志: NOTE: Disk in mode 0x8 marked for de-assignmentERROR: diskgroup DGIDX1 was not mounte
推薦度:
導(dǎo)讀添加磁盤導(dǎo)致的ASM實(shí)例crash:今天核心系統(tǒng)將一塊磁盤(EMC DMX4)添加到了ASM dg中,然后數(shù)據(jù)庫(kù)RAC兩個(gè)節(jié)點(diǎn)雙雙crash掉了,頓時(shí)嚇了一身冷汗。 檢查日志: NOTE: Disk in mode 0x8 marked for de-assignmentERROR: diskgroup DGIDX1 was not mounte

今天核心系統(tǒng)將一塊磁盤(EMC DMX4)添加到了ASM dg中,然后數(shù)據(jù)庫(kù)RAC兩個(gè)節(jié)點(diǎn)雙雙crash掉了,頓時(shí)嚇了一身冷汗。 檢查日志: NOTE: Disk in mode 0x8 marked for de-assignmentERROR: diskgroup DGIDX1 was not mountedORA-15032: not all alterations perf

今天核心系統(tǒng)將一塊磁盤(EMC DMX4)添加到了ASM dg中,然后數(shù)據(jù)庫(kù)RAC兩個(gè)節(jié)點(diǎn)雙雙crash掉了,頓時(shí)嚇了一身冷汗。
檢查日志:

NOTE: Disk in mode 0x8 marked for de-assignment
ERROR: diskgroup DGIDX1 was not mounted
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "16" is missing from group number "4" 
ERROR: ALTER DISKGROUP DGIDX1 MOUNT /* asm agent *//* {1:8345:41140} */
Thu Nov 06 15:17:41 2014
Errors in file /oraclelog/grid/diag/asm/+asm/+ASM1/trace/+ASM1_pz99_22545054.trc:
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 16: Device busy
Additional information: -1
Additional information: 4096
WARNING: Read Failed. group:0 disk:10 AU:0 offset:0 size:4096
Errors in file /oraclelog/grid/diag/asm/+asm/+ASM1/trace/+ASM1_pz99_22545054.trc:
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 16: Device busy
Additional information: -1
Additional information: 4096
WARNING: Read Failed. group:0 disk:9 AU:0 offset:0 size:4096
Errors in file /oraclelog/grid/diag/asm/+asm/+ASM1/trace/+ASM1_pz99_22545054.trc:
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 16: Device bus

新加的盤不能使用,但是此時(shí)兩個(gè)節(jié)點(diǎn)嘗試ASM和數(shù)據(jù)庫(kù)實(shí)例恢復(fù),第二個(gè)節(jié)點(diǎn)卻起了起來(lái),目前問(wèn)題是第一個(gè)節(jié)點(diǎn)的讀取問(wèn)題??赡苁沁@個(gè)LUN對(duì)主機(jī)的存儲(chǔ)鎖、SAN鏈路等問(wèn)題導(dǎo)致了。此時(shí)在第二個(gè)節(jié)點(diǎn)ASM實(shí)例中查看v$asm_operation視圖,結(jié)果為空。看來(lái)這個(gè)盤的rebalance操作已經(jīng)完成了。為了讓這個(gè)生產(chǎn)系統(tǒng)早點(diǎn)上線,我們選擇了把這個(gè)有問(wèn)題的LUN從ASM第二個(gè)實(shí)例中剔除,還原初始環(huán)境。在asmca中操作后,檢查rebalance進(jìn)度:

SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES ERROR_CODE
----------- --------------------------------------------
 4 REBAL RUN 1 1 36659 49690 2899
 4

一共49G的數(shù)據(jù)需要操作,等待SOFAR=EST_WORK后,該LUN被成功剔除。此時(shí)第一個(gè)節(jié)點(diǎn)的ASM實(shí)例也成功啟動(dòng)。吃一塹長(zhǎng)一智,在數(shù)據(jù)庫(kù)真正使用一個(gè)磁盤之前,檢查設(shè)備的可用性是非常重要的。Oracle的ACS也提到了一個(gè)工具kfod(in $GRID_HOME/bin),可以快速檢查L(zhǎng)UN的有效性,蓋總也簡(jiǎn)單介紹過(guò)該工具:kfod in oracle_asm

# 在第2個(gè)節(jié)點(diǎn),可以找到該磁盤的信息
$ kfod disk=all |grep 113
 139: 51930 Mb /dev/rhd113 grid asmadmin
# 在第1個(gè)節(jié)點(diǎn),則找不到該磁盤的信息,說(shuō)明Oracle GI無(wú)法正確識(shí)別該LUN。
$ kfod disk=all |grep 113

>o<

聲明:本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí),若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系,我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

本文如未解决您的问题请添加抖音号:51dongshi(抖音搜索懂视),直接咨询即可。

文檔

添加磁盤導(dǎo)致的ASM實(shí)例crash

添加磁盤導(dǎo)致的ASM實(shí)例crash:今天核心系統(tǒng)將一塊磁盤(EMC DMX4)添加到了ASM dg中,然后數(shù)據(jù)庫(kù)RAC兩個(gè)節(jié)點(diǎn)雙雙crash掉了,頓時(shí)嚇了一身冷汗。 檢查日志: NOTE: Disk in mode 0x8 marked for de-assignmentERROR: diskgroup DGIDX1 was not mounte
推薦度:
標(biāo)簽: 添加 系統(tǒng) 今天
  • 熱門焦點(diǎn)
專題
Top
fffffffffffff

抖音扫码关注

手机端二维码

每天分享百科知识!