Re: Online backup

We've been using online backups for over 2 years now without any problems. We've even recovered databases with them. There are a few gotchas we've run into though. I'm sure you know about the alter tablespace begin backup, os backup, alter tablespace end backup sequence. If for some reason the backup fails while a tablespace is in begin backup mode, remember to perform an alter tablespace end backup, before rerunning your script. Also if for some reason the database crashes (non media failure) while a tablespace is in backup mode, on startup oracle will tell report that the tablespace needs recovery. Don't panic! A startup mount followed by a recover database will recover the database. You don't need to restore any datafiles, etc. Hope this is helpful. Received on Fri Jul 14 1995 - 00:00:00 CEST