Home » RDBMS Server » Server Administration » Error 600 encountered while recovering transaction (24, 20) (oracle 8,windows 2003 sever)
Error 600 encountered while recovering transaction (24, 20) [message #392210] Tue, 17 March 2009 01:04 Go to next message
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.
Re: Error 600 encountered while recovering transaction (24, 20) [message #392224 is a reply to message #392210] Tue, 17 March 2009 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Error 600 encountered while recovering transaction (24, 20) [message #392455 is a reply to message #392224] Wed, 18 March 2009 01:27 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Error 600 encountered while recovering transaction (24, 20) [message #392505 is a reply to message #392464] Wed, 18 March 2009 04:16 Go to previous messageGo to next message
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



Re: Error 600 encountered while recovering transaction (24, 20) [message #392523 is a reply to message #392505] Wed, 18 March 2009 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Error 600 encountered while recovering transaction (24, 20) [message #392542 is a reply to message #392523] Wed, 18 March 2009 06:05 Go to previous message
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
Previous Topic: Tracking Database Links
Next Topic: Archive from redo log
Goto Forum:
  


Current Time: Sun Dec 04 17:02:56 CST 2016

Total time taken to generate the page: 0.04369 seconds