APPLIES TO:(Doc ID 1428786.1).
Oracle
Server - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]
Information in this document applies to any
platform.
SYMPTOMS
The following
error is occurring in the alert.log right before the database crashes.
ORA-00600: internal error code, arguments: [4194], [#], [#], [], [], [], [], []
This error indicates that a mismatch has been detected between redo records and
rollback (undo) records.
ARGUMENTS:
Arg [a] - Maximum Undo record number in Undo block
Arg [b] - Undo record number from Redo block
Since we are adding a new undo record to our undo block, we would expect that
the new record number is equal to the maximum record number in the undo block
plus one. Before Oracle can add a new undo record to the undo block it
validates that this is correct. If this validation fails, then an ORA-600
[4194] will be triggered.
CHANGES
This issue generally occurs when there is a power outage or hardware failure that initially crashes the database. On startup, the database does the normal roll forward (redo) and then rollback (undo), this is where the error is generated on the rollback.
CAUSE
This also can be
cause by the following defect
Bug 8240762 Abstract: Undo corruptions with ORA-600 [4193]/ORA-600 [4194] or
ORA-600 [4137] after SHRINK
Details:
Undo corruption may be caused after a shrink and the same undo block may be
used
for two different transactions causing several internal errors like:
ORA-600 [4193] / ORA-600 [4194] for new transactions
ORA-600 [4137] for a transaction rollback
SOLUTION
Best practice to
create a new undo tablespace.
This method includes segment check.
Create pfile from spfile to edit
>create pfile from spfile;
1. Shutdown the instance
2. set the following parameters in the pfile
undo_management = manual
event = '10513 trace name context forever, level 2'
3. >startup restrict pfile=
4. >select tablespace_name, status, segment_name from dba_rollback_segs
where status != 'OFFLINE';
This is critical - we are looking for all undo segments to be offline - System
will always be online.
If any are 'PARTLY AVAILABLE' or 'NEEDS RECOVERY' - Please open an issue with
Oracle Support or update the current SR. There are many options from this
moment and Oracle Support Analyst can offer different solutions for the bad
undo segments.
可以设置参数_corrupted_rollback_segments来解决
If all offline then continue to the next step
5. Create new undo tablespace - example
>create undo tablespace
6. Drop old undo tablespace
>drop tablespace
7. >shutdown immediate;
8 >startup mount;
9 modify the pfile with the new undo tablespace name
>alter system set undo_tablespace = '
10. >shutdown immediate;
11. >startup;
Startup using the normal spfile
================
The reason we create a new undo tablespace first is to use new undo segment
numbers that are higher then the current segments being used. This way
when a transaction goes to do block clean-out the reference to that undo
segment does not exist and continues with the block clean-out.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15747463/viewspace-769471/ ,如需转载,请注明出处,否则将追究法律责任。