oracle在线日志损坏恢复过程.doc

在线日志损坏恢复过程上一篇 / 下一篇 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.logTue 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$logfileSQL select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS- - - - - - -FIRST_CHANGE# FIRST_TIME- - 1 1 336 104857600 1 NO INVALIDATED 12258187 2008-01-15 00:53:25 2 1 326 104857600 1 NO INACTIVE 10965786 2007-12-28 00:53:16 3 1 335 104857600 1 NO INACTIVE 12185924 2008-01-14 00:50:31SQL select * from v$logfile; GROUP# STATUS TYPE- - -MEMBER- 1 STALE ONLINE/opt/oracle/oradata/oadb/redo01.log 2 ONLINE/opt/oracle/oradata/oadb/redo02.log 3 ONLINE/opt/oracle/oradata/oadb/redo03.log- clear archive logSQL alter database clear unarchived logfile group 2;Database altered.SQL alter database open;Database altered.SQL- 数据库已经打开,进行备份.由于此数据库只有一个应用,所以到出了一个用户.exp user/pas file=xx导入论坛 引用链接 收藏 分享给好友 推荐到圈子 管理 举报 TAG: 引用 删除 oradbHome / 2008-05-23 16:52:34 1、非归档模式 SQLstartup mount; SQLselect * from v$logfile;如果日志文件丢失了，手工建上相应的日志文件放在原处（新建一个文本文件，改为相应的日志名就可以了） SQLSelect * from v$log; 查看日志文件当前状态SQLalter database clear logfile group N;(N为非当前状态组号，把所有非当前状态的日志进行恢复)；(语句的作用是把该日志文件，清空为标准空日志文件) SQLrecover database until cancel; (恢复当前日志) SQLalter database open resetlogs; 如果是单个日志文件损坏 SQLstartup mount; SQLalter database clear logfile group N; SQLalter database open; 2、归档模式 与上面操作大致一样如果如果alter database clear logfile group N 执行不成功就改为：alter database clear unarchived logfile group N特别要注意的：alter database open resetlogs;Resetlogs: 表示一个数据库逻辑生存期结束和一个数据库逻辑生存期的开始. 每次使用resetlogs时,SCN计数器不会被重置,oracle会重置其它计数器(如日志序列号),同时还会重置重做日志的内容. 如果当前日志文件损坏无法通过recover database until cancel恢复就用第三种方式处理。3、当前日志文件损坏的处理办法：SQLstartup mount;SQLcreate pfile=d:orace_testpfile.txtfrom spfile; (8i及以前版本直接找到参数文件复制一份就可以了)SQLshutdown immediate;编辑生成的pfile,加入_allow_resetlogs_corruption=TRUESQLstartup mount pfile=d:oracle_testpfile.txt;SQLalter database open resetlogs;数据库被打开后，马上执行一个full export shutdown数据库重建库 import并完成恢复 建议执行一下ANALYZE TABLE .VALIDATE ST