If oracle online database backup is in-progress and there's a instance restart due to switch-over of a fail-over cluster...do i need to perform a new round of online database backup again or can i use the "old" online backup copy and perhaps do something about it to bring it updated ??
You will have to re-backup the tablespace which was being backed-up and all other tablespace that are yet to be backed-up. You can still use the backup of tablespaces that have been successfully completed before instance shutdown.
do u mean that if its like the scenario i mentioned..after the oracle instance restarted..database definitely wont be able to open is it ?? so u hv to end the online backup of the tablespace(that was interrupted) first correct???
Yes, pando thats the way to do it, but from experience you need to backup the whole database again to have a consistent backup and make it easy for you if you end up in a restore/recovery situation. You know how it tends to be when this situation occurs, managers hanging all over the place trying to speed the process up!
Real experts gets the fact before stating that they are 100% shure!
well this only happened to me once and what I did is what i posted so if we have to talk about experience on this kind of situation mine is little however from theoretical view i dont see why I should backup whole database again if I was doing backup tablespace after tablespace. If it crashes I simply start backing up my last tablespace again since I have all the archived logs I dont see what can go wrong if I have to recover anything later?