Login  Register

Past image PI In rac

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

Past image PI In rac

satish
1160 posts
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
| More
Print post
Permalink

Re: Past image PI In rac

ErmanArslansOracleBlog
Administrator
5727 posts
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.