Re: Datablock Corruption

From: frog <user_at_email.com>
Date: 2000/07/03
Message-ID: <3960413D.C8DD6EA2@email.com>#1/1

Use dbverify again your last night's backup to find out if any more corruption exists. If running 8i, you can use dbms_repair package for "repairing"; else go through a "messy" export/import to restore that table, along with using dbms_rowid(?) package to locate bad block etc..

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.
Received on Mon Jul 03 2000 - 00:00:00 CDT