Re: OS Backup versus RMAN

From: joel garry <joel-garry_at_home.com>
Date: Fri, 15 Aug 2008 11:05:32 -0700 (PDT)
Message-ID: <37acf809-669c-4abc-8341-99a6033afb7b@u6g2000prc.googlegroups.com>


On Aug 14, 5:34 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Does anybody know where I could find a time comparison between an operating
> system backup and an RMAN backup?
>
> Thanks.

It depends. Besides what Dan noted, there are split window backups, which are very short, unless you include resilvering time. Besides those, OS backups can really slow down your system, as tablespaces in hot backup mode generate more overhead, RMAN is smarter about fractured blocks. Not an issue if you have downtime windows. But who has those these days with Oracle being so smart it has to work all hours figuring out if you need to defragmodulate your frappuccinerrio?

RMAN also has a lot of management smarts you (and even big companies) will never catch up to with OS backups. Even small sites can benefit from catalog these days.

Simply comparing speed of backups is like comparing speed of table scans between database engines. It's just plain misleading with any multiuser real world system. There's a reason it's called Recovery MANager - recovery is the important part.

jg

--
@home.com is bogus.
What happens when the custom stuff stops working: http://blogs.zdnet.com/BTL/?p=9676
Received on Fri Aug 15 2008 - 13:05:32 CDT

Original text of this message