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:[EMAIL PROTECTED] *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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
