emcmagic

updated

12 years ago

E

emcmagic

2 Intern

•

211 Posts

0

1229

March 22nd, 2015 15:00

If using DD deduplication, should Oracle compression be enabled?

We are using Oracle RMAN back up data to DD. It was said not to enable Oracle compression, if using DD deduplication.

Is that true? and why?

Thanks!

  • PatrickBetts

    1 Rookie

    •

    116 Posts

    799

    1

    Posted March 23rd, 2015 10:00

    emcmagic,

    Dynamox is correct:

    https://support.emc.com/docu47194_Oracle-RMAN-Best-Practices-with-Data-Domain.pdf?language=en_US

    Page 13:

    Compression

    RMAN provides two types of compression. All supported versions of RMAN can apply a lossless compression algorithm (BZIP2) to the data being written to the backupset. This results in less disk space being used at the cost of significantly greater CPU consumption during the backup operation than the alternate compression type. When using a Data Domain system as the target, RMAN lossless compression SHOULD NOT be used. Pre-compression of the backup streams will randomize the data patterns and reduce deduplication significantly.

  • dynamox

    11 Legend

    •

    20419 Posts

    •

    87439 Points

    799

    1

    Posted March 22nd, 2015 15:00

    True, see DD/ Oracle best practices white paper.