The Oracle documentation says that if the unrecoverable_change# for a datafile reported (v$datafile) by the primary is greater than that reported by the standby then you will need to recover that datafile (by copying it over from the primary) in order to avoid block corruption errors if the standby is activated.
Does this also hold if the unrecoverable_change# are identical?
have a good day,
Josh C.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.2800.1515" name=GENERATOR></HEAD> <BODY> <DIV><SPAN class=513324921-15112005><FONT face=Arial size=2>Greetings,</FONT></SPAN></DIV> <DIV><SPAN class=513324921-15112005><FONT face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN class=513324921-15112005><FONT face=Arial size=2>The Oracle documentation says that if the unrecoverable_change# for a datafile reported (v$datafile) by the primary is greater than that reported by the standby then you will need to recover that datafile (by copying it over from the primary) in order to avoid block corruption errors if the standby is activated. </FONT></SPAN></DIV> <DIV><SPAN class=513324921-15112005><FONT face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN class=513324921-15112005><FONT face=Arial size=2>Does this also hold if the unrecoverable_change# are identical? </FONT></SPAN></DIV> <DIV><SPAN class=513324921-15112005><FONT face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN class=513324921-15112005><FONT face=Arial size=2>have a good day,</FONT></SPAN></DIV> <DIV><SPAN class=513324921-15112005><FONT face=Arial size=2></FONT></SPAN> </DIV> <DIV><SPAN class=513324921-15112005><FONT face=Arial size=2>Josh C. </FONT></SPAN></DIV></BODY></HTML>
