How does Oracle RMAN treat encrypted data?
Table B: Oracle Transparent Data Encryption and Oracle RMAN Application data Backup with RMAN compression Backup with RMAN encryption Backup with RMAN compression and encryption Not encrypted Data compressed Data encrypted Data compressed first, then encrypted Encrypted with TDE column encryption Data compressed; encrypted columns are treated as if they were not encrypted Data encrypted; double encryption of encrypted columns Data compressed first, then encrypted; encrypted columns are treated as if they were not encrypted; double encryption of encrypted columns Encrypted with TDE tablespace encryption Encrypted tablespaces are decrypted, compressed, and re-encrypted Encrypted tablespaces are passed through to the backup unchanged Encrypted tablespaces are decrypted, compressed, and re-encrypted Example for ‘transparent’ encryption [and compression] when the local TDE master encryption key is available: RMAN> connect target
