DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
  b=RZyblrHEGVcWoVYmwqheFzH8Z/C4NUlF++23LMKzpX4AxfYAocgu2ANPg0gbQmZngzGFzyPf6AhYpUbaZUILPBBM6OPdHcteTjSK501rABsxr6DbkE/7sOR9TyWLq6RutwgRjBbWTMlqJGTn/GzCK+rdmEsrBgdkAkz1BLURuqs=;
Date: Sun, 2 Dec 2007 20:34:22 -0800 (PST)
From: Ahmed kdnl <sulkdnl@yahoo.com>
Subject: Re: Checkpoint in RAC
To: dannorris@dannorris.com, oracle-l@freelists.org
In-Reply-To: <696342.45756.qm@web35413.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1952931110-1196656462=:73554"
Message-ID: <21730.73554.qm@web42108.mail.mud.yahoo.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: sulkdnl@yahoo.com
--0-1952931110-1196656462=:73554
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Thanks Dan for update,
   
  According to my example in the origninal post ,the datafile and control file will have latest SCN which is T2 ,so it has to apply the redo from T2  since T2 is greater than T1.
  Please put some points on it ?
   
  
Dan Norris <dannorris@dannorris.com> wrote:
          Checkpoints are instance events, not database events, so in the case outlined below, instance2 would have to start recovery at the point T1 in instance1's redo logs and recover from there. As you may know, instance recovery incurs a certain amount of time where the GRD is frozen and transactions must wait until it is unfrozen before they can continue. Therefore, the amount of time required for recovery will affect the behavior of the database. Moral of the story: take care to ensure that checkpoints happen often enough to keep that window "short" (as defined by you and your application). 

Someone please correct me if I've gone off the path somewhere.

Hope that helps.

Dan

  ----- Original Message ----
From: Ahmed kdnl <sulkdnl@yahoo.com>
To: oracle-l@freelists.org
Sent: Wednesday, November 28, 2007 1:07:01 AM
Subject: Checkpoint in RAC 

  Hi
   
  Anyone put some points on how checkpoint happening in RAC?
   
  For example intance1 checkpointed at time T1 and instance2 checkpointed at time T2
  Now in case of instance1 failure ,how instanace2 does the recovery of instance1.
  From which checkpoint time, it will read and apply redo,T1 or T2?
   
   
  Thanks in advance
  Syed
  
  
---------------------------------
  Get easy, one-click access to your favorites. Make Yahoo! your homepage. 


---------------------------------
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
--0-1952931110-1196656462=:73554
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div>Thanks Dan for update,</div>  <div>&nbsp;</div>  <div>According to my example in the origninal post&nbsp;,the datafile and control file will have latest SCN which is T2 ,so it has to apply the redo from T2&nbsp; since T2 is greater than T1.</div>  <div>Please put some points on it ?</div>  <div>&nbsp;</div>  <div><BR><BR><B><I>Dan Norris &lt;dannorris@dannorris.com&gt;</I></B> wrote:</div>  <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">  <STYLE type=text/css><!-- DIV {margin:0px;} --></STYLE>    <DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial,helvetica,sans-serif">  <DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial,helvetica,sans-serif">Checkpoints are instance events, not database events, so in the case outlined below, instance2 would have to start recovery at the point T1 in instance1's redo logs and recover from there. As you may know, instance recovery incurs a certain amount of time where the GRD is frozen and
 transactions must wait until it is unfrozen before they can continue. Therefore, the amount of time required for recovery will affect the behavior of the database. Moral of the story: take care to ensure that checkpoints happen often enough to keep that window "short" (as defined by you and your application). <BR><BR>Someone please correct me if I've gone off the path somewhere.<BR><BR>Hope that helps.<BR><BR>Dan<BR><BR>  <DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new   roman,new york,times,serif">----- Original Message ----<BR>From: Ahmed kdnl &lt;sulkdnl@yahoo.com&gt;<BR>To: oracle-l@freelists.org<BR>Sent: Wednesday, November 28, 2007 1:07:01 AM<BR>Subject: Checkpoint in RAC <BR><BR>  <DIV>Hi</DIV>  <DIV>&nbsp;</DIV>  <DIV>Anyone put some points on how checkpoint happening in RAC?</DIV>  <DIV>&nbsp;</DIV>  <DIV>For example intance1 checkpointed at time T1 and instance2 checkpointed at time T2</DIV>  <DIV>Now in case of instance1 failure ,how instanace2 does the
 recovery of instance1.</DIV>  <DIV>From which checkpoint time, it will read and apply redo,T1 or T2?</DIV>  <DIV>&nbsp;</DIV>  <DIV>&nbsp;</DIV>  <DIV>Thanks in advance</DIV>  <DIV>Syed</DIV>  <div></div>  <HR SIZE=1>  Get easy, one-click access to your favorites. <A href="http://us.rd.yahoo.com/evt=51443/*http://www.yahoo.com/r/hs" target=_blank rel=nofollow>Make Yahoo! your homepage.</A> </DIV><BR></DIV></DIV></BLOCKQUOTE><BR><p>&#32;
      <hr size=1>Be a better sports nut! Let your teams follow you 
with Yahoo Mobile. <a href="http://us.rd.yahoo.com/evt=51731/*http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ
">Try it now.</a>
--0-1952931110-1196656462=:73554--
--
http://www.freelists.org/webpage/oracle-l