Re: Checkpoint in RAC

  • From: "goran bogdanovic" <goran00@xxxxxxxxx>
  • To: sulkdnl@xxxxxxxxx
  • Date: Wed, 28 Nov 2007 10:17:51 +0100

Hi,

I find hard to explain instance recovery in two-three words...so to put it
quite short...
...in rac instance recovery, the redos from multiple threads have to be
merged in order to perform crash or instance recovery. So it looks something
like this:
- in first step, all redo threads are merged by SCN beginning at the last
incremental checkpoint for each thread. On this way a list of blocks (that
are not known to be written to datafiles) is created...called recovery set.
- in second step, SMON reads this merged redo stream and applies the redo
changes to the blocks in recovery set.

This is quite simple presentation what is happening 'behind the scene', so
if you would like to get into more details, check documents on oracle site.

regards,
goran


On Nov 28, 2007 8:07 AM, Ahmed kdnl <sulkdnl@xxxxxxxxx> wrote:

> 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.<http://us.rd.yahoo.com/evt=51443/*http://www.yahoo.com/r/hs>
>

Other related posts: