Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_REPAIR, 8.1.7

Re: DBMS_REPAIR, 8.1.7

From: John Oakes <john_at_networkproductions.net>
Date: Sun, 23 Nov 2003 06:26:39 GMT
Message-ID: <zqYvb.27269$M31.625393@twister.tampabay.rr.com>


"Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> wrote in message news:bth0svoa2a05bkhtpq40qbr13ctitmu1tv_at_4ax.com...
> On Sun, 23 Nov 2003 04:24:02 GMT, "John Oakes"
> <john_at_networkproductions.net> wrote:
>
> >Ok, I was able to find the corrupted blocks succesfully. But now, I want
to
> >use DBMS_REPAIR.FIX_CORRUPT_BLOCKS to mark them as bad, and I am getting:
> >
> >DECLARE num_fix INT;
> >*
> >ERROR at line 1:
> >ORA-00600: internal error code, arguments: [kdrp_chkblk_1], [0], [], [],
[],
> >[], [], []
> >ORA-06512: at "SYS.DBMS_REPAIR", line 287
> >ORA-06512: at line 4
> >
> >Any ideas? Thanks!
>
>
> ora-600 ----------> CALL SUPPORT

Thanks, I have located the exact bug that causes this (found it in Metalink), it is number 2021123. According to the description it is fixed in product version 10.0. I'm not familiar with the Oracle versions, if I upgrade from 8.1.7.0 to 8.1.7.4 is this version 10? What does version 10 relate to? Thanks!

-John

>
>
> --
> Sybrand Bakker, Senior Oracle DBA
>
Received on Sun Nov 23 2003 - 00:26:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US