Got to see some interesting discussion on SCN number over OTN Forum.Below is the posted question
” I want some light on instance and media recivery in context of SCN no
How the following nos in v$database behaves and correlate each other for doing instance & media recovery. How oracle knows and correlate with this info for doing recovery.
cols from v$database:
For more read the thread http://forums.oracle.com/forums/thread.jspa?threadID=966985&start=0&tstart=0
Also, if want know more about scn have a look at http://forums.oracle.com/forums/thread.jspa?forumID=61&threadID=832226