运行数据库恢复检查脚本(Oracle Database Recovery Check)相关对应脚本,生成html和alert日志发我,我给你们看看
---------------------------------------------------------------
QQ号:107644445
邮箱:[email protected]
BLOG:http://www.xifenfei.com
提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)
---------------------------------------------------------------
QQ号:107644445
邮箱:[email protected]
BLOG:http://www.xifenfei.com
提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)
alter database open
Tue May 13 09:10:53 2014
Beginning crash recovery of 1 threads
parallel recovery started with 5 processes
Read from controlfile member 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\CONTROL01.CTL' has found a fractured block (blk# 19, seq# 15785)
Tue May 13 09:10:54 2014
Started redo scan
Read from controlfile member 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\CONTROL01.CTL' has found a fractured block (blk# 19, seq# 15786)
Tue May 13 09:10:54 2014
Errors in file d:\oracle\product\10.2.0\admin\interlib\udump\interlib_ora_2520.trc:
ORA-00314: ?? 3 (???? 1) ????? 1366 ? 1363 ???
ORA-00312: ???? 3 ?? 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\REDO03.LOG'Tue May 13 09:10:54 2014
Aborting crash recovery due to error 314
Tue May 13 09:10:54 2014
Errors in file d:\oracle\product\10.2.0\admin\interlib\udump\interlib_ora_2520.trc:
ORA-00314: ?? 3 (???? 1) ????? 1366 ? 1363 ???
ORA-00312: ???? 3 ?? 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\REDO03.LOG'ORA-314 signalled during: alter database open...
Tue May 13 09:12:10 2014
Shutting down instance: further logons disabled从这里看应该是redo异常,或者你搞错redo日志了,加qq(107644445),具体聊聊