redolog坏块处理
1报错如下
ORA-00354: corrupt redolog block header
ORA-00353: log corruptionnear block 162280 change 465824441547 time 08/28/2015 10:44:22
ORA-00312: online log 5 thread 1:'/u01/oradata/dpweb/redo05.log
2
select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- -------------------- ---------- ---------- ------------------- ------------- ---------
4 1 20331 524288000 1 NO CURRENT 4.6586E+11 28-AUG-15
5 1 20329 524288000 1 NO INACTIVE 4.6582E+11 28-AUG-15
6 1 20330 524288000 1 NO INACTIVE 4.6584E+11 28-AUG-15
发现每个组只有1个，没有冗余，如果有冗余的话，这里就好办了，直接把损坏的文件从日志组里面踢出，重新建一个就OK了。（可见redo log做冗余的重要性）
3加日志文件
SQL>alter database addlogfile group 1 '/u01/oradata/dpweb/redo01.log' size 500M reuse;
SQL> alter databaseadd logfile group 2 '/u01/oradata/dpweb/redo02.log' size 500M reuse;
SQL> alter databaseadd logfile group 3 '/u01/oradata/dpweb/redo03.log' size 500M reuse;
4
此时，日志组已经切换到了新添加的redo01上。
select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCSTATUS FIRST_CHANGE# FIRST_TIM
---------- -------------------- ---------- ---------- --- ---------------- ------------- ---------
1 1 20332 524288000 1 NO CURRENT 4.6589E+11 28-AUG-15
2 1 0 524288000 1 YES UNUSED 0
3 1 0 524288000 1 YES UNUSED 0
4 1 20331 524288000 1 NO INACTIVE 4.6586E+11 28-AUG-15
5 1 20329 524288000 1 NO INACTIVE 4.6582E+11 28-AUG-15
6 1 20330 524288000 1 NO INACTIVE 4.6584E+11 28-AUG-15
5
终极解决方案：强制清理未归档的日志组
SQL> alter databaseclear unarchived logfile group 5;
Database altered.
总结：redo冗余的方法alter database add logfile member '/u01/app/oracle/data/db01/redo03.log' to group 3;
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！