RMAN Backup Fails with ORA-19914 In ExaCC

Today’s we have received the following alert from commvault backup report that one of out configured database backup was failing with the below error

"RMAN Script execution failed with error [ORA-19914: unable to encrypt backup]. Please check the Logs for more details. "

We started digging down with the status of the encryption wallet on the cdb database and it looks fine .

select wrl_parameter, wallet_type, status FROM gv$encryption_wallet; /var/opt/oracle/dbas_acfs/db_name/tde_wallet/       PASSWORD              OPEN /var/opt/oracle/dbas_acfs/db_name/tde_wallet/        PASSWORD             OPEN

But , when we set the pdb$seed database and checked the status of wallet at pdb level it was failing

SQL> alter session set container=PDB$SEED ;

WRL_PARAMETER                                      WALLET_TYPE          STATUS

————————————————– ——————– ——————————

                                                                        UNKNOWN              CLOSED

                                                                        UNKNOWN              CLOSED

This issue happens if the pdb$seed wallet was opened before the key was set for the ROOT, as we do not refresh pdb$seed’s wallet context on ROOT’s rekey. So, in this case the key for the pdb$seed is not found.

A simple solution to this problem, close and open the wallet at both cdb level and individually at pdb$seed level .

At cdb level

SQL> administer key management set keystore close identified by Password;

SQL> administer key management set keystore open identified by Password container = all;

At pdb$seel level

SQL> alter session set container=PDB$SEED ;

SQL> administer key management set keystore open identified by Password;

SQL> SELECT wrl_parameter, wallet_type, status FROM gv$encryption_wallet;

WRL_PARAMETER                                      WALLET_TYPE          STATUS

————————————————– ——————– ——————————

                                                                       PASSWORD             OPEN

                                                                       PASSWORD             OPEN

 788 total views,  2 views today