Search This Blog

Thursday, July 28, 2011

ORA-600 [4194] "Undo Record Number Mismatch While Adding Undo Record"


My Signature Article
 
 
 
Today i come across with the following ORA-00600 error on our DEVELOPMENT instance.

As we all knows ORA-00600 = Oracle BUG

but lets find out more about this particular error
 
ERROR:              
  ORA-600 [4194] [a] [b]
 
VERSIONS:           
10.2.0.1.0

DESCRIPTION:

  A mismatch has been detected between Redo records and rollback (Undo) 
  records.

  We are validating the Undo record number relating to the change being 
  applied against the maximum undo record number recorded in the undo block.

  This error is reported when the validation fails.

ARGUMENTS:
  Arg [a] Maximum Undo record number in Undo block
  Arg [b] Undo record number from Redo block

FUNCTIONALITY:      
  Kernel Transaction Undo called from Cache layer
 
IMPACT:             
  PROCESS FAILURE
  POSSIBLE 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.

  If the Known Issues section below does not help in terms of identifying
  a solution, please submit the trace files and alert.log to Oracle
  Support Services for further analysis.

I raised TAR with Oracle Support and they are working on it.

Oracle Metalink Support

No comments: