Re: RE: Backup Strategy

From: Gene Sais <gsais_at_co.palm-beach.fl.us>
Date: Thu, 04 Oct 2001 16:25:05 -0700
Message-ID: <F001.003A2BBE.20011004163518@fatcity.com>

>>> satarnag_at_yahoo.com 10/04/01 18:26 PM >>>
1. If you can afford to lose data from the time of the last backup, then you are right. However, I even put those databases on 24x7 mode whenever possible because (1) Developers, like DBAs, work strange hours in the night and day and would probally like to have access to the database. (2) You never had a developer be pissed off at you because you couldn't restore one table without having to wipe out all the work he or jack did earlier today. (3) How can you truely test a 24x7 application on a non 24x7 Oracle database when now the SGA differs between the two machines?

>>> I do cold backups of dev & test db's daily to disk. also do export backups for
>object restores.

2. I am a strong believer of the KISS philosophy as well, you guys haven't seen my users! This, however, should not apply to us as DBAs whose job is to know DBA related commands

Regards,
Satar

• Gene Sais <Gsais_at_co.palm-beach.fl.us> wrote:
  > I see 2 advantages of cold over hot backups:
  >
  > 1) Archive log mode not required for cold backups.
  > Dev & Test DB's do not need archive space.
  >
  > 2) Cold backups follow the KISS principle. Shutdown
  > db, tar, dump, cpio, dd, etc. the datafiles, redo
  > logs, ctl files, oracle filesystems, etc. to tape,
  > Startup db, Done. Take the tape to same or another
  > server and restore, No Oracle cmds required
  > (filesystems being the same). Now for Hot Backups,
  > we have to add a step. Not a big step :) We need
  > the arcs and need to recover the db.
  >
  > Gene
  > * Still not convinced backing up closed files are
  > not safer/better than open files :) *
  >
  > >>> <Jared.Still_at_radisys.com> 10/04/01 04:59PM >>>
  >
  >
  > OK, I'll bite, what OS commands?
  >
  > As for cold backps, and I'm sure you've heard this
  > already, they're only
  > really needed after you open a database with
  > 'resetlogs' . Otherwise it
  > is not necessary to use a cold backup.
  >
  > Jared
  >
  >
  

  ---

Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: satar naghshineh
  INET: satarnag_at_yahoo.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: Gene Sais
  INET: gsais_at_co.palm-beach.fl.us

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 Thu Oct 04 2001 - 18:25:05 CDT