OraFAQ Forum: Backup & Recovery » Data Block corrupted

Home » RDBMS Server » Backup & Recovery » Data Block corrupted (toad 8.1)

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

Data Block corrupted [message #303857]

Mon, 03 March 2008 00:52

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,
While Acessing the toad the following error occurs

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/MAPLE/system01.dbf'

so pls give me the proper solution for the above said error.

Thanks,

Report message to a moderator

Re: Data Block corrupted [message #303862 is a reply to message #303857]

Mon, 03 March 2008 01:03

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It has been answered and answered and answered many and many times.
Search a little bit.

Regards
Michel

Report message to a moderator

Re: Data Block corrupted [message #303876 is a reply to message #303862]

Mon, 03 March 2008 01:37

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,
I am new to this type of issues can u pls give me the correct solution

Thanks,

Report message to a moderator

Re: Data Block corrupted [message #303880 is a reply to message #303876]

Mon, 03 March 2008 01:54

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://www.orafaq.com/forum/?SQ=68ea660071522b357a7272f94b7239f3&t=search&srch=data+block+corrupted+&btn_submit=Search&am p;field=all&forum_limiter=&search_logic=AND&sort_order=DESC&author=

Report message to a moderator

Re: Data Block corrupted [message #309797 is a reply to message #303857]

Fri, 28 March 2008 19:42

d.c.b.a
Messages: 44
Registered: March 2005
Location: China

Member

Hi:

You can run dbv to check how many blocks are corrupted, if just one or two blocks corrupted, you may use bbed to fix it with Oracle's support.

You can dump this block, to see which objects on this block.

Else you may choose Oracle DUL service or my AUL service to get the data back.

Thanks.

[Updated on: Sat, 29 March 2008 01:33] by Moderator

Report message to a moderator

Re: Data Block corrupted [message #309901 is a reply to message #303857]

Sat, 29 March 2008 13:20

varu123
Messages: 754
Registered: October 2007

Senior Member

Connect to RMAN
RMAN> blockrecover datafile 1 block 97942;

Report message to a moderator

Previous Topic:	How to use flashback to recover Tablespace?
Next Topic:	rman del archivelogs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 18:31:08 CST 2024