cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

Does Netbackup handle TDE differently for Oracle RMAN and MSSQL deduplication

Steve262
Level 3

‎04-05-2019 02:49 AM

We are using TDE ( Transparent Data Encryption ) on Oracle RMAN and MSSQL databases and have noticed that with the Oracle RMAN databases we are getting very low deduplication rates but in MSSQL the dedupe rates are similar to MSSQL databases that don't use TDE.

Does Netabackup handle TDE backups differently for Oracle RMAN and MSSQL, is there a way to get better dedupe rates for Oracle RMAN TDE databases ?

Thanks

Steve

0 Kudos
1 REPLY 1

Nicolai
Moderator
Moderator
Partner    VIP   

‎04-05-2019 07:23 AM - edited ‎04-05-2019 07:31 AM

Encryption does not work well with dedupe. Encryption is "random" (high entropy) , whereas dedupe looks for patterns in data that are similar.

So if encryption is needed, you dedupe first and then encrypt. 

If you  encrypt first and the dedupe, dedupe rate must my nature always be near 0 because of random encrypted data.

0 Kudos