deggzy you can rollforward with recover database until cancel backup controlfile option, this would ask you for archive logs until you say cancel, the recovery would stop there and recover until last archive log. I have tried this several times and it works. (with only datafiles and archive log files I was able to recover until latest archive log and open the database. I didnt even have any backup of redologs and controlfiles)
I restored the offline backup. ( datafiles / redo logs / controlfiles )
--> message says no recovery is needed
recover database until cancel using backup controlfile
--> oracle looks at the last archived log in the controlfile, and generates the following filenames until we stop.
No you dont need any control file at all, although it is recomendable to have one (binary or sql like). If you dont have any you could recreate the controlfile and treat it as a backup controlfile.
With recover using backup controlfile Oracle doesnt know which SCN to stop and will only stop until we say so. With recover database command Oracle does know where and when to stop.
The conclusion is as long as we have a backup of datafiles and all archive logs we can recover the database until last archive log. And if we have the online redo logs we can recover until point of failure. Well this is my conclusion :)
this part I lost. when you recover use backup controlfile,
you feed arch.log file one by one until the last archive log
you enter CANCEL to stop the recovery.
then how you "feed" the online redo log? which command
you should use? (if I have online redo log)
hi if you have online redolog you give the redo log name after latest archive log Oracle will treat it as archive logs.
I cant rememebr exactly but I think recover database using backup controlfile with online redo logs will recover until point of failure, I did this about 2 months ago ... :)