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 sollution 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;
ure the best. thanks a lot
ReplyDeletethank you. solved my issue.
ReplyDelete