Home » RDBMS Server » Backup & Recovery » Oracle data block corrupation (oracle10g LINUX)
Oracle data block corrupation [message #303916] Mon, 03 March 2008 05:13 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,
I got error in oracle like

ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 97942)
ORA-01110: data file 1: '/opt/oracle/oradata/michael/system01.dbf'

I searched the google i found some point...

I execueted below query

select owner, segment_name, partition_name, segment_type
from dba_extents
where file_id = 1
and 97942 between block_id and block_id+blocks-1;

i got output like

OWNER SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE
------------------------------ ------------------
SYS C_OBJ#_INTCOL# CLUSTER

How to drop this cluster?


Re: Oracle data block corrupation [message #303923 is a reply to message #303916] Mon, 03 March 2008 05:31 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Try to restore and recover the database from a valid backup.
If you can't or don't have, export the database and create a new one.

Regards
Michel
Previous Topic: recover database with out redo and controlfiles
Next Topic: RMAN backup tablepspace then drop table
Goto Forum:
  


Current Time: Sat Dec 10 10:41:20 CST 2016

Total time taken to generate the page: 0.26917 seconds