OraFAQ Forum: Server Administration » Error 600 encountered while recovering transaction (24, 20)

Home » RDBMS Server » Server Administration » Error 600 encountered while recovering transaction (24, 20) (oracle 8,windows 2003 sever)

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

Error 600 encountered while recovering transaction (24, 20) [message #392210]

Tue, 17 March 2009 01:04

sounderraj.l
Messages: 10
Registered: November 2008
Location: Bangalore

Junior Member

Hi DBA's,

This is raj, i have a problem with my prod database, i am facing rollback segment recovery error in my alertlog file it is repeating for every minute. but still my db is up and running. the error message is

ORACLE Instance orcl (pid = 6) - Error 600 encountered while recovering transaction (24, 20).
Tue Mar 17 11:07:55 2009
Errors in file d:\ORANT\RDBMS80\trace\orclSMON.TRC:
ORA-00600: internal error code, arguments: 4137], [, ], [, ], [, ], [

I am getting this error message from past two days but i restarted the instance with normal shutdown and startup by yesterday evening and my prod database is working fine but still geting this recovery is happening.

SVRMGR> select max(extents) from v$rollstat;
MAX(EXTENT

--------------------------------------------------------------------------------
24467

please help me out to solve this issue..

thanks in advance....

with regards

RAJ DBA.

Report message to a moderator

Re: Error 600 encountered while recovering transaction (24, 20) [message #392224 is a reply to message #392210]

Tue, 17 March 2009 01:38

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

Senior Member
Account Moderator

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel

Report message to a moderator

Re: Error 600 encountered while recovering transaction (24, 20) [message #392455 is a reply to message #392224]

Wed, 18 March 2009 01:27

sounderraj.l
Messages: 10
Registered: November 2008
Location: Bangalore

Junior Member

hello Michle..

Thank u for your reply..
but i went through metalink and i found an article regarding rollback segment corruption

[Edit MC: Metalink note content removed. DO NOT POST COPYRIGHTED DOCUMENT]

here in prod db maxextents is 24467 only..
and all rollback segments are online

so could u pls give me more hints to find the recoverable rollback segments

Thanks in advance..

with regards

RAJ DBA

[Updated on: Wed, 18 March 2009 02:03] by Moderator

Report message to a moderator

Re: Error 600 encountered while recovering transaction (24, 20) [message #392464 is a reply to message #392455]

Wed, 18 March 2009 02:04

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

Senior Member
Account Moderator

I removed the content of Metalink document.
Please give the note number ONLY (which one it was?).

Regards
Michel

Report message to a moderator

Re: Error 600 encountered while recovering transaction (24, 20) [message #392505 is a reply to message #392464]

Wed, 18 March 2009 04:16

sounderraj.l
Messages: 10
Registered: November 2008
Location: Bangalore

Junior Member

dear michle,

these are details i reffered.

Subject: ORA-600[4137]: RUNNING A TRANSACTION
Doc ID: Note:97523.1 Type: PROBLEM

please help me to solve this issue with less down time..

regards

RajDBA

Report message to a moderator

Re: Error 600 encountered while recovering transaction (24, 20) [message #392523 is a reply to message #392505]

Wed, 18 March 2009 04:52

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

Senior Member
Account Moderator

It seems you didn't encounter this bug but another one as you are in the case described in the note.
Contact Oracle.

Regards
Michel

Report message to a moderator

Re: Error 600 encountered while recovering transaction (24, 20) [message #392542 is a reply to message #392523]

Wed, 18 March 2009 06:05

sounderraj.l
Messages: 10
Registered: November 2008
Location: Bangalore

Junior Member

hi michel,

Thank u very much. thanks for spending your most valueable time for me to fix this issuse.

i will contact oracle support.

Regards
RajDBA

Report message to a moderator

Previous Topic:	Tracking Database Links
Next Topic:	Archive from redo log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 03:41:48 CDT 2024