| Oracle data block corrupation [message #303916] |
Mon, 03 March 2008 05:13  |
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  |
 |
Michel Cadot
Messages: 68651
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
