Posts

Showing posts from June, 2007

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 headerORA-00353: log corruption near block 24184 change 45850151 time 06/03/2007 03:10:12ORA-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;