RE: ORA-01578 data block corrupted

[Potluri, Venu (CT Appl Suppt)]

Title: ORA-01578 data block corrupted

Run dbv on the datafile.

 

Also there is a document on Metalink which describes how to handle data block corruption.

 

Use the folliwng query to get segment name

 

SELECT TABLESPACE_NAME, SEGMENT_TYPE, OWNER, SEGMENT_NAME
FROM DBA_EXTENTS
WHERE FILE_ID = '&fileid'
AND '&blockno' BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Nguyen, David M
Sent: Tuesday, January 06, 2004 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-01578 data block corrupted

I got ORA-01578 error while querrying info for below table.  How do I fix this error?

SQL>Select count(*) from GATEWAYCALLSTATS;

     *

ERROR at line 2:

ORA-01578: ORACLE data block corrupted (file # 3, block # 2683299)

ORA-01110: data file 3: '/apps/oracle/oradata/SIDB/rtesvr01.dbf'

Thanks,

David