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

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

ERROR:

Format: ORA-600 [4194] [a] [b]

VERSIONS:

versions 6.0 to 10.1

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.

NB Bug Fixed Description

ORA-600 [4194] [a] [b]

Versions: 6.0 - 9.2 Source: ktuc.c

===========================================================================

Meaning:

Undo record number mismatch while adding an undo record to an undo

block. This is done by the application of redo.

---------------------------------------------------------------------------

Argument Description:

a. (ktubhcnt): undo record count - This is the maximum number of undo

records that have ever existed

within this Undo Block. In other

words, it is the High Water Mark for

undo records in that undo block.

This is from the Undo Block.

b. (ktudbrec): redo record number - This is the record number for the

new undo record that is to be added

to the undo block. It should be

one greater than the maximum in the

undo block currently. This is from

the Redo Record.