OraFAQ Forum: Server Administration » corrupt block header error

Home » RDBMS Server » Server Administration » corrupt block header error (9.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

corrupt block header error [message #285561]

Wed, 05 December 2007 01:14

varu123
Messages: 754
Registered: October 2007

Senior Member

On starting the oracle database,
I got these errors:
ora-10033
0ra-00354
ora-00312

What should be the course of action?

Report message to a moderator

Re: corrupt block header error [message #285564 is a reply to message #285561]

Wed, 05 December 2007 01:16

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Copy and paste the screen messages and what you have done and actually what is the output?

Report message to a moderator

Re: corrupt block header error [message #285565 is a reply to message #285561]

Wed, 05 December 2007 01:18

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

1. Doesn't exists

2.
ORA-00354: 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.

3.
ORA-00312: online log string thread string: 'string'

Cause: This message reports the filename for details of another message.

Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.

Report message to a moderator

Re: corrupt block header error [message #285572 is a reply to message #285561]

Wed, 05 December 2007 01:21

varu123
Messages: 754
Registered: October 2007

Senior Member

I connected to one of my remote site and did
dbstart
and got these three errors
The database is in archive log mode
ora-00354: corrupt redo log block error.

Since the redo log is corrupted i was thinking to manually remove the redo log.NO data would be lost i guess
Alter database clear logfile group "grp_no";

Wiould this approach work or is right?

Report message to a moderator

Re: corrupt block header error [message #285574 is a reply to message #285572]

Wed, 05 December 2007 01:24

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

First check corrupted redo log is not CURRENT ?
if yes then you have to perform recovery.
otherwise you can clear that logfile.

http://download.oracle.com/docs/cd/B14117_01/server.101/b10739/onlineredo.htm#sthref915

Report message to a moderator

Re: corrupt block header error [message #285575 is a reply to message #285561]

Wed, 05 December 2007 01:25

varu123
Messages: 754
Registered: October 2007

Senior Member

No i checked with archive log list
Its not the current.
Can i proceed?
I will your link as well

Report message to a moderator

Re: corrupt block header error [message #285591 is a reply to message #285561]

Wed, 05 December 2007 02:01

varu123
Messages: 754
Registered: October 2007

Senior Member

Thanks all,
problem solved.
I checked in v$log it was not archived.
Iused
alter database clear unarchived logfile group "grp_no";
alter database open;
Is there any other precaution i need to take?

Report message to a moderator

Re: corrupt block header error [message #285593 is a reply to message #285591]

Wed, 05 December 2007 02:05

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

"If you clear an unarchived redo log file, you should make another backup of the database."

Take Backup of your database.

Report message to a moderator

Re: corrupt block header error [message #285615 is a reply to message #285561]

Wed, 05 December 2007 02:54

varu123
Messages: 754
Registered: October 2007

Senior Member

Thanks Taj,
If the corrupted log file is current then
alter system switch logfile will not work??
and if DB_BLOCK_CHECKSUM parameter is not set then how oracle determines the corruption in block?

Report message to a moderator

Re: corrupt block header error [message #285619 is a reply to message #285615]

Wed, 05 December 2007 03:00

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Generally speaking, even if db_block_checksum is not set there are tags in the blocks that Oracle check.

Regards
Michel

Report message to a moderator

Re: corrupt block header error [message #285620 is a reply to message #285615]

Wed, 05 December 2007 03:00

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

>alter system switch logfile will not work??
For above command you have to open your database.so it will not work.

>if DB_BLOCK_CHECKSUM parameter is not set then how oracle >determines the corruption in block?
If parameter is set to false then oracle check only system tablespace not user tablespace for block corruption.

http://download.oracle.com/docs/cd/B14117_01/server.101/b10755/initparams038.htm#REFRN10030

Report message to a moderator

Re: corrupt block header error [message #285627 is a reply to message #285561]

Wed, 05 December 2007 03:15

varu123
Messages: 754
Registered: October 2007

Senior Member

Can we calculate checksum from any view or its oracle's internal stuff?
And if the parameter is false,then oracle would check the "tags?"
to verify the blocks and raise error?

Report message to a moderator

Re: corrupt block header error [message #285630 is a reply to message #285627]

Wed, 05 December 2007 03:18

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle ALWAYS checks tags.

Regards
Michel

Report message to a moderator

Previous Topic:	Why dont bind variable use MV.
Next Topic:	Grid concept

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 14:36:28 CDT 2024