Instance recovery

[Satish]

Dear erman,

Please let us know how CONTROLFILE_CHANGE# from  v$database used  in crash recovery?

Thank you

[ErmanArslansOracleBlog]

Look, I didn't test it, but probably it is used to determine if you are recovering your database by using a backup controlfile..

That is; if you want to recover your database to a scn or point, which is later/before the control file change#/scn, then oracle will consider that you are using a backup controlfile and it will ask you to specify  "using backup controlfile" clause on your recovery command.