Re: Datablock Corruption

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.