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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


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]


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

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 ...




2 comments:

Kalpesh Jani said...

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

Kalpesh Jani said...

Correct command is following.

RMAN> set decryption identified by 'Abcd1234';

executing command: SET decryption

RMAN>