故障现象：逻辑STANDBY数据库注册日志成功，但应用日志出现错误，提示“ORA-00368: checksum error in redo log block”，显然是文件受到了破坏。
Tue Jul 24 08:25:59 2012
LOGMINER: WARNING: error 368 encountered, failed to read corrupt logfile /archivelog/lstandbyarch_2_27774_614088933.arc
Tue Jul 24 08:25:59 2012
Errors in file /home/oracle/admin/lstandby/bdump/lstandby_p000_229718.trc:
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 70144 change 4885842900 time 07/21/2012 22:03:20
ORA-00334: archived log: '/archivelog/lstandbyarch_2_27774_614088933.arc'
处理过程一：把正确的文件放在指定目录后参试再注册，但提示重复注册
SQL> ALTER DATABASE REGISTER LOGFILE '/archivelog/lstandbyarch_2_27774_614088933.arc';
ALTER DATABASE REGISTER LOGFILE '/archivelog/lstandbyarch_2_27774_614088933.arc'
*
ERROR at line 1:
ORA-01289: cannot add duplicate logfile
处理过程二：尝试删除日志，但不成功
SQL> execute dbms_logmnr.add_logfile('/archivelog/lstandbyarch_2_27774_614088933.arc',dbms_logmnr.REMOVEFILE);
BEGIN dbms_logmnr.add_logfile('/archivelog/lstandbyarch_2_27774_614088933.arc',dbms_logmnr.REMOVEFILE); END;
*
ERROR at line 1:
ORA-01290: cannot remove unlisted logfile
/archivelog/lstandbyarch_2_27774_614088933.arc
ORA-06512: at "SYS.DBMS_LOGMNR", line 68
ORA-06512: at line 1
处理过程三：通过delete from system.logmnr_log$删除日志成功，后注册成功，问题排除
SQL> delete from system.logmnr_log$ where session#=1 and sequence#=27774;
1 row deleted.
SQL> ALTER DATABASE REGISTER LOGFILE '/archivelog/lstandbyarch_2_27774_614088933.arc';
Database altered.
SQL>
本文转自zylhsy 51CTO博客，原文链接：http://blog.51cto.com/yunlongzheng/943061，如需转载请自行联系原作者