Concept of Current image of a block in Oracle RAC.
YasuFeb 10 2009 — edited Feb 15 2009Hi All,
While going through Oracle RAC concepts i was bit confused about internals of current image.
In 2 node cluster of Oracle 10g version:
1. Instance 1 starts modifying block A by acquiring Exclusive lock on that block.
2. Instance 2 request current block of A for acuring exclusive lock.
3. Instance 1 downgrades Exclusive lock and creates PI of block A and sends current block to Instance 2.
My doubt is:
1. In instance 1 block A headers ITL slot will show transaction is not commited and how come Instance will transfer this block A to Instance 2 along with
un-commited transaction ?
2. What will happen to transaction in Instance 1 which is modifying Block A while transferring it to Instance 2 ?
-Yasser