Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01578: ORACLE data block corrupted
ORA-01578: ORACLE data block corrupted [message #289788] Wed, 26 December 2007 02:32 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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?

Re: ORA-01578: ORACLE data block corrupted [message #289960 is a reply to message #289788] Wed, 26 December 2007 22:44 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>How can i resolve it?
Restore from backups.
Previous Topic: urgent help needed...
Next Topic: ORA-02429 / ORA-25188 dance (removing primary key and index)
Goto Forum:
  


Current Time: Sat Dec 03 04:00:46 CST 2016

Total time taken to generate the page: 0.10863 seconds