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
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 ...
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
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 ...
2 comments:
I am not sure how you can run the command but that is not RMAN command.
$ORACLE_HOME/bin/rman auxiliary /
Recovery Manager: Release 12.2.0.1.0 - Production on Tue Aug 21 10:03:38 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: LIMS2PRD (not mounted)
RMAN> set decryption password 'Abcd1234';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "password": expecting one of: "identified, wallet"
RMAN-01007: at line 1 column 16 file: standard input
Correct command is following.
RMAN> set decryption identified by 'Abcd1234';
executing command: SET decryption
RMAN>
Post a Comment