I am using enterprise Oracle 19CR22 on enterprise linux 7
I am testing rman backup encryption using only the password setting. I set the encryption with the following command:
set encryption on identified by ‘password’ only;
Once the backup is completed, I run the command:
restore database validate check logical;
but this gives me the following error:
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_2: starting validation of datafile backup set
channel ORA_DISK_3: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /oracle-backup/dnt2/dgtstdb/May/28/0/ch2rtvto_401_1_1
channel ORA_DISK_2: reading from backup piece /oracle-backup/dnt2/dgtstdb/May/28/0/cg2rtvto_400_1_1
channel ORA_DISK_3: reading from backup piece /oracle-backup/dnt2/dgtstdb/May/28/0/ci2rtvto_402_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/28/2024 19:21:49
ORA-19870: error while restoring backup piece /oracle-backup/dnt2/dgtstdb/May/28/0/ch2rtvto_401_1_1
ORA-19913: unable to decrypt backup
ORA-28365: wallet is not open
I do not want to use the wallet at this time. Is there a way to pass on the password on the script?
Thanks,
Claudia