Re: using rman

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Tue, 07 Jan 2003 15:21:00 +0100
Message-ID: <3E1AE24C.8000805@science-computing.de>

Comments embedded.

Best regards,

Holger

Igor wrote:
> Detlef Jockheck wrote:
>
>

>>Hi,
>>
>>I want to use rman (first time). Is there a short description available
>>what I need to do to make a backup with rman?
>>

>
>
> Hallo Detlef, einen schoenen guten Tag,
>
> IMHO: don't.
> IMHO you better write a shell script that does all the work "by hand", that
> is a hot backup of your db onto direct attached tape or via storage manager
> software (like Archserve, Tivoli Storage Manager or else).
> Have you considered, that for using rman you have to run another db (the db
> for rman). Have you considered, that rman db has to be backed up, too? So,

You don't need a second db, rman can track everything in the target databases controlfile - but only for a limited time. And besides, the OP said he wanted to use rman, but not for how many databases it will be used. And if your storage vendor supports Oracle, you even can write to tape directly if that's needed. Considering todays hd prices you better throw in an additional disk just for the backups and use it as primary backup target (which will speed up backup as well).

> why backup two db's (instead of one), use an interface tool, when you can
> do it with a script where you EXACTLY know what it does?

Because with rman you know EXACTLY what it does (if you read the manual at least), and as Krzystof Marciniak showed in his reply, the rman script will be amazingly short.

>
> Right, I am not saying the product does not work or is bad. All I say is,
> that there is another slice of software between I consider not really
> necessary.

The shell script you propose will be much more complex and take much more time to develop - putting tablespaces in and out off backup mode, making sure you don't miss a datafile and so on. IMHO: that's an effort not really necessary.

>
> Consider ...

Exactly :-)

>
> Have a nice day,
> Best regards,
> Igor
>
Received on Tue Jan 07 2003 - 08:21:00 CST