Re: Bad Block ORA-00600

How do you figure out the values in point (b) ?

If this is correct, there are two tests I would try on a backup copy of the database;

1. Drop rollback segments with US# = 7 and overwrite it, then see what happens
2. Start the database with init.ora holding _corrupted_rollback_segments = 'name of rollback segment'

    This tells oracle to assume any ITLs holding     references to the undo segment should be assumed     committed, and this may clear the problem.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Brian Rankin wrote in message ...


>Hello,

>

>I'm running Oracle 8.1.7 with Oracle Portal; there's a bad block in

>the TAB$ table. Background:

>

>a) The following error is being listed every few minutes in the alert

>log:

>ORA-00600: internal error code, arguments: [4142], [20992194], [], [],

>[], [],

>[], [].

>b) This means that transaction USN 7 slot# 84 on database object ID 4

>is bad;

>c) The object for ID 4:

>

>select owner,object_id, object_name, object_type from

>dba_objects where object_id = 4;

>

>OWNER OBJECT_ID

>------------------------------ ----------

>OBJECT_NAME

>---------------------------------------------------------------------------

-----


>OBJECT_TYPE

>------------------

>SYS 4

>TAB$

>TABLE

>

>d) This error has been occuring since January; backups aren't

>available for this database that far back.  I've tried to drop the

>TAB$ table on a mirror server, but can't. Portal operations hasn't

>been affected thus far...Help!