This discussion is archived
0 Replies Latest reply: Jun 4, 2013 9:37 AM by SaikatBanerjee RSS

recover 11g datafile with 10g backup

SaikatBanerjee Newbie
Currently Being Moderated
I am upgrading from to

While running catupgrd.sql in test database I found the following error..

ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 44638)
ORA-01110: data file 1: '/u02/oradata/RSDB1/system01.dbf'

I have not taken any backup since it is test.

Can I recover the block by taking backup of production( datafile?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points