Re: Backups via RMAN or Shell Script

This is exactly my thoughts. My current backup process is proven (and simple). It takes alot of testing to prove your recovery processes. I guess I'm not sure I want to add the extra complexities of RMAN. Seems like with RMAN your really dependent on the catalog information to recover??? What happens if you lose the catalog?? Seems like RMAN is adding complexity with more things to go wrong during recovry?? With basic HOT backups all you need is a good copy of the archived redo logs and you can recover from about any scenario without the dependency on another utility (like RMAN).

I think that if I was dealing with much larger databases I would need to use RMAN for the "incremental" backup capability. My largest database is only about 5gig and only takes about 10 minutes to do a complete HOT backup.

Mike

In article <f8876.1835$yG3.9539_at_nnrp1.sbc.net>,   "Spencer" <spencerp_at_swbell.net> wrote:
> good question. as for me, i've hesitated to use RMAN,
> primarily because i have not made the time to learn to
> use it. or more specifically, i have not made time to test
> database recovery scenarios using RMAN.
>
> the shell scripts are working fine, and database recovery
> using the backup files has been tested. basically, i'm not
> ready to throw a tried-and-true backup/recovery strategy
> on the scrap heap, just to move to something new.
>
> of course, we are running Oracle 8.0.6, which isn't exactly
> leading edge either. apparently, i'm far enough back from
> the leading edge that i am in danger of falling off the trailing
> edge.
>
> i'm eager to hear what others have to say on the topic.
>
> <mikea730_at_my-deja.com> wrote in message
 news:93islt$pvu$1_at_nnrp1.deja.com...
> > Just wanted to find out how many use RMAN vs. shell scripts to
 automate
> > Oracle Online (HOT) backups. It's been "suggested" that we start
 using
> > RMAN for backups. I use a shell script I wrote that works very
 well,
> > but was wondering if I should think about looking at using RMAN. I
> > wonder what backup method is most used by "seasoned" Oracle DBA's?
 Is
> > the trend moving towards RMAN?
> >
> > Thanks for any info!!
> >
> > Mike
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 11 2001 - 22:18:39 CST