Re: easiest way to backup&recover Oracle?
Date: 15 Apr 2003 23:21:29 -0700
Message-ID: <5868625b.0304152221.6f260b5f_at_posting.google.com>
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
"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 - 08:21:29 CEST