The recovery start SCN is common in the first lines because recovery has to read redo from the smallest checkpoint SCN found in controlfile checkpoint progress records (or datafile headers if recovering using backup controlfile option).
And this information is database specific, global to all RAC instances servicing your database, thus all redo threads have to be scanned from the same SCN.
Tanel.
-- -- Original Message -- -- From: Hameed, Amir To: ORACLE-L ; racdba@(protected) Sent: Thursday, January 12, 2006 4:37 PM Subject: Question on RAC user-managed recovery
Folks, I am running some time-based database instance recovery tests in the lab on a three-node RAC environment. The following command was issued from one RAC instance while the others were down. I am trying to understand the way the change number (change 7286467501233) is being displayed on the first line of each of the first three threads below. Why is this number common here? After that, this number is distinct in each subsequent archived log file. I would appreciate if someone can explain/clarify it for me.
Thank you Amir
SQL> recover database until time '2006-01-12:15:20:00' using backup controlfile ORA-00279 (See ORA-00279.ora-code.com): change 7286467501233 generated at 01/11/2006 14:38:59 needed for thread 1 ORA-00289 (See ORA-00289.ora-code.com): suggestion : /u107/oradata/archives/e52rac/log_1_778.dbf ORA-00280 (See ORA-00280.ora-code.com): change 7286467501233 for thread 1 is in sequence #778
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE>Question on RAC user-managed recovery</TITLE> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2900.2802" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT face=Arial size=2>Hi,</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>The recovery start SCN is common in the first lines because recovery has to read redo from the smallest checkpoint SCN found in controlfile checkpoint progress records (or datafile headers if recovering using backup controlfile option).</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>And this information is database specific, global to all RAC instances servicing your database, thus all redo threads have to be scanned from the same SCN.</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2>Tanel.</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <BLOCKQUOTE dir=ltr style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial">-- -- Original Message -- -- </DIV> <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B> <A title=Amir.Hameed@(protected) href="mailto:Amir.Hameed@(protected)">Hameed, Amir</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A title=oracle-l@(protected) href="mailto:oracle-l@(protected)">ORACLE-L</A> ; <A title=racdba@(protected) href="mailto:racdba@(protected)">racdba@(protected)</A> </DIV> <DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, January 12, 2006 4:37 PM</DIV> <DIV style="FONT: 10pt arial"><B>Subject:</B> Question on RAC user-managed recovery</DIV> <DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><BR></DIV> <!-- Converted from text/rtf format --> <P><FONT face="Comic Sans MS" size=2>Folks,</FONT> <BR><FONT face="Comic Sans MS" size=2>I am running some time-based database instance recovery tests in the lab on a three-node RAC environment. The following command was issued from one RAC instance while the others were down. I am trying to understand the way the change number (</FONT><FONT face="Comic Sans MS" size=2>change 7286467501233) is being displayed on the first line of each of the first three threads below. Why is this number common here? After that, this number is distinct in each subsequent archived log file. I would appreciate if someone can explain/clarify it for me.</FONT></P> <P><FONT face="Comic Sans MS" size=2>Thank you</FONT> <BR><FONT face="Comic Sans MS" size=2>Amir</FONT> </P> <P><FONT face="Courier New" size=2>SQL> recover database until time '2006-01-12:15:20:00' using backup controlfile</FONT> <BR><FONT face="Courier New" size=2>ORA-00279 (See ORA-00279.ora-code.com): change 7286467501233 generated at 01/11/2006 14:38:59 needed for thread 1</FONT> <BR><FONT face="Courier New" size=2>ORA-00289 (See ORA-00289.ora-code.com): suggestion : /u107/oradata/archives/e52rac/log_1_778.dbf</FONT> <BR><FONT face="Courier New" size=2>ORA-00280 (See ORA-00280.ora-code.com): change 7286467501233 for thread 1 is in sequence #778</FONT> </P> <P><FONT face="Courier New" size=2>Specify log: {<RET>=suggested | filename | AUTO | CANCEL}</FONT> </P><BR> <P><FONT face="Courier New" size=2>ORA-00279 (See ORA-00279.ora-code.com): change 7286467501233 generated at 01/11/2006 14:38:35 needed for thread 2</FONT> <BR><FONT face="Courier New " size=2>ORA-00289 (See ORA-00289.ora-code.com): suggestion : /u107/oradata/archives/e52rac/log_2_463.dbf</FONT> <BR><FONT face="Courier New" size=2>ORA-00280 (See ORA-00280.ora-code.com): change 7286467501233 for thread 2 is in sequence #463</FONT> </P> <P><FONT face="Courier New" size=2>Specify log: {<RET>=suggested | filename | AUTO | CANCEL}</FONT> </P><BR> <P><FONT face="Courier New" size=2>ORA-00279 (See ORA-00279.ora-code.com): change 7286467501233 generated at 01/11/2006 14:38:37 needed for thread 3</FONT> <BR><FONT face="Courier New " size=2>ORA-00289 (See ORA-00289.ora-code.com): suggestion : /u107/oradata/archives/e52rac/log_3_408.dbf</FONT> <BR><FONT face="Courier New" size=2>ORA-00280 (See ORA-00280.ora-code.com): change 7286467501233 for thread 3 is in sequence #408</FONT> </P> <P><FONT face="Courier New" size=2>Specify log: {<RET>=suggested | filename | AUTO | CANCEL}</FONT> </P><BR> <P><FONT face="Courier New" size=2>Specify log: {<RET>=suggested | filename | AUTO | CANCEL}</FONT> </P> <P><FONT face="Courier New" size=2>ORA-00279 (See ORA-00279.ora-code.com): change 7286467508134 generated at 01/11/2006 14:43:27 needed for thread 2</FONT> <BR><FONT face="Courier New " size=2>ORA-00289 (See ORA-00289.ora-code.com): suggestion : /u107/oradata/archives/e52rac/log_2_464.dbf</FONT> <BR><FONT face="Courier New" size=2>ORA-00280 (See ORA-00280.ora-code.com): change 7286467508134 for thread 2 is in sequence #464</FONT> <BR><FONT face="Courier New" size=2>ORA-00278 (See ORA-00278.ora-code.com): log file '/u107/oradata/archives/e52rac/log_2_463.dbf' no longer needed for this recovery</FONT> <BR><FONT face="Comic Sans MS" size=2>..</FONT> <BR><FONT face="Comic Sans MS" size=2>..</FONT> </P></BLOCKQUOTE></BODY></HTML>
