环境:Windows 2000 Advanced Server sp4+Oracle 9206现象描述:客户数据库机房在清理过程中,清洁人员不小心将服务器后面的电源线直接拔掉,导致实例断 电,数据库无法启动数据库运行在非归档模式下,没有备份,只有前一天晚上的全库导出文件数据库 重新启动以后,数据库无法打开,用SQLPLUS连接,无论如何都无法登录进去,报错如下:SQL> conn/as sysdbaERROR:ORA-01041: internal error. hostdef extension doesn't existSQL> conn sys/aa as sysdbaERROR:ORA-03113: end-of-file on communication channel解决问题的第一步就是查询alert log,相应内容如下:代码: Mon Aug 01 22:03:52 2005alter database mount exclusiveMon Aug 01 22:03:56 2005Successful mount of redo thread 1, with mount id 1487340872Mon Aug 01 22:03:56 2005Database mounted in Exclusive Mode.Completed: alter database mount exclusiveMon Aug 01 22:03:56 2005alter database openMon Aug 01 22:03:56 2005Beginning crash recovery of 1 threadsMon Aug 01 22:03:56 2005Started redo scanMon Aug 01 22:03:56 2005Completed redo scan17289 redo blocks read, 394 data blocks need recoveryMon Aug 01 22:03:56 2005Started recovery atThread 1: logseq 52, block 92832, scn 0.0Mon Aug 01 22:03:56 2005Recovery of Online Redo Log: Thread 1 Group 1 Seq 52 Reading mem 0Mem# 0 errs 0: E:/ORACLE/ORADATA/RMADB/REDO01.LOG***consistency value in tail: 0xc0250601check value in block header: 0x54b9, computed block checksum: 0x190c spare1: 0x0, spare2: 0x0, spare3: 0x0***Reread of rdba: 0x02c1f8c8 (file 11, block 129224) found same corrupted data***Corrupt block relative dba: 0x008008f9 (file 2, block 2297)Fractured block found during crash/instance recoveryData in bad block -type: 2 format: 2 rdba: 0x008008f9last change scn: 0x0000.0017f574 seq: 0x2 flg: 0x04 consistency value in tail: 0x1c9c0208check value in block header: 0xaede, computed block checksum: 0xd131 spare1: 0x0, spare2: 0x0, spare3: 0x0***Reread of rdba: 0x008008f9 (file 2, block 2297) found same corrupted data***Corrupt block relative dba: 0x02c0d2a8 (file 11, block 53928) Fractured block found during crash/instance recoveryData in bad block -type: 6 format: 2 rdba: 0x02c0d2a8last change scn: 0x0000.0017fbcb seq: 0x1 flg: 0x06 consistency value in tail: 0xd0270601check value in block header: 0x9225, computed block checksum: 0x2bec spare1: 0x0, spare2: 0x0, spare3: 0x0***Reread of rdba: 0x02c0d2a8 (file 11, block 53928) found same corrupted data***Corrupt block relative dba: 0x02c09248 (file 11, block 37448)Fractured block found during crash/instance recoveryData in bad block -type: 6 format: 2 rdba: 0x02c09248last change scn: 0x0000.0017fa10 seq: 0x1 flg: 0x06 consistency value in tail: 0xf7ec0601check value in block header: 0xd53f, computed block checksum: 0xdfc spare1: 0x0, spare2: 0x0, spare3: 0x0***Reread of rdba: 0x02c09248 (file 11, block 37448) found same corrupted data***Corrupt block relative dba: 0x028205c3 (file 10, block 132547)Fractured block found during crash/instance recoveryData in bad block -type: 6 format: 2 rdba: 0x028205c3last change scn: 0x0000.0017e7ca seq: 0x1 flg: 0x06consistency value in tail: 0xf0270601check value in block header: 0x3e5e, computed block checksum: 0x17ed spare1: 0x0, spare2: 0x0, spare3: 0x0***Reread of rdba: 0x028205c3 (file 10, block 132547) found same corrupted data***Corrupt block relative dba: 0x00800099 (file 2, block 153)Fractured block found during crash/instance recoveryData in bad block -type: 38 format: 2 rdba: 0x00800099last change scn: 0x0000.0017feda seq: 0x1 flg: 0x04 consistency value in tail: 0xe6532601check value in block header: 0x2901, computed block checksum: 0x2c6 spare1: 0x0, spare2: 0x0, spare3: 0x0***Reread of rdba: 0x00800099 (file 2, block 153) found same corrupted data***Corrupt block relative dba: 0x00800419 (file 2, block 1049)Fractured block found during crash/instance recoveryData in bad block -type: 2 format: 2 rdba: 0x00800419last change scn: 0x0000.0017e682 seq: 0x3 flg: 0x04 consistency value in tail: 0x99d90208check value in block header: 0x1f63, computed block checksum: 0x637 spare1: 0x0, spare2: 0x0, spare3: 0x0***Reread of rdba: 0x00800419 (file 2, block 1049) found same corrupted data***Corrupt block relative dba: 0x00800079 (file 2, block 121)Fractured block found during crash/instance recoveryData in bad block -type: 38 format: 2 rdba: 0x00800079last change scn: 0x0000.0017e683 seq: 0x1 flg: 0x04consistency value in tail: 0xfc202601check value in block header: 0xa5d7, computed block checksum: 0x9c09 spare1: 0x0, spare2: 0x0, spare3: 0x0***Reread of rdba: 0x00800079 (file 2, block 121) found same corrupted data***Corrupt block relative dba: 0x00800009 (file 2, block 9)Fractured block found during crash/instance recoveryData in bad block -type: 38 format: 2 rdba: 0x00800009last change scn: 0x0000.0017ce51 seq: 0x1 flg: 0x04Reread of rdba: 0x00800009 (file 2, block 9) found same corrupted dataMon Aug 01 22:03:58 2005Errors in file e:/oracle/admin/rmadb/udumps/rmadb_ora_1664.trc:ORA-00600: ??????, ??: [6101。