Home » SQL & PL/SQL » SQL & PL/SQL » oracle data block
oracle data block [message #246457] Thu, 21 June 2007 01:04 Go to next message
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 #246465 is a reply to message #246457] Thu, 21 June 2007 01:12 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
This is why you do backups
Re: oracle data block [message #246472 is a reply to message #246457] Thu, 21 June 2007 01:20 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: How to caluculate particular characters in a string
Next Topic: can i use multiple LIKE operator in select query
Goto Forum:
  


Current Time: Wed Dec 07 16:39:07 CST 2016

Total time taken to generate the page: 0.09535 seconds