溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
數據庫實例日志：
Tue Mar 01 12:18:12 2016
SUCCESS: diskgroup ORADISKGRP1 was dismounted
SUCCESS: diskgroup ORADISKGRP1 was dismounted
Errors in file C:\APP\ORACLE\PRODUCT\11.2.0\diag\rdbms\bflex\bflex1\trace\bflex1_ckpt_6376.trc:
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '+ORADISKGRP1/bflex/controlfile/current.287.925642037'
ORA-15078: ASM diskgroup was forcibly dismounted
ORA-15078: ASM diskgroup was forcibly dismounted
再看asm日志
Tue Mar 01 12:18:12 2016
ASM Health Checker found 1 new failures
Dirty Detach Reconfiguration complete
Tue Nov 01 12:18:12 2016
WARNING: dirty detached from domain 1
NOTE: cache dismounted group 1/0x5DD073B7 (ORADISKGRP1)
SQL> alter diskgroup ORADISKGRP1 dismount force /* ASM SERVER:1573942199 */
Tue Nov 01 12:18:12 2016
NOTE: cache deleting context for group ORADISKGRP1 1/0x5dd073b7
GMON dismounting group 1 at 6 for pid 30, osid 7684
NOTE: Disk ORADISKGRP1_0000 in mode 0x7f marked for de-assignment
NOTE: Disk ORADISKGRP1_0001 in mode 0x7f marked for de-assignment
NOTE: Disk ORADISKGRP1_0002 in mode 0x7f marked for de-assignment
SUCCESS: diskgroup ORADISKGRP1 was dismounted
SUCCESS: alter diskgroup ORADISKGRP1 dismount force /* ASM SERVER:1573942199 */
SUCCESS: ASM-initiated MANDATORY DISMOUNT of group ORADISKGRP1
這里的asm日志很明顯由于asm disk無法正常訪問,報ORA-27072錯誤,磁盤組被強制dismount. 一般出現這樣故障的原因大多都是人為誤操作造成的，比如掛到A機的裸盤被掛至B機，然后被誤格式化。
處理辦法：
先用kfed恢復磁盤頭
C:\Users\Administrator> kfed repair '\\.\J:'C:\Users\Administrator>kfed read '\\.\J:'kfbh.endian: 1 ; 0x000: 0x01kfbh.hard: 130 ; 0x001: 0x82kfbh.type: 1 ; 0x002: KFBTYP_DISKHEADkfbh.datfmt: 1 ; 0x003: 0x01kfbh.block.blk: 254 ; 0x004: T=0 NUMB=0xfekfbh.block.obj: 2147483654 ; 0x008: TYPE=0x8 NUMB=0x6kfbh.check: 717599272 ; 0x00c: 0x2ac5b228kfbh.fcn.base: 0 ; 0x010: 0x00000000kfbh.fcn.wrap: 0 ; 0x014: 0x00000000kfbh.spare1: 0 ; 0x018: 0x00000000kfbh.spare2: 0 ; 0x01c: 0x00000000kfdhdb.driver.provstr: ORCLDISKDATA6 ; 0x000: length=13kfdhdb.driver.reserved[0]: 1096040772 ; 0x008: 0x41544144kfdhdb.driver.reserved[1]: 54 ; 0x00c: 0x00000036kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000使用asmtool -list查看相關磁盤信息
然后用dbv檢測是否有壞塊，沒有就好辦了。幸好asm有備份，用備份恢復即可。
SQL> recover database;完成介質恢復。SQL> alter database open;數據庫已更改。免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
