Re: Oracle logging and recovery

soley_at_trop32.enet.dec.com (Norm Soley - Global Village Idiot) writes:
> It's not clear here whether your system manager is backing up files
> while the database is shut down. File backups of database files on a live
> database are not possible except in combination with archive log mode.

Of course they are possible. They are just not recommended! You have to back up ALL files at the same time. Then restore ALL the files at the same time (otherwise you may get into a situation where the control file is out of date, and the documentation is even wronger than usual). Think of it - if that weren't the case, you would never be able to bring oracle back up after a system crash. The important thing is to not have transactions occur during the backup.

--
"See your System Administrator?" I *AM* the #%_at_!?& System Administrator!

INTERNET: tumidity_at_netlink.cts.com (Joel Garry) 
UUCP:  ...!ryptyde!netlink!tumidity