I am in the process of implementing backup startegy using rman.Does rman by default compress the backupsets ?if so what would be the compression ratio?if i compress with "backup as compressed backupset" it would be CPU instensive by what means?does this do addition compression on the already compressed backupset which rman does ?Please your Repps will be invaluable.
01-10-2008, 12:14 PM
might help if you put your version on
01-10-2008, 12:26 PM
No RMAN by default doesnt compress backup sets you need to tell it explicitly using the
configure command or using backup up as compressed
Compression ratio varies you need to test it in your specific case
(in my case the compression was 63% to 80% of the original size in some cases but without parallelism ) (it was also 5 times slower in 10gr2 hehe)
Compression would be CPU intensive because the compression algorithm would come into play and has to execute it to make your backups smaller
It would not do additional compression .
RMAN in 11i i have heard is better when it comes to compression .