Re: easiest way to backup&recover Oracle?

"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 - 03:00:01 CEST