Oracle data block corrupation [message #303916] |
Mon, 03 March 2008 05:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|