Today we facing the ORA-19913 unable to decrypt backup error during RMAN backup restoration.
After troubleshooting we found, this backup belonged to the encryption-enabled database and there is a wallet also configured.
while backup restoration, open database in nomount state then check wallet status, it is showing closed.
SQL> select status from v$encryption_wallet; STATUS -------------- CLOSED
If the wallet is closed then you can't restore the backup, so for a successful recovery follow the below steps. Exit from SQL prompt.
SQL> exit;
Connect with your production server and copy the wallet configuration files also copy configure in sqlnet.ora, then verify the wallet status again. This time you will see the wallet status is open.
TNS Entry:
$ cat $ORACLE_HOME/network/admin/sqlnet.ora
ENCRYPTION_WALLET_LOCATION =
(SOURCE = (METHOD = FILE)
(METHOD_DATA = (DIRECTORY = /u01/app/oracle/admin/$ORACLE_UNQNAME/wallet)
)
)
Copy wallet files on /u01/app/oracle/admin/$ORACLE_UNQNAME/wallet location carefully.
Now check wallet status:
SQL> select status from v$encryption_wallet; STATUS -------------- OPEN
Sometimes wallet permission is not available, so if the wallet is not open in your case please check your wallet file permission. It should be the same as on the production server.
I hope, this article "ORA-19913 unable to decrypt backup" solves your problem, if yes please write in the comment box, and subscribe to us on YouTube.
Read More:
One thought on “ORA-19913 unable to decrypt backup”