逻辑 STANDBY ORA-00368日志应用失败处理一例

故障现象：逻辑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，如需转载请自行联系原作者