Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Are offline backups an option, or a neccessity?
Just my humble view :
Hot Backups are designed to recover tablespaces and/or datafiles. Cold Backups are designed to recover full databases.
The only situation of which I'm aware when a Hot Backup can not be used to fully recover your database is :
o You lose your database datafiles, online redo logs and cntrl files
and have a number of offline redo logs which are still ok. o In this case it is possible to restore the database to it's state
as of the time of the last Hot Backup. However, it is not possible to recover the offline redo log information created since the time the Hot Backup was taken.
This is probably a very rare event. It is more likely that you would lose your offline redo logs as well ( unless your sending an offsite location as they are created. )
If anyone has tested this scenario and has other information about it, I would love to hear it. Received on Thu Dec 04 1997 - 00:00:00 CST