ORA-00354: corrupt redo log block header

[former_member182034]

when i m trying to start the SQL database then i m getting following error:

.

.

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 4 17:18:30 2010

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 998244352 bytes
Fixed Size 2058440 bytes
Variable Size 507512632 bytes
Database Buffers 482344960 bytes
Redo Buffers 6328320 bytes
Database mounted.
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 64358 change 4696142 time 01/02/2010
22:08:46
ORA-00312: online log 1 thread 1: 'H:\ORACLE\SOL\ORIGLOGA\LOG_G11M1.DBF'

first of all there is no .log file in H:\ORACLE\SOL\ORIGLOGA folder

while if i started with mount then output is :

.

SQL> startup mount
ORACLE instance started.

Total System Global Area 998244352 bytes
Fixed Size 2058440 bytes
Variable Size 507512632 bytes
Database Buffers 482344960 bytes
Redo Buffers 6328320 bytes
Database mounted.
SQL> alter database clear unarchived logfile 'H:\ORACLE\SOL\ORIGLOGA\LOG_G11M1.D
BF';
alter database clear unarchived logfile 'H:\ORACLE\SOL\ORIGLOGA\LOG_G11M1.DBF'
*
ERROR at line 1:
ORA-01514: error in log specification: no such log
ORA-01517: log member: 'H:\ORACLE\SOL\ORIGLOGA\LOG_G11M1.DBF'

which log file i have to clear?

Regards,

majamil

[Former Member]

Hello,

I am facing the same prolem let me know any one got the solutions.

Thanks

Chittya Bej

[stefan_koehler]

Hello Majamil,

we need more information ... please perform the following steps and post the output (in code tags).

shell> sqlplus / as sysdba
SQL> set linesize 250
SQL> startup mount;
SQL> SELECT GROUP#, SEQUENCE#, MEMBERS, ARCHIVED, STATUS, FIRST_CHANGE# FROM V$LOG;
SQL> SELECT GROUP#, STATUS, MEMBER FROM V$LOGFILE;

Regards

Stefan

[former_member182034]

Hi Stephen,

Thanks for participate

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 4 19:07:10 2010

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> set linesize 250
SQL> startup mount;
ORACLE instance started.

Total System Global Area  998244352 bytes
Fixed Size                  2058440 bytes
Variable Size             507512632 bytes
Database Buffers          482344960 bytes
Redo Buffers                6328320 bytes
Database mounted.
SQL> select GROUP#, SEQUENCE#, MEMBERS, ARCHIVED, STATUS, FIRST_CHANGE# FROM V$L
OG;

    GROUP#  SEQUENCE#    MEMBERS ARC STATUS           FIRST_CHANGE#
---------- ---------- ---------- --- ---------------- -------------
         1        693          2 NO  ACTIVE                 4692732
         4        692          2 NO  INACTIVE               4686771
         3        695          2 NO  CURRENT                4703457
         2        694          2 NO  ACTIVE                 4697871

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

    GROUP# STATUS
---------- -------
MEMBER
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
----------
         1
H:\ORACLE\SOL\ORIGLOGA\LOG_G11M1.DBF

         1
C:\ORACLE\SOL\MIRRLOGA\LOG_G11M2.DBF

         2
H:\ORACLE\SOL\ORIGLOGB\LOG_G12M1.DBF


    GROUP# STATUS
---------- -------
MEMBER
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
----------
         2
C:\ORACLE\SOL\MIRRLOGB\LOG_G12M2.DBF

         3
H:\ORACLE\SOL\ORIGLOGA\LOG_G13M1.DBF

         3
C:\ORACLE\SOL\MIRRLOGA\LOG_G13M2.DBF


    GROUP# STATUS
---------- -------
MEMBER
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
----------
         4
H:\ORACLE\SOL\ORIGLOGB\LOG_G14M1.DBF

         4
C:\ORACLE\SOL\MIRRLOGB\LOG_G14M2.DBF


8 rows selected.

SQL>

[stefan_koehler]

Hello Majamil,

thanks for the output .. it seems like your database / server crashed.

After you fixed this issue you tried to start the database and get the error ORA-00354.

    GROUP#  SEQUENCE#    MEMBERS ARC STATUS           FIRST_CHANGE#
---------- ---------- ---------- --- ---------------- -------------
         1        693          2 NO  ACTIVE                 4692732
         4        692          2 NO  INACTIVE               4686771
         3        695          2 NO  CURRENT                4703457
         2        694          2 NO  ACTIVE                 4697871

You will need the members of redo log group 1,2 and 3 to perform a crash recovery. The problem is that the members of the ACTIVE redo log groups are not archived until yet .. so you must have one member of these redo log groups or you are lost.

Now let's take a look what files you need:

	 GROUP#    	MEMBER
  	 ---------- 	-------
         1  		H:\ORACLE\SOL\ORIGLOGA\LOG_G11M1.DBF
         1  		C:\ORACLE\SOL\MIRRLOGA\LOG_G11M2.DBF
         2  		H:\ORACLE\SOL\ORIGLOGB\LOG_G12M1.DBF
         2  		C:\ORACLE\SOL\MIRRLOGB\LOG_G12M2.DBF
         3  		H:\ORACLE\SOL\ORIGLOGA\LOG_G13M1.DBF
         3   		C:\ORACLE\SOL\MIRRLOGA\LOG_G13M2.DBF

Please tell us which of these files are still available in the filesystem?

Regards

Stefan

[Former Member]

...and if nobody deleted that folder on the H: drive, then it is eiter not mapped or the letter might have changed.

Cheers Michael

[former_member182034]

GROUP#    	MEMBER
  	 ---------- 	-------
         1  		H:\ORACLE\SOL\ORIGLOGA\LOG_G11M1.DBF
         1  		C:\ORACLE\SOL\MIRRLOGA\LOG_G11M2.DBF
         2  		H:\ORACLE\SOL\ORIGLOGB\LOG_G12M1.DBF
         2  		C:\ORACLE\SOL\MIRRLOGB\LOG_G12M2.DBF
         3  		H:\ORACLE\SOL\ORIGLOGA\LOG_G13M1.DBF
         3   		C:\ORACLE\SOL\MIRRLOGA\LOG_G13M2.DBF

yes.. the above files exist in same directories...

[stefan_koehler]

Hello Majamil,

i am little bit confused right now .. in your first post you said ...

first of all there is no .log file in H:\ORACLE\SOL\ORIGLOGA folder

and now ...

yes.. the above files exist in same directories...

However if all these files are existing now .. please retry a simple "startup" ... if the error still occurs please post the last lines from the alert.log file and the output from SQL*Plus.

Regards

Stefan

[former_member182034]

alter_sol.log file

Dump file f:\oracle\sol\102\rdbms\trace\alert_sol.log
Mon Jan 04 15:43:49 2010
ORACLE V10.2.0.2.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V5.2 Service Pack 1
CPU                 : 4 - type 8664, 1 Physical Cores
Process Affinity    : 0x0000000000000000
Memory (Avail/Total): Ph:5383M/6133M, Ph+PgF:30396M/30780M
Mon Jan 04 15:43:49 2010
Adjusting the default value of parameter parallel_max_servers
from 80 to 65 due to the value of parameter processes (80)
Mon Jan 04 15:43:49 2010
Starting ORACLE instance (normal)
Mon Jan 04 15:43:51 2010
Specified value of sga_max_size is too small, bumping to 998244352
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled

Regards,

majamil

[stefan_koehler]

Hello Majamil,

i can't see any error .. do you receive one in SQL*Plus?

Regards

Stefan

[former_member182034]

Hi Stefan..

do you receive one in SQL*Plus?

What is one in SQL?

I did not understand your point?

Regards.