Re: Checkpoint in RAC

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@xxxxxxxxxxxxx> 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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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.

Other related posts: