RE: ORA-01578 data block corrupted

From: Potluri, Venu (CT Appl Suppt) <venu_potluri_at_ml.com>
Date: Tue, 06 Jan 2004 08:24:33 -0800
Message-ID: <F001.005DBDAF.20040106082433@fatcity.com>

Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 7bit

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-----
Sent: Tuesday, January 06, 2004 11:05 AM To: Multiple recipients of list ORACLE-L

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

------_=_NextPart_001_01C3D470.612F42BE
Content-Type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<TITLE>ORA-01578 data block corrupted</TITLE>

<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV>Run dbv on the datafile.</DIV>
<DIV> </DIV>
<DIV>Also there is a document on Metalink which describes how to handle data block corruption.</DIV>
<DIV> </DIV>
<DIV>Use the folliwng query to get segment name</DIV>
<DIV> </DIV>
<DIV>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; </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]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 </DIV> I got ORA-01578 error while querrying info for below table.  How do I fix this error? 
SQL>Select count(*) <FONT

  face=Arial size=2>from GATEWAYCALLSTATS</FONT></SPAN><SPAN 
  lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial 
  size=2>;</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN></P>

* 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'

  <P align=left><SPAN lang=en-us><FONT face=Arial 
  size=2>Thanks,</FONT></SPAN></P>
  <P align=left><SPAN lang=en-us><FONT face=Arial

size=2>David</BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C3D470.612F42BE--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Potluri, Venu (CT Appl Suppt)
  INET: venu_potluri_at_ml.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jan 06 2004 - 10:24:33 CST