RE: Backup Strategy - Informal Survey

Nat

    Just a plug for always testing your backups, regardless of whether you are doing hot or cold. We do cold backups, and we test them from time to time by restoring them on a test system so the developers have some data to test against. Several times over the years we've found that a file was being skipped on the backup due to an oversight on the people side, or some other issue that developed over time and impacted the backup process. Right now I am both using RMAN and cold backups simply because I haven't had time to complete the qualification process to finally say absolutely that our RMAN backups will recover us from any situation. Just that this has been a lower priority than all the other tasks.

 
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----Original Message-----
Sent: Friday, September 20, 2002 12:52 PM To: Multiple recipients of list ORACLE-L

No we do trust our hot backups. Our databases are mostly idle during early ours of Sunday between 12 AM - 1 AM.
So we thought lets go for a cold backup on weekends. ----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, September 20, 2002 12:28 PM

> On Fri, 20 Sep 2002, Nat wrote:
>
> > We use EMC/EDM bcv splits to do a hot backup every night. We shutdown
our
> > database once a week for half an hour for cold bcv splits. So far it has
> > worked very well.
>
> Just curious, why do you do a cold backup weekly? Do you not trust
> your hot backups?
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> > ----- Original Message -----
> >
> > > I'd like to pose a question to you all and get your response. If you
are
> > > running a database that is larger than 250GB, what place in your
backup
> > > strategy does a logical export have? Do you do logical exports at all,
and
> > > if so with what frequency? Do you feel that logical exports are an
> > important
> > > part of your backup/recovery strategy?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeremiah Wilton
> INET: jwilton_at_speakeasy.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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: Nat
  INET: Nat2710_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).