| 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.
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
