As a CYA move we actually do a once a month cold level 0 UFSDUMP backups.
Why do we do such a "rediculous" activity?
We did it so we could take this set of tapes to any site running
Solaris & have a decent chance to successfully restore of DB.
Otherwise we'd require a site which is running a close enough version
of Legato to restore from the more frequent backup tapes managed by
Legato. I'll acknowledge that this approach is not perfect, but when
you don't have a honest Disaster Recovery site; you do the best you can.
Ferenc Mantfeld wrote:
>
> 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
INET: charliem_at_mwh.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:48:19 CDT
