Re: Datablock Corruption

In article <20000705.4525400_at_p200.nodomain>,   Jerry Gitomer <jgitomer_at_erols.com> wrote:
>
>
>> It depends on what version of Oracle you are running.
>>
>> In your case since you are planning on replacing the drive
 anyway why=20 bother deleting the table?
>

Call it curiousity. I just want to know if oracle marks a bad block permanently once it finds one. I am running 8.0.4.

Cheers
Gordy

>
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
> On 7/3/00, 6:20:14 PM, Gordy <gdsell_at_my-deja.com> wrote regarding
 Re:=20
> 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.
>
>

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


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