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
Hi,
I am upgrading from 10.2.0.5 to 11.2.0.3


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(10.2.0.5) datafile?

Legend

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