Home » RDBMS Server » Server Administration » ora-00354
ora-00354 [message #244121] Mon, 11 June 2007 11:43 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
Hello sir


Plz help me

when i started the database it shows the following error


SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area 1041307652 bytes
Fixed Size 452612 bytes
Variable Size 536870912 bytes
Database Buffers 503316480 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 48435 change 352075754 time 06/11/2007
09:55:18
ORA-00312: online log 3 thread 1: '/mnt/ora_redo/tcms/redo03.log'

what can i do

- thanx in advance
Re: ora-00354 [message #244122 is a reply to message #244121] Mon, 11 June 2007 11:46 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
I hope you have good backups & know how to restore the DB from them.

00354, 00000, "corrupt redo log block header"
// *Cause:  The block header on the redo block indicated by the accompanying
//          error, is not reasonable.
// *Action: Do recovery with a good version of the log or do time based
//          recovery up to the indicated time. If this happens when archiving,
//          archiving of the problem log can be skipped by clearing the log
//          with the UNARCHIVED option. This must be followed by a backup of
//          every datafile to insure recoverability of the database.

[Updated on: Mon, 11 June 2007 11:47] by Moderator

Report message to a moderator

Re: ora-00354 [message #244123 is a reply to message #244122] Mon, 11 June 2007 11:49 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Try this option but i am not sure.
sql>ALTER DATABASE CLEAR LOGFILE GROUP #
SQL>alter database open;
Re: ora-00354 [message #244124 is a reply to message #244122] Mon, 11 June 2007 11:50 Go to previous messageGo to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
Thanx for replying


plz gimme the steps to recover i am in very critial situation


-plz help me
Re: ora-00354 [message #244125 is a reply to message #244124] Mon, 11 June 2007 12:06 Go to previous messageGo to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member

when i use this command it shows the following error


SQL> ALTER DATABASE CLEAR LOGFILE GROUP 3;
ALTER DATABASE CLEAR LOGFILE GROUP 3
*
ERROR at line 1:
ORA-01624: log 3 needed for crash recovery of thread 1
ORA-00312: online log 3 thread 1: '/mnt/ora_redo/tcms/redo03.log'

-Thanx
Re: ora-00354 [message #244132 is a reply to message #244125] Mon, 11 June 2007 12:35 Go to previous messageGo to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member
hello sir


if i have try to recover it ,but still it shoes error


SQL> recover database until time '2007-06-11:01:00:00';
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get

error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/mnt/ora_data/tcms/system01.dbf'


Plz help me what can i do for this case.

-Thanx.
Re: ora-00354 [message #244144 is a reply to message #244132] Mon, 11 June 2007 13:34 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
try to recover it until cancel.
Previous Topic: find out oracle startup timestamp
Next Topic: SGA Sizing Question
Goto Forum:
  


Current Time: Mon Dec 05 09:13:42 CST 2016

Total time taken to generate the page: 0.21073 seconds