Re: Datablock Corruption

        It depends on what version of Oracle you are running.

        In your case since you are planning on replacing the drive anyway why bother deleting the table?

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 7/3/00, 6:20:14 PM, Gordy <gdsell_at_my-deja.com> wrote regarding 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 exis
 ts
> > > 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.
Received on Wed Jul 05 2000 - 00:00:00 CDT