Re: easiest way to backup&recover Oracle?

Hi Howard,

Thanks for your reply. I should have provided more details of my specific situation instead of just saying the "easiest" solution. We are going to have a rather large database on unix. Based on my reading of the oracle doc, it strongly suggests that you use a catalog, which means that I need another database, on another server. argh. Plus your simple backup doesn't include archive logs, or the shell scripts (I'm unix, not Windoz) or any of the other options that are necessary (eg. allocating more then one channel for our large db.)  As for going straight to disk, it won't be practical for us to go to the server disk to hold the backups given the size of our database. That means we are going to be stuck with tape.. god forbid if we have to recover from tape.. GROAN. I was hoping there was something else that I wasn't aware of yet.

So let me re-phrase.. what is the easiest backup and recovery solution given some of the items I mention above?

Thanks again! :-)

"Howard Rogers" <aldeburgh_at_bigpond.com> wrote in message news:<BL1na.15275$1s1.240720_at_newsfeeds.bigpond.com>...
> "Grant" <canuck_tech_at_yahoo.com> wrote in message
> news:5868625b.0304151518.120cecad_at_posting.google.com...
> > Hi,
> >
> > I was wondering what the easiest & best way is to backup and recover
> > our new Oracle 9i database?
>
> RMAN.
>
> >I've taken a look at the oracle recovery
> > manager documentation but it looks like I'd have to code a lot of
> > scripts.
>
> No scripts, no catalog database. Just:
>
> C:\> rman target /
> RMAN> backup database;
>
> Done.
>
> >Our company had a Veritas rep by and their product doesn't
> > look like it removes any of the scripting requirements, plus I'll have
> > to install a bunch of third party drivers, and I'll be relying on
> > tape.. yuck, I have bad memories of tape from my sysadmin days.
>
> Not saying it's exactly state of the art, but do the above to get your
> backup to disk. Then use standard tape backup software (I liked backup exec)
> to archive the stuff off disk. Do until always...repeat.
>
> It is the simplest (and cheapest) way of doing it I know of. No messy
> scripting, no expensive 'oracle agent' options on the tape backup stuff.
>
> Once you've got that under your belt, then RMAN is incredibly rich and
> versatile, and pays investigation. But for starters... RMAN every time.
>
> > Although, I guess I don't have an alternative for our disaster
> > recovery needs...sigh. Are there any better solutions that people
> > like?
>
> Did I mention RMAN??? ;-)
>
> By the way, please don't be tempted to 'borrow' the various O/S backup
> scripts you see dotted around the place. One was posted about here just two
> days ago: God knows what the author was thinking of, but it wasn't
> especially pretty. A lot of them are like that (not saying every one is,
> mind... just be careful).
>
> But I'm one of the rare breed that didn't actually mind RMAN in 8.0. Sort
> of.
>
> Even so, it's *heaps* better in 9i.
>
> Regards
> HJR
>
> (PS, backup and recovery is definitely a 'server' topic, so try to avoid the
> cross-posts in future. It upsets some people here).
Received on Wed Apr 16 2003 - 01:21:29 CDT