Any RMAN backups as backup sets can be encrypted. However, image copy backups cannot be encrypted. Encrypted backups are decrypted automatically during restore and recover operations, as long as the required decryption keys are available, by means of either a user-supplied password or the Oracle Encryption Wallet.
How do I know if my RMAN backup is encrypted?
By querying the v$rman_encryption_algorithms view, a list of RMAN encryption algorithms can be obtained:
- SQL> select. ...
- RMAN> show encryption algorithm; RMAN configuration parameters are: ...
- RMAN> configure encryption algorithm clear; ...
- RMAN> show all; ...
- RMAN> configure encryption for database clear;
Are Oracle backups encrypted?
Oracle Secure Backup encrypts the backup data unless it has already been encrypted by RMAN.
