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;

Comments

Anonymous said…
ure the best. thanks a lot
Anonymous said…
thank you. solved my issue.

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

Export in Pl/Sql via DBMS_DATAPUMP

Oracle 18c - New Features for Active Data Guard