1.4TB ASM(RAC) 磁盘毁损恢复小记
日期：2014-05-16 浏览次数：20852 次
1.4TB ASM(RAC) 磁盘损坏恢复小记
这周折腾了2天的时间帮客户成功恢复了一套近1.4TB的10.2.0.5 RAC(ASM). 该库在3月4号直接crash了。
大家可以看到，该库在开始报错读取redo,controlfile报错,本质原因是DISKGROUP dismount了,信息如下：
Tue Mar 04 18:09:59 CST 2014Errors in file /home/oraprod/10.2.0/db/admin/xxxx/bdump/xxxx_lgwr_15943.trc:ORA-00345: redo log write error block 68145
count 5ORA-00312: online log 6 thread 2:
'+DATA/xxxx/onlinelog/o2_t2_redo3.log'ORA-15078: ASM diskgroup was forcibly dismountedTue Mar 04 18:09:59 CST 2014SUCCESS: diskgroup DATA was dismountedSUCCESS: diskgroup DATA was dismountedTue Mar 04 18:10:00 CST 2014Errors in file /home/oraprod/10.2.0/db/admin/xxxx/bdump/xxxx_lmon_15892.trc:ORA-00202: control file:
'+DATA/xxxx/controlfile/o1_mf_4g1zr1yo_.ctl'ORA-15078: ASM diskgroup was forcibly dismountedTue Mar 04 18:10:00 CST 2014KCF: write/open error block=0x1f41e online=1file=31 +DATA/xxxx/datafile/apps_ts_queues.310.692585175error=15078 txt:
''Tue Mar 04 18:10:00 CST 2014KCF: write/open error block=0x47d5d online=1file=51 +DATA/xxx/datafile/apps_ts_tx_data.353.692593409error=15078 txt:
''Tue Mar 04 18:10:00 CST 2014Errors in file /home/oraprod/10.2.0/db/admin/xxxx/bdump/xxxx_dbw2_15939.trc:ORA-00202: control file:
'+DATA/prod/controlfile/o1_mf_4g1zr1yo_.ctl'ORA-15078: ASM diskgroup was forcibly dismountedTue Mar 04 18:10:00 CST 2014KCF: write/open error block=0x47d5b online=1file=51 +DATA/prod/datafile/apps_ts_tx_data.353.692593409
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
