DB Version: 12cR1
OS Version: AIX 6.1
I have a database with TDE tablespace encryption for one of the tablespaces. Database is being backed up using RMAN without any encryption. I am getting the following error while recovering a table from the backup:
RMAN-03002: failure of recover command at 08/23/2014 12:03:56
RMAN-03015: error occurred in stored script Memory Script
ORA-19870: error while restoring backup piece /orabkp/rmanbkp/SVCB_DBFBKUP_220814/level1_5lpgi6pr_1_1_20140822.bkp
ORA-19913: unable to decrypt backup
ORA-28365: wallet is not open
RMAN command being used:
RECOVER TABLE SVCWRK.ADVICE
UNTIL SCN 47846723
AUXILIARY DESTINATION '/orabkp/oracle/recover'
REMAP TABLE 'SVCWRK'.'ADVICE':'ADVICE_DELETED';
ENCRYPTION_WALLET_LOCATION is set in the sqlnet.ora and auto-login wallet is being used.