今天早上突然断电,库挂掉了。启动时能mount不能open,显示以下错误,ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 85688 change 6016586 time 05/25/2010
14:03:28
ORA-00312: online log 2 thread 1: '/inet/apps/oracle/oradata/INET/redo02.log'我在网上查了查恢复方法,按照以下方法执行SQL> alter system set "_disable_logging"=false scope=both;System altered.SQL> alter database clear unarchived logfile '/inet/apps/oracle/oradata/INET/redo02.log';alter database clear unarchived logfile '/inet/apps/oracle/oradata/INET/redo02.log'
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance INET (thread 1)
ORA-00312: online log 2 thread 1: '/inet/apps/oracle/oradata/INET/redo02.log'现在不知道怎么办了,大家帮帮忙啊
ORA-00353: log corruption near block 85688 change 6016586 time 05/25/2010
14:03:28
ORA-00312: online log 2 thread 1: '/inet/apps/oracle/oradata/INET/redo02.log'我在网上查了查恢复方法,按照以下方法执行SQL> alter system set "_disable_logging"=false scope=both;System altered.SQL> alter database clear unarchived logfile '/inet/apps/oracle/oradata/INET/redo02.log';alter database clear unarchived logfile '/inet/apps/oracle/oradata/INET/redo02.log'
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance INET (thread 1)
ORA-00312: online log 2 thread 1: '/inet/apps/oracle/oradata/INET/redo02.log'现在不知道怎么办了,大家帮帮忙啊
Cause: The block header on the redo block indicated by the accompanying error, is not reasonable.
Action: Do recovery with a good version of the log or do time based recovery up to the indicated time. If this happens when archiving, archiving of the problem log can be skipped by clearing the log with the UNARCHIVED option. This must be followed by a backup of every datafile to insure recoverability of the database.
把数据库恢复一下:
1.shutdown immediate;
2.startup mount;
3.recover database until cancel;
4.alter database resetlogs;------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977