Re: Checkpoint in RAC

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_at_yahoo.com> 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>
>

--
http://www.freelists.org/webpage/oracle-l