Home » RDBMS Server » Backup & Recovery » Data Block corrupted (toad 8.1)
Data Block corrupted [message #303857] Mon, 03 March 2008 00:52 Go to next message
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,
Re: Data Block corrupted [message #303862 is a reply to message #303857] Mon, 03 March 2008 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It has been answered and answered and answered many and many times.
Search a little bit.

Regards
Michel
Re: Data Block corrupted [message #303876 is a reply to message #303862] Mon, 03 March 2008 01:37 Go to previous messageGo to next message
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,
Re: Data Block corrupted [message #303880 is a reply to message #303876] Mon, 03 March 2008 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
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=
Re: Data Block corrupted [message #309797 is a reply to message #303857] Fri, 28 March 2008 19:42 Go to previous messageGo to next message
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 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Connect to RMAN
RMAN> blockrecover datafile 1 block 97942;
Previous Topic: How to use flashback to recover Tablespace?
Next Topic: rman del archivelogs
Goto Forum:
  


Current Time: Sun Dec 11 02:37:45 CST 2016

Total time taken to generate the page: 0.03952 seconds