Restore/Recovering Backup With Encrypted TBS on Another Database
Kayode, May 26, 2022 - 5:33 pm UTC
Just have following question on your last statement
"- If that file is part of a tablespace that IS encrypted via TDE, then even that its an exact copy, the contents are encrypted (not by RMAN) because they are *already* encrypted by TDE. THis is why RMAN (even with RMAN-level encryption turned on, does not need to apply further encryption, and to do so would serve no benefit)"
What if i need to restore/recovery this backup onto another database, and i know the encrypted key password. What is the process of successfully restoreing/recovering the backup on the databse server
RMAN encryption with Auto-login keystore
DeeCeePee, April 13, 2023 - 4:17 pm UTC
If you configure your auto-login keystore how does that affect encryption of backups(19c)?
Does RMAN encryption need to be set to ON?
Will the auto-login keystore result in all backups being encrypted?
April 18, 2023 - 3:20 am UTC
By default, just having an auto login key store does not enforce backup encryption
You would still need to do:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
or similar