Past image PI In rac

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Past image PI In rac

satish
Dear erman,

There was limited material on how past image is useful in instance recovery.Can you pls let us know

2node Rac 12.1.0.2

Thanks
Reply | Threaded
Open this post in threaded view
|

Re: Past image PI In rac

ErmanArslansOracleBlog
Administrator
It is basically used in scenarios like the following;

instance A holds a block..
Instance B in the same RAC wants to modify that block.
Instance B receives that block and Instance A keeps a Past Image of the block.
So now suppose -> Instance B crashed while modifying the block. (before writing to disk)
In this case, ORacle is able to build that data block using Past Image.

However, once that block in question is written to disk, the past image won’t be neededed for a crash recovery.