Re: Backups via RMAN or Shell Script

I'm not going to pretend to speak as a seasoned DBA, but I use RMAN and would recommend it to anyone over shell scripts. RMAN has a lot of features that are impossible to get from a shell script. With RMAN you can check for both logical and physical block corruption during backups, perform incremental backups, use either the controlfile to store information about backups or a catalog. There have been horror stories regarding RMAN and how difficult it is to set up but I think a lot of this is due to experiences people had with EBU (RMANs predeccessor). Oh, I almost forgot, the biggest reason to use RMAN over shell scripts is that you don't have to put your tablespaces in hot backup mode.

In article <93islt$pvu$1_at_nnrp1.deja.com>,   mikea730_at_my-deja.com wrote:
> 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 Wed Jan 10 2001 - 18:10:42 CST