| Corrupt Rollback segments - ORA-00600 [4193] [669] [686] [message #122606] |
Tue, 07 June 2005 10:27  |
chandrasekhar200
Messages: 5
Registered: March 2005
Location: none
|
Junior Member |
 
|
|
Hi all,
When I try to install a build on a linux RH 7.3 system, I receive this ORA-00600 error. Here's the exact error.
**********************************
SQL> drop table <Table_name>
*
ERROR at line 1:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [669], [686], [], [], [],
[], []
**********************************
I want to know if dropping the rollback segments would do it. Also, how do I know which rollback segment is corrupt? Though I'm not a DBA, its my rear end if this is not fixed. So please help. I am not able to access my main test site.
Thanks in advance.
|
|
|
|
|
|
| Re: Corrupt Rollback segments - ORA-00600 [4193] [669] [686] [message #122642 is a reply to message #122606] |
Tue, 07 June 2005 13:23  |
skempins
Messages: 16
Registered: June 2005
Location: Florida
|
Junior Member |
|
|
Oracle says this error is a mismatch between Redo records and Rollback records. The only suggestions given is that there may be rollback segment corruption and a recovery from database backup may be required.
What do you mean when you say "...not able to access my main test site"? Is the database still running and accessable? What version of Oracle are you using?
Also, is this a repeatable error - or was this a one time thing?
|
|
|
|
|
|
| Re: Corrupt Rollback segments - ORA-00600 [4193] [669] [686] [message #122911 is a reply to message #122606] |
Thu, 09 June 2005 03:20 |
nabeelkhan
Messages: 73
Registered: May 2005
Location: Kuwait
|
Member |
|
|
Whenever an ORA-600 error is raised a trace file is generated in either USER_DUMP_DEST or BACKGROUND_DUMP_DEST depending on whether the error was caught in a user or a background process. The error is also written in the alert log and so is the name of the trace file. The trace file contains vital information about what led to the error condition.
DESCRIPTION: A mismatch has been detected between Redo records and Rollback (Undo) records. We are validating the Undo block sequence number in the undo block against the Redo block sequence number relating to the change being applied.
This error is reported when this validation fails.
ARGUMENTS: Arg [a] Undo record seq number Arg [b] Redo record seq number
FUNCTIONALITY:
KERNEL TRANSACTION UNDO
IMPACT:
PROCESS FAILURE
OSSIBLE ROLLBACK SEGMENT CORRUPTION
SUGGESTIONS:
This error may indicate a rollback segment corruption.
This may require a recovery from a database backup depending on the situation.
For further analysis, please submit the trace files and alert.log to Oracle Support Services.
Log a TAR
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
