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