Re: Block Corruption in empty pages in Oracle 11g

From: The Boss <nltaal_at_baasbovenbaas.demon.nl>
Date: Tue, 17 Aug 2010 05:18:10 -0700 (PDT)
Message-ID: <e501bee4-7131-423d-ac01-97ecfce39525_at_5g2000yqz.googlegroups.com>

On Aug 17, 6:08 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
> On Aug 15, 8:41 pm, ddf <orat..._at_msn.com> wrote:
>
>
>
>
>
> > On Aug 15, 11:30 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
>
> > > On Aug 14, 11:51 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:> On Aug 14, 2:57 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
>
> > > > > On Fri, 13 Aug 2010 21:32:32 -0700, zigzagdna wrote:
> > > > > > Can some one explain following ooutput from dbv;
>
> > > > > Have you tried the documentation?
> > > > > --http://mgogala.byethost5.com
>
> > > > Yes,  I have read the documentation. Based on the documenation; my
> > > > block corruption is in unused blocks; i.e.; thes eblocks are not being
> > > > used by current data and indexes. But, I get errors when doing delete
> > > > or truncate; so documentaion is not correct or dbv is provding
> > > > incorret information.
>
> > > Based on documentaion, I cannot figure out
> > > Questions remain why corrupt table I can do:
> > > 1. select without error.
> > > 2. insert without error
> > > 2. but truncare gives error
> > > 3. delete of all the rows gives error; one may be able to delete some
> > > rows; but do not know which ones.
>
> > > So either dbv output is misleading or I do not unserstand what does it
> > > mean?
>
> > Have you given thought to using the DBMS_REPAIR package to either fix
> > or skip these corrupt blocks?  You can read here:
>
> >http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/repair...
>
> > to provide a step-by-step method for using the package in situations
> > such as yours.
>
> > David Fitzjarrell- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks a lot for your respose. For some reason dbms_repair packacge
> does not do what is suppoed to do. In my many years of dba caeer;
> first time I am encountering block corruption to my surpise I fouud
> dbms_repair packacge does not work. I had posted problem with
> dbms_repair in a forum in Oarcle General News Grop on technet and no
> one could
> tell me why dbms_repai doe snot work.

May be you should consider repairing your keyboard first? ...

--
Jeroen

Received on Tue Aug 17 2010 - 07:18:10 CDT