Re: ORA-01578 data block corrupted

if you got rman backup and 9i, you can do block level recovery.

joe

Bobak, Mark wrote:

> 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_at_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: Joe Testa
  INET: oracle-l_at_oracle-dba.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).