- 3,723,348 Users
- 2,244,533 Discussions
- 7,850,425 Comments
Forum Stats
Discussions
Categories
- Industry Applications
- 3.2K Intelligent Advisor
- Insurance
- 1.5K On-Premises Infrastructure
- 519 Analytics Software
- 41 Application Development Software
- 1.8K Cloud Platform
- 700.5K Database Software
- 17.5K Enterprise Manager
- 18 Hardware
- 255 Infrastructure Software
- 132 Integration
- 66 Security Software
rman backups encryption password

We are running oracle 18c and CC 13c. We don't need TDE encryption for any internal data items and only use it for RMAN backups. We want to run backups in OEM and encrypt them using a password and not a TDE wallet. I see how I can add the password when I create the job in OEM by going to the Database in OEM and then to Availability then Backup & Recovery and Schedule Backup. Then I notice that when I see the rman script it creates it shows
set encryption on for all tablespaces algorithm 'AES256' identified by '%PASSWORD' only;
That all works just fine. What happens if I want to schedule 'Restore Database Validate' in an RMAN script in OEM to verify the backup works? I would like to not have to put the password in cleartext in an RMAN job in OEM Library. Can I put in an RMAN job like this?
set decryption identified by '%PASSWORD'
Restore Database Validate
Is there a better way to validate those backup files are all fine via OEM if a password is used for encryption instead of the TDE wallet.
Answers
-
Are you suing RMAN Catalog ?
-
-
Hello,
I think i would say to check in test environment first, we have also migrated the backup cron jobs to oem but we are not using any encryption.
Prashant