I did test Rman backup sizing using Compressed backupset, Backupset and Backup as Copy:
These are the results:
Detailed results can be seen here Rman Sizes per Backup Type
Compressed backupset show in my test 88.3 % of compression.
That compression level enable moving medium sized databases to remote servers using scp/ftp much faster.
Still you need to take into account that compression is expensive in terms of CPU, you need to find the correct moment to execute this kind of backup to avoid interfering with online/batch work.
Comments (4)
HyperBac for Oracle (Oracle backup accelerator software) will allow you to do RMAN Image Copy operations with integrated compression (and encryption) as well as compressed RMAN backupsets, EXP and EXPDP operations (something that cannot be done normally).
Also HyperBac compressed RMAN operations are much faster than Oracle 10g compressed backup operations (and use much less CPU), worth a look...
Posted by Jeffrey Aven | March 22, 2007 7:32 PM
Posted on March 22, 2007 19:32
Hi Alejandro.
Whats compressed backup scripts used in this tests?
Whats your recommended restore/recovery compressed backup scripts?
ARF
Posted by Anderson Rodrigo Farias | March 23, 2007 8:22 AM
Posted on March 23, 2007 08:22
Could you please also post the time it took to run each backup ?
Posted by Tobias | March 23, 2007 12:59 PM
Posted on March 23, 2007 12:59
Alejandro, I feel this is a good idea. We are using legato media management layer and RMAN(to tape) at my current client's site. Im wondering if your benchmarks were done on a vanilla database or on a more realistic client database with real data. The compression would depend a lot on the amount of free or white space in the DB, would it not? What are your thoughts on this ?
Posted by Gaurav Verma | March 31, 2007 4:18 PM
Posted on March 31, 2007 16:18