Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Are offline backups an option, or a neccessity?

Re: Are offline backups an option, or a neccessity?

From: Peter Westby <westby_at_adc.com>
Date: 1997/12/04
Message-ID: <666lms$mei2@mercury.adc.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US