Tuesday 9 January 2024

How to Resolve Control file Restoration Error ORA-19913: unable to decrypt backup ORA-28365: wallet is not open

Important Note: If you are using oracle wallet you may stock in restoration of control file procedure.

###  RESTORE CONTROLFILE ###

$ rman target /

RMAN > restore controlfile from '/backup/stage/bkp_ctl.ctl';

### ERROR ###

channel ORA_DISK_1: restoring control file

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 11/23/2023 15:22:44

ORA-19870: error while restoring backup piece /backup/stage/bkp_ctl.ctl

ORA-19913: unable to decrypt backup

ORA-28365: wallet is not open


### SOLUTION ###

$ cd /u01/app/oracle

$ cp -Rf wallet_for_12c wallet

### EDIT sqlnet_ifile.ora ###

$ cd /u01/app/oracle/product/12.1.0/db_1/network/admin/PROD_erpenv001

$ vi sqlnet_ifile.ora

ENCRYPTION_WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = /u01/app/oracle/wallet/$ORACLE_SID))

$ sqlplus / as sysdba

SQL> alter system set encryption wallet open identified by "133#Rd2q#dW#dC4";

System altered.

### NOW RESTORE CONTROLFILE AGAIN ###

$ rman target /

RMAN> restore controlfile from '/backup/stage/bkp_ctl.ctl';

Starting restore at 23-NOV-23

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=3 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:03

output file name=/u01/oracle/fur/apps_st/data/cntrl_01.dbf

output file name=/u01/oracle/fur/apps_st/data/cntrl_02.dbf

output file name=/u01/oracle/fur/apps_st/data/cntrl_03.dbf

Finished restore at 23-NOV-23

$ exit 

$ sqlplus / as sysdba

SQL> alter database mount;

Note : After performed above mentioned step you able to catalog your backupset and restore of your datafile from backupset.

No comments:

Post a Comment