Re: Determine Date of Records Associated With Corrupt Block

From: joel garry <joel-garry_at_home.com>
Date: Wed, 22 Jun 2011 09:05:09 -0700 (PDT)
Message-ID: <bb40591d-a1b1-4ce1-8687-8f08d265dd72_at_x38g2000pri.googlegroups.com>

On Jun 21, 7:19 pm, onedbguru <onedbg..._at_yahoo.com> wrote:
> 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.

... with the backed up bad block :-O

jg

--
_at_home.com is bogus.
http://www.nytimes.com/2011/06/22/us/22infosys.html

Received on Wed Jun 22 2011 - 11:05:09 CDT