Re: Backup strategy using RMAN

> In the case of only 2% of the blocks having changed since the last
> backup, the writing time will only be 2% of the full backup =>
> incremental backup would be *much* quicker than full backup.
>
> Or what ?

Yap you would have a smaller writing time, but the fact is that with small databases ( in the order of 400Megs ) the time taken with a full backup is 1-2 minutes (resulting backup 300 Megs or so) and the same time takes an inclremental backup producing a file of 20 Megs...weird :)

The reported times are on solaris 6 2xNode cluster with 4 cpus each. The database
reside on logical volumes on sahred disk and the target of the backup iis the local disk of the machine performing the backup...maybe with bigger databases it would change, but i doubt of it. Received on Thu Sep 19 2002 - 04:48:37 CDT