Home » RDBMS Server » Backup & Recovery » ORACLE data block corrupted (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)
ORACLE data block corrupted [message #423866] Mon, 28 September 2009 16:14 Go to next message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
Hi,

Someone dropped our database with drop database statement.
We restored data from backup and than recored. As I know database gets full backup on friday night and gets incremental backup everyday. Data before friday has no error but after friday on all of our tables we get following error. Our tables are created with no logging option. is there a way to save the corrupted data.

ORA-12801: error signaled in parallel query server P019
ORA-01578: ORACLE data block corrupted (file # 90, block # 1397865)
ORA-01110: data file 90: '/data4/oradata/NIDB/TEMP_NORTHI15.dbf'

Note : when i run

SELECT ne_id, data_date
FROM CELL_STATISTICS

i get no error.

When I run

SELECT *
FROM CELL_STATISTICS

I get error.

Thanks in advance.
Regards.
Re: ORACLE data block corrupted [message #423874 is a reply to message #423866] Mon, 28 September 2009 17:07 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Metalink has a NOTE on how to handle this situation
Re: ORACLE data block corrupted [message #423875 is a reply to message #423874] Mon, 28 September 2009 17:38 Go to previous messageGo to next message
vesile_taskiran
Messages: 66
Registered: August 2008
Location: Turkey
Member
i searched on google but i couldnt find a solution i just found answer for not to face this problem. well i faced with the problem. What shoul I do now.
Re: ORACLE data block corrupted [message #423876 is a reply to message #423875] Mon, 28 September 2009 18:17 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

which says to SEARCH forum before posting!


http://www.orafaq.com/search?keys="data%20block%20corrupted"


http://www.orafaq.com/forum/?SQ=a421a8d0b77c0058508c40de71040625&t=search&srch="data+block+corrupted"&btn_submit=Search&field=all&forum_limiter=1&search_logic=AND&sort_order=DESC&author=

[Updated on: Mon, 28 September 2009 23:25] by Moderator

Report message to a moderator

Previous Topic: Database got shutdown due to shortest storage in OS
Next Topic: relationship between different instance in RMAN
Goto Forum:
  


Current Time: Sun Dec 04 02:54:58 CST 2016

Total time taken to generate the page: 0.10157 seconds