which process updates controlfile, when doing complete recovery of it?
Posted by Pavan DBA on October 12, 2010
Long back i posted a voting question in my blog…
which process updates controlfile, when doing complete recovery of it?
I got results as follows
But unfortunately max votes got for a incorrect option. The correct answer is Server process.
Many DBA’s don’t know that we can perform complete recovery when we lost controlfile. (even i had some good argument with a friend on my blog on this)
If you want to know how to do complete recovery, see below link
https://pavandba.wordpress.com/2010/03/18/how-to-do-complete-recovery-if-controlfiles-are-lost/
By reading above post, you might have got the point that we are creating new controlfile. In such cases, to open the database we require latest SCN to be there in controlfile to match it with datafiles and redolog files.
If it doesn’t match, it will fail to open. So server process will take that responsibility to update the controlfile with latest SCN and this info will be taken from datafiles
Pavan DBA's Blog 
Leave a Reply