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

Post a Comment

Popular posts from this blog

Data Guard - Changing IP Addresses

Install Oracle Internet Directory (OID) in Standalone mode

Fixing & Registering ORACLE_HOMES in Central Inventory