Instance recovery

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

Instance recovery

Satish
Dear erman,

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

Thank you
Reply | Threaded
Open this post in threaded view
|

Re: Instance recovery

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