oracle在线日志损坏恢复过程

《oracle在线日志损坏恢复过程》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、在线日志损坏恢复过程上一篇/下一篇 2008-01-1511:23:17/个人分类：OracleDBA查看(164)/评论(1)/评分(0/0)DB:ORACLE9204OS:CentOSAS4--startup数据库发现如下错误SQL>startupORACLEinstancestarted.TotalSystemGlobalArea 420549952bytesFixedSize                  451904bytesVariableSize            201326592bytesDatabaseBuffers   

2、      218103808bytesRedoBuffers                667648bytesDatabasemounted.ORA-16038:log2sequence#326cannotbearchivedORA-00333:redologreaderrorblock countORA-00312:onlinelog2thread1:'/opt/oracle/oradata/oadb/redo02.log'--检查alert.logTueJan1509:26:572008Errorsinfile/opt/oracle/adm

3、in/oadb/udump/oadb_ora_3626.trc:ORA-00333:redologreaderrorblock83969count2048ORA-00312:onlinelog2thread1:'/opt/oracle/oradata/oadb/redo02.log'ORA-27091:skgfqio:unabletoqueueI/OORA-27072:skgfdisp:I/OerrorLinuxError:2:NosuchfileordirectoryAdditionalinformation:83969TueJan1509:26:

4、572008ARCH:AllArchivedestinationsmadeinactiveduetoerror333TueJan1509:26:572008Errorsinfile/opt/oracle/admin/oadb/udump/oadb_ora_3626.trc:ORA-00333:redologreaderrorblock83969count2048ARCH:Archivingnotpossible:errorcountexceededARCH:Failedtoarchivelog2thread1sequence326--检查v$log,

5、v$logfileSQL>select*fromv$log;   GROUP#   THREAD# SEQUENCE#     BYTES   MEMBERSARCSTATUS---------------------------------------------------------------------FIRST_CHANGE#FIRST_TIME--------------------------------        1         1       336 104857600         1NO INVALIDATED   

6、 122581872008-01-1500:53:25        2         1       326 104857600         1NO INACTIVE    109657862007-12-2800:53:16        3         1       335 104857600         1NO INACTIVE    121859242008-01-1400:50:31SQL>select*fromv$logfile;   GROUP#STATUS TYPE------------------------ME

7、MBER--------------------------------------------------------------------------------        1STALE  ONLINE/opt/oracle/oradata/oadb/redo01.log        2        ONLINE/opt/oracle/oradata/oadb/redo02.log        3        ONLINE/opt/oracle/oradata/oadb/redo03.log  --cleararchivelogSQ

8、L>alterdatabaseclearunarchivedlogfilegroup2;Databaseal