Does anybody know if RMAN can compress data when you backup to disk? For example, if I use RMAN to backup to tape, my tape device will take care of the compression. If I backup to disk, there is no compression used.
RMAN does not compress data when you backup to disk.
It only does a compression in a way that only non-empty data blocks are copied and the rest is compressed.
Jeff, this is from the Oracle documentation. You probably have read it though ...
"Some media management products can compress data. Real-world experience shows that software compression does not help improve local backup performance. It helps only if the data is transferred over a slow network."
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
Click Here to Expand Forum to Full Width