My client is interested in introducing Oracle's Advanced Compression capabilities into their 11g landscape. My questions are related to the effects RMAN Compression has on backup infrastructures. I need to understand the impact/reduction in Data Domain or tape that can be expected.
1. What has been the experience with implementing RMAN Compression? Are there any lessons learned you can share?
2. There are three levels of compression -- LOW, MEDIUM & HIGH. What compression ratios have you seen for any/all of these levels?
3. Have you experienced any effects on server performance or any impact on database and backup functionality, when RMAN Compression is running?
Our main purpose for buying this option was OLTP compression. Just by this you can save tons of space(ofcourse it depends upon the type of data).
With RMAN , in maximum compression mode ,your CPU usage will go high so make sure not to schedule the backup with heavy activities on the database.