OraFAQ Forum: Backup & Recovery » ORACLE data block corrupted

Home » RDBMS Server » Backup & Recovery » ORACLE data block corrupted (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLE data block corrupted [message #423866]

Mon, 28 September 2009 16:14

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.

Report message to a moderator

Re: ORACLE data block corrupted [message #423874 is a reply to message #423866]

Mon, 28 September 2009 17:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Metalink has a NOTE on how to handle this situation

Report message to a moderator

Re: ORACLE data block corrupted [message #423875 is a reply to message #423874]

Mon, 28 September 2009 17:38

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.

Report message to a moderator

Re: ORACLE data block corrupted [message #423876 is a reply to message #423875]

Mon, 28 September 2009 18:17

BlackSwan
Messages: 26766
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 17:35:31 CST 2024