Thursday, 16 May 2013


Corrupt Redo Log Block Header

Today we had 100% storage in the filesystem of the database and archive logs (to many netapp snapshots).

 In the alert.log file we got:

ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 24184 change 45850151 time 06/03/2007 03:10:12
ORA-00312: online log 2 thread 1: '/cycprd/oraredo2/redo02_2.log'
ORA-00312: online log 2 thread 1: '/cycprd/oraredo2/redo02.log'
ARC0: All Archive destinations made inactive due to error 354 

After freeing this filesystem, the solution was: 

alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 3;

Checking if it worked: 

alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;

No comments:

Post a Comment