RE: ORA-01578 data block corrupted

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 06 Jan 2004 08:19:25 -0800
Message-ID: <F001.005DBDAC.20040106081925@fatcity.com>

Message

1.) Restore datafile from backup.

2.) recover datafile;

3.) voila!

Of course, you mileage may vary. Do you have a valid backup? Is it hot or cold? RMAN/conventional? etc,etc....

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown

-----Original Message-----
From: Nguyen, David M [mailto:david.m.nguyen@xo.com]
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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: Mark.Bobak_at_il.proquest.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:19:25 CST