Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Wednesday, November 22, 2017

ORA-19913: unable to decrypt backup

In Oracle Cloud or in 12c using secure backup you will encounter the below error while restore/recovery process..

ORA-19913: unable to decrypt backup

channel ORA_AUX_SBT_TAPE_1: restoring SPFILE
output file name=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/spfileERPPRDSTBY.ora
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2017 19:35:48
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-19849: error while reading backup piece from service erpprd
ORA-19913: unable to decrypt backup
ORA-19660: some files in the backup set could not be verified
ORA-19685: SPFILE could not be verified
ORA-19849: error while reading backup piece from service erpprd
ORA-19913: unable to decrypt backup



RMAN> show ENCRYPTION FOR DATABASE;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ERPPRD are:
CONFIGURE ENCRYPTION FOR DATABASE ON;

RMAN>


RMAN> show ENCRYPTION ALGORITHM;

RMAN configuration parameters for database with db_unique_name ERPPRD are:
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default


Fix:
Either  disable the encryption or set a password or use a wallet

Below I will set a password  for backup and use the same password for decryption.

RMAN>set encryption on identified by 'welcome1';
RMAN> backup database plus archivelog all;


During restore/recovery:

RMAN>set decryption password 'welcome1';
RMAN>restore database ...




No comments: