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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).