oracle在日志损坏恢复过程.docVIP

在线日志损坏恢复过程 上一篇 / 下一篇 ?2008-01-15 11:23:17 / 个人分类：Oracle DBA 查看( 164 ) / 评论( 1 ) / 评分( 0 / 0 ) DB :ORACLE 9204OS :CentOS AS4 -- startup 数据库发现如下错误SQL startupORACLE instance started. Total System Global Area? 420549952 bytesFixed Size?????????????????? 451904 bytesVariable Size???????????? 201326592 bytesDatabase Buffers????????? 218103808 bytesRedo Buffers???????????????? 667648 bytesDatabase mounted.ORA-16038: log 2 sequence# 326 cannot be archivedORA-00333: redo log read error block? countORA-00312: online log 2 thread 1: /opt/oracle/oradata/oadb/redo02.log -- 检查alert.log Tue Jan 15 09:26:57 2008Errors in file /opt/oracle/admin/oadb/udump/oadb_ora_3626.trc:ORA-00333: redo log read error block 83969 count 2048ORA-00312: online log 2 thread 1: /opt/oracle/oradata/oadb/redo02.logORA-27091: skgfqio: unable to queue I/OORA-27072: skgfdisp: I/O errorLinux Error: 2: No such file or directoryAdditional information: 83969Tue Jan 15 09:26:57 2008ARCH: All Archive destinations made inactive due to error 333Tue Jan 15 09:26:57 2008Errors in file /opt/oracle/admin/oadb/udump/oadb_ora_3626.trc:ORA-00333: redo log read error block 83969 count 2048ARCH: Archiving not possible: error count exceededARCH: Failed to archive log 2 thread 1 sequence 326 -- 检查v$log , v$logfile SQL select * from v$log; ??? GROUP#??? THREAD#? SEQUENCE#????? BYTES??? MEMBERS ARC STATUS---------- ---------- ---------- ---------- ---------- --- ----------------FIRST_CHANGE# FIRST_TIME------------- -------------------???????? 1????????? 1??????? 336? 104857600????????? 1 NO? INVALIDATED????2008-01-15 00:53:25 ???????? 2????????? 1??????? 326? 104857600????????? 1 NO? INACTIVE????2007-12-28 00:53:16 ???????? 3????????? 1??????? 335? 104857600????????? 1 NO? INACTIVE????2008-01-14 00:50:31 SQL select * from v$logfile; ??? GROUP# STATUS? TYPE---------- ------- -------MEMBER---------------------------------------------------------------------------