Re: Backup trends (2): HOT or COLD

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:icis6054es6soc1vmgpep9jbs2l5qifdsb_at_4ax.com...
> On Sat, 03 Apr 2004 00:33:47 GMT, "Bob Jones" <email_at_me.not> wrote:
>
> >
> >"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> >news:iu7r60pn591202gj49596rvg82s32qr7gq_at_4ax.com...
> >> On Fri, 2 Apr 2004 07:37:30 +0000 (UTC), Lucyna Witkowska
> >> <ypwitkow_at_nospamcyf-kr.edu.pl> wrote:
> >>
> >> >Sorry, I made a stupid version error and discussion "went to raspberry
> >> >bushes" (as we say in Poland).
> >> >So I try again. ;-)
> >> >Oracle 8.1.7.2 (version supported by the application developer).
> >> >Is there any admin (8.1.7.2, 8.1.7.4) that rely only on RMAN warm
> >backups?
> >> >
> >> >Greetings,
> >> >Lucyna Witkowska
> >>
> >> Sure, why not.
> >> RMAN is much more stable than any home grown korn shell script.
> >> For some time I'm trying to get the home grown scripts out of the
> >> window. They are too inflexible and many of them require maintenance
> >> when datafiles are added. RMAN doesn't need that.
> >>
> >>
> >> --
> >> Sybrand Bakker, Senior Oracle DBA
> >
> >I have to disagree. We have been using shell scripts to backup for years
and
> >never have any problem. They do not require maintenance if datafiles are
> >added. I have never used RMAN. Does it backup files with OS copy, or
Oracle
> >special commands to backup only the data not the empty space in the data
> >files? I would consider RMAN only if the later is true.
> >
> No one can forbid you to stay where you are. But usually somewhere
> there will the moment you come out of your cave and you feel like
> Catweazle, the wizard transported from the Mediaeval Age to the 70s.
>
> And yes, Oracle RMAN doesn't backup the empty space, and yes it does
> do incremental backup's, and yes, it is capable of recovering corrupt
> blocks only, and yes it does support backup administration for
> purposes of retention policy etc, etc, etc. Your 'scripts' have that
> all build in? Guess not.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

It's nice to have all those features, but those were not what I disagreed with earlier. It was related to stability and maintenance requirement of shell scripts.
Thank you for pointing them out though. Received on Sat Apr 03 2004 - 12:41:29 CST