欢迎来到天天文库
浏览记录
ID:38253208
大小:39.00 KB
页数:6页
时间:2019-06-06
《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
此文档下载收益归作者所有