Re: IOT table index got corrupted with no backup of table
From: joel garry <joel-garry_at_home.com>
Date: Thu, 10 Sep 2009 09:30:04 -0700 (PDT)
Message-ID: <0cd5a9d2-b3a0-49dd-a6fe-ea7a073f8340_at_m7g2000prd.googlegroups.com>
On Sep 9, 10:58 pm, "aman.oracle.dba" <aman.oracle...._at_gmail.com> wrote:
> Hi All,
>
> IOT table in our database env. got corrupted in last december. Now
> some people want to use old archive data from this table. But there is
> corruption in its index (Physical - 17, Logical - 180, no. of
> datafiles - 60, size of index - 111GB). We don't have this old backup,
> so we can't recover it from that.
>
> We have already tested DBMS_REPAIR, BLOCKRECOVER - RMAN, exp/imp but
> nothing it working...
>
> Can any one please give suggest.
> is there any way we can recover uncorrupted data from this table ?
>
> Thanks
Date: Thu, 10 Sep 2009 09:30:04 -0700 (PDT)
Message-ID: <0cd5a9d2-b3a0-49dd-a6fe-ea7a073f8340_at_m7g2000prd.googlegroups.com>
On Sep 9, 10:58 pm, "aman.oracle.dba" <aman.oracle...._at_gmail.com> wrote:
> Hi All,
>
> IOT table in our database env. got corrupted in last december. Now
> some people want to use old archive data from this table. But there is
> corruption in its index (Physical - 17, Logical - 180, no. of
> datafiles - 60, size of index - 111GB). We don't have this old backup,
> so we can't recover it from that.
>
> We have already tested DBMS_REPAIR, BLOCKRECOVER - RMAN, exp/imp but
> nothing it working...
>
> Can any one please give suggest.
> is there any way we can recover uncorrupted data from this table ?
>
> Thanks
See metalink Note: 61685.1
Figure out the rowid's of the corrupt blocks and skip them.
jg
-- _at_home.com is bogus. Give a man a fish you feed him for a day. Teach a man to fish and you've fed him for life. Mass-market fish and you have a series of ecological disasters: http://www3.signonsandiego.com/stories/2009/sep/10/homely-tasty-fish-eye-controversy/?uniontribReceived on Thu Sep 10 2009 - 11:30:04 CDT