Re: Datablock Corruption

Gordy 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.

Its in the SYSTEM tablespace ... not good

Under certain conditions this can be very bad - ie requiring a database rebuild. Possible try looking at repairing the error with DBMS_REPAIR, or seeing what is in error (using DBA_EXTENTS)...With some luck you could be able to export the whole database

Also - generally you don't want any objects that are not the data dictionary in the SYSTEM tablespace...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse