Re: using rman

From: Igor <imerku_at_acegas.ts.it>
Date: Wed, 08 Jan 2003 10:47:00 +0100
Message-ID: <avgs2k$2clj$1@half.spin.it>

Karsten Farrell wrote:

Hi Karsten,

>> do with db with 200, 500, 1000 GB? One disk? What about CEO that just
>> 

> Don't forget that one of the nicer features of rman is that it won't
> backup all those empty Oracle blocks found in lots of datafiles. Your
This really is a good feature I have forgotten about. In fact, I need to copy all the datafiles, used or not.

> You can also perform incremental backups in rman ... something you can't
> do in a shell script.

But as Holger wrote, incremental refers to the last successful complete backup, right?!

> which would require an increased amount of redo generated by your 3
> lines of code.

Right, but at least up to now, four years with increasing db, we had no problem with this. But might get a problem in the future, thanks for the hint.

> You can also adjust performance with rman by running in parallel or by
> multiplexing i/o. You can even throttle rman i/o so it doesn't adversely
> impact o/s i/o.

In fact, this is something I have not yet implemented with my script ;-)

> By the way, I use shell scripts for all my backups ... but hey, I've got
> the dream DBA job ... small database (after the terabyte ones in my
> previous job) ... script takes only 15 minutes for full backup of our
> prod db ... minimal DBA intervention required ... more disk space than I
> need ... time to read the docs.

Cool, do you have any "dream sysadmin job" vacant? ;-)

A last question, please allow: Did you use rman with the terabyte db's?

Have a very nice day,
Best regards,
Igor Received on Wed Jan 08 2003 - 03:47:00 CST