ORA-00354: corrupt redo log block header

[Former Member]

Hi Guys,

Need your support to resolve one of the oracle issues,

Below are errors visible in alert.log in oracle,

ORA-16038: log 24 sequence# 660467 cannot be archived

ORA-00354: corrupt redo log block header

ORA-00312: online log 24 thread 1: '/oracle/PRD/origlogB/log_g24_m1.dbf'...

• 2010-10-03 07:26:12.835 20195 kcrr.c

ORA-16014: log 24 sequence# 660467 not archived, no available

destinations

Below is o/p of archive log list seems to be bit strange,

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/PRD/saparch/PRDarch

Oldest online log sequence 660467

Next log sequence to archive 660467

Current log sequence 660576

And some more info,

SQL> SELECT GROUP#, STATUS, MEMBER FROM V$LOGFILE;

GROUP# STATUS MEMBER

-

---

-

---

-

---

28 /oracle/PRD/origlogB/log_g28_m1.dbf

28 /oracle/PRD/mirrlogB/log_g28_m2.dbf

27 /oracle/PRD/origlogA/log_g27_m1.dbf

27 /oracle/PRD/mirrlogA/log_g27_m2.dbf

26 /oracle/PRD/origlogB/log_g26_m1.dbf

26 /oracle/PRD/mirrlogB/log_g26_m2.dbf

25 /oracle/PRD/origlogA/log_g25_m1.dbf

25 /oracle/PRD/mirrlogA/log_g25_m2.dbf

24 /oracle/PRD/origlogB/log_g24_m1.dbf

24 /oracle/PRD/mirrlogB/log_g24_m2.dbf

23 /oracle/PRD/origlogA/log_g23_m1.dbf

23 /oracle/PRD/mirrlogA/log_g23_m2.dbf

22 /oracle/PRD/origlogB/log_g22_m1.dbf

22 /oracle/PRD/mirrlogB/log_g22_m2.dbf

21 /oracle/PRD/origlogA/log_g21_m1.dbf

21 /oracle/PRD/mirrlogA/log_g21_m2.dbf

16 rows selected.

SQL> SELECT GROUP#, SEQUENCE#, MEMBERS, ARCHIVED, STATUS, FIRST_CHANGE# FROM V$LOG;

GROUP# SEQUENCE# MEMBERS ARC STATUS FIRST_CHANGE#

-

---

-

---

-

---

--- -

---

-

---

21 660571 2 NO INACTIVE 2.9116E+10

22 660572 2 NO INACTIVE 2.9116E+10

23 660570 2 NO INACTIVE 2.9116E+10

24 660467 2 NO INACTIVE 2.9114E+10

25 660573 2 NO ACTIVE 2.9116E+10

26 660574 2 NO CURRENT 2.9116E+10

27 660568 2 NO INACTIVE 2.9116E+10

28 660569 2 NO INACTIVE 2.9116E+10

8 rows selected.

All file exists but still facing issue, no backup is running

Regards,

Yash

[Former Member]

Issue resolved after executing the command,

SQL> alter database clear unarchived logfile group 24;

Database altered.

Cheers!!!

[Former Member]

We tried executing below script as per SAP Note 694155 - Error due to corrupt redo logs, but getting below error

SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE '/oracle/PRD/origlogB/log_g24_m1.dbf';

ALTER DATABASE CLEAR UNARCHIVED LOGFILE '/oracle/PRD/origlogB/log_g24_m1.dbf'

*

ERROR at line 1:

ORA-01514: error in log specification: no such log

ORA-01517: log member: '/oracle/PRD/origlogB/log_g24_m1.dbf'

But file exists in specified location,

% ls -l /oracle/PRD/origlogB/log_g24_m1.dbf

-rw-rr 1 oraprd dba 83886592 Oct 03 05:03 /oracle/PRD/origlogB/log_g24_m1.dbf

Regards,

Yash

[Former Member]

Hi,

Instead of the logfile name, try the command with the logfile integer as mentioned below.

alter database clear unarchived logfile group <integer>;

You can get the logfile integer using the view, v$log.

select GROUP#,MEMBERS,STATUS from v$log;

The value for the parameter GROUP# is the logfile integer.

Hope this helps.

Regards,

Varadharajan M