| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Online vs offline backups
I once heard someone actually say 'For peace of mind, perform a monthly cold
backup'. My opinion is that this is the biggest load of crap I have ever
heard. If your backup, or more importantly, your recovery strategy has been
tested, there is zero NEED for a cold backup, as you can fully recover just
as easily from a hot backup. The same person that advocated a cold backup
did not back up the online redo logs, so what use was it anyway, since the
only way they would force open their DB is with a resetlogs option anyway.
Think people, think ! Sometimes it really is not rocket science but just pure common sense based on some elementary knowledge.
Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
Only Robinson Crusoe had all his work done by Friday
-----Original Message-----
Sent: Tuesday, 18 June 2002 3:59 PM
To: Multiple recipients of list ORACLE-L
If you create a new database and do a full online backup (this also includes
future regular full online backups) is it ever necessary to do a full
offline
backup? I have heard conflicting answers, regarding this and am looking for
some clarification. Don't 24x7 applications always have to execute offline
backups? Are offline backups done for peace of mind, and if yes why? What
issues are introduced if only offline backups are issued. In addition, we
are
using BMCs Sql BackTrack product and I am not sure if it is a requirement of
the tool that an offline backup be periodically performed. If you know that
as
well, please share. Thanks everybody
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: tracy.rahmlow_at_aexp.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ferenc Mantfeld
INET: fmantfeld_at_siebel.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jun 19 2002 - 07:03:27 CDT
 |
 |