ORA-01578: ORACLE data block corrupted [message #289788] |
Wed, 26 December 2007 02:32  |
sundarfaq
Messages: 235 Registered: October 2007 Location: Chennai
|
Senior Member |
|
|
Hi,
I got error during the drop the employees tables.
ORA-00604: error occurred at recursive SQL level 2
ORA-01578: ORACLE data block corrupted (file # 1, block # 69914)
ORA-01110: data file 1: '/opt/oracle/oradata/michael/system01.dbf'
How can i resolve this issues?
Thanks,
Michael
|
|
|
Re: ORA-01578: ORACLE data block corrupted [message #289790 is a reply to message #289788] |
Wed, 26 December 2007 02:35   |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |

|
|
>How can i resolve this issues?
First search ORA-1578 error no. on forms and google.
then restore/recover your corrupted block.
for instance:
ORA-01578: ORACLE data block corrupted (file # string, block # string)
Cause: The data block indicated was corrupted, mostly due to software errors.
Action: Try to restore the segment containing the block indicated. This may involve dropping the segment and recreating it. If there is a trace file, report the errors in it to your ORACLE representative.
also read...
http://www.fors.com/orasupp/rdbms/dba/28814_1.HTM
and if you have metalink access then check it...
https://metalink.oracle.com/metalink/plsql/f?p=130:14:5394508269011813640::::p14_database_id,p14_docid,p14_show_header,p14_show_help, p14_black_frame,p14_font:NOT,28814.1,1,1,1,helvetica
[Updated on: Wed, 26 December 2007 02:44] Report message to a moderator
|
|
|
Re: ORA-01578: ORACLE data block corrupted [message #289959 is a reply to message #289788] |
Wed, 26 December 2007 22:40   |
sundarfaq
Messages: 235 Registered: October 2007 Location: Chennai
|
Senior Member |
|
|
hi,
I got same error during the execution of this query.
select tablespace_name, segment_type, owner, segment_name
from dba_extents
where file_id = 1
and 69914 between block_id AND block_id + blocks-1;
error Messages:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 69914)
ORA-01110: data file 1: '/opt/oracle/oradata/STOCK/system01.dbf'
How can i resolve it?
|
|
|
|