Bad Block ORA-00600

From: Brian Rankin <brankin_at_enbonline.net>
Date: 18 Apr 2002 10:55:24 -0700
Message-ID: <fc0674ce.0204180955.3a94ad4d@posting.google.com>

Hello,

I'm running Oracle 8.1.7 with Oracle Portal; there's a bad block in the TAB$ table. Background:

1. The following error is being listed every few minutes in the alert log: ORA-00600: internal error code, arguments: [4142], [20992194], [], [], [], [], [], [].
2. This means that transaction USN 7 slot# 84 on database object ID 4 is bad;
3. 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! Received on Thu Apr 18 2002 - 12:55:24 CDT