Re: Determine Date of Records Associated With Corrupt Block

From: onedbguru <onedbguru_at_yahoo.com>
Date: Tue, 21 Jun 2011 19:19:33 -0700 (PDT)
Message-ID: <b65fa931-6dc8-41b1-a018-35c1fa95092c_at_a31g2000vbt.googlegroups.com>

On Jun 15, 1:39 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
> Hi,
>
> In a test server we have a corrupt data block in a table that is about
> 17GB in
> size. DBVerify and validate structure both identified the same corrupt
> block.
> (File#f, block #y). Oracle is 10.2.0.4.
>
> That table has a field named DATE, and there is an index on DATE.
>
> Is there a way to use the index in order to identify the date(s)
> of the data that was on the corrupt block?
>
> For example, suppose that DBVerify and Validate Structure
> indicate that file#100, block#99999 is corrupt.
>
> Is there a way to check the value of the date field in index TABLE-
> DATE
> associated with this file/block?
>
> Thanks,
> QZ

If you have an RMAN backup of this database, you CAN restore just the bad block. Received on Tue Jun 21 2011 - 21:19:33 CDT