This content has been marked as final. Show 8 replies
using backup controlfile means the controlfile is from a backup, doesn't contain correct SCN info, so Oracle will ignore all SCN info in the controlfile.
Senior Oracle DBA
Can you exaplain in a bit more details. This is still not very clear to me. (Control file backup can be binary or ASCII, can you tell which backup control file type we tell by this using this command?)
Anybody else??? any ideas??
How many details do you require? Should I retype the documentation?
Do you think you can use an ASCII backup to run the RECOVER DATABASE command?
Obviously, you can't!!!!!
If you think you can you should verify this in the documentation. Maybe your boss hits you up for reading the documentation, but that doesn't concern me at all.
I told you 'using backup controlfile' means you tell to Oracle 'Heck, don't trust whatever is written here, as the controlfile I have restored is not the current one, and does NOT contain the correct information, and you shouldn't trust it. And that is all there is to it. If you need 'the detail steps' visit http://tahiti.oracle.com !!!
Senior Oracle DBA
I didn't mean to use the ASCII control file in order to open the database and use in place of a normal control file!, obviously it is not possible (its common sense, and I have it!). By ASCII control file, I meant the text script which is generated by "Alter Database Backup Controlfile To Trace" command, and which is used to create a new control file.
So, my question in my last message was this:
"When we use 'recover database using backup controlfile....' command, do we tell oracle that control file is a new file just created with 'create controlfile ...' script, OR, we tell that the control file is an old binary control file restored from a binary backup? "
Well, using backup controlfile means, umm , binary control file picked up from the backup isn't it?
Pl see the documentation - BACKUP CONTROLFILE means exactly what Sybrand and Aman have stated above
Ok, agreed. But what does recovery process do when we issue this command?, it considers that control file is not valid, so it does not compare SCNs from control file? so how does it stop applying redo logs? and , does it update control file after we finish recovery process?
Check Performing Cancel-Based Incomplete Recovery