| oracle data block [message #246457] |
Thu, 21 June 2007 01:04  |
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
|
Senior Member |
|
|
hello all
How we recover data block if data block corrupted.
following are the messages showing while starting oracle.
ORA-0064: ERROR OCCURED AT RECURSIVE SQL LEVEL2
ORA-01578: ORACLE DATA BLOCK CORRUPTED(FILE #1,BLOCK #12119)
ORA-01110: DATA FILE 1:'D:\ORACLE\ORADATA\ORCL\SYSTTEM1.DBF
regards
|
|
|
|
|
|
| Re: oracle data block [message #246472 is a reply to message #246457] |
Thu, 21 June 2007 01:20  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
First: STOP DOING ANYTHING ON YOUR DATABASE.
Switch in quiesce restricted mode (as SYS or SYSTEM):
alter system quiesce restricted
or, if you can't, disconnect all users and switch in restricted mode (alter system enable restricted session).
Try to find which object belongs to the block:
select owner, segment_name, partition_name, segment_type
from dba_extents
where file_id = 1
and 12119 between block_id and block_id+blocks-1
/
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
