Re: Datablock Corruption

Thanks to everybody that replied.

I have now run dbverf80 on all my datafiles and determined that the only corruption was in the system tablespace.

I have also found Disk error message in the event viewer(under NT) which has confirmed that the disk is at fault. I am in the process of finding another disk as we speak. In the meantime I have made export backups of the database and the database is still up and running.

The reason the table ended up in the system tablespace was because an import process went awry. It is lucky that I do not need the table so I can delete it.

Question: If I delete the table which has the corruption(If I can), does oracle know to mark that block as corrupted and not use it again? I don't want oracle to try to reuse that data block with something important if I delete the table.

Thanks again
Gordy

In article <8jr41u$8bc$1_at_nnrp1.deja.com>,   yong321_at_yahoo.com wrote:
> In article <8jorvb$l02$1_at_nnrp1.deja.com>,
> Gordy <gdsell_at_my-deja.com> wrote:
> > Hi there,
> >
> > I have just run the following command with the following results.
> >
> > ANALYZE TABLE LBBKSEC ESTIMATE STATISTICS
> > *
> > ERROR at line 1:
> > ORA-01578: ORACLE data block corrupted (file # 1, block # 81058)
> > ORA-01110: data file 1: 'D:\ORANT\DATABASE\SYS1STN3.ORA'
> >
> > Does anybody have a script to find out if any more corruption exists
> > and does anyone have a recommended course of action apart from
> > last nights backup....?
> >
> > Cheers
> > Gordon
> >
> > --
> > Gordy
> > ICQ 3290116
> > http://www.geocities.com/Area51/Cavern/4253
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> You can dbv (or dbverify depending on OS) on datafiles, preferably
 when
> the corresponding tablespace is offline to reduce false
> positive/negative.
>
> I once had a data block corruption error. Turned out to be harddrive
> not installed correctly. When it was installed right, everything was
> back normal.
>
> --
> Yong Huang
>
> (yong321_at_yahoo.com)
> (http://www.stormloader.com/yonghuang/)
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Gordy
ICQ 3290116
http://www.geocities.com/Area51/Cavern/4253


Sent via Deja.com http://www.deja.com/
Before you buy.