Re: Hot Backups or RMAN

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Thu, 20 Feb 2003 01:29:05 -0800
Message-ID: <F001.0055290A.20030220012905@fatcity.com>

If you are using the media management layer (ie rman talks to tape devices) then you can't beat rman.

If rman is just dumping to disk, and these are going to tape manually *and* you only want the most recent backup, then you can't beat rman

If you want to be able to restore from various points in time, and you only keep the most recent on disk, then rman is no worse then hot backup, but not much better.

rman of course does avoid the hassle of redo logs getting hammered...

bottom line (imho): the days where rman was a bucket of crap are long gone. it would be my first choice now for any new db.

hth
\connor

• Ed <esimmonds_at_speakeasy.net> wrote: > I'm sure this topic has come up before. I don't
  > need to know the difference
  > between these backup methods. I am more curious
  > about which is preferred.
  > >From what I can tell, I'd be a fool not to use RMAN
  > whenever possible.
  >
  > What experiences have you all had with these in
  > production environments?
  >
  > Best,
  >
  >
  > Ed
  >
  >
  > .
  >
  >
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.net
  > --
  > Author: Ed
  > INET: esimmonds_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).
  >
  

  ---

Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"

---

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

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).

Received on Thu Feb 20 2003 - 03:29:05 CST