ORA-28374: typed master key not found in wallet during the database recovery

ORA-28374: typed master key not found in wallet during the database recovery

Error:

TDE error occurred when running database recovery on new host .

RMAN-03002: failure of recover command 

ORA-00283: recovery session canceled due to errors 

RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '+RECO1/BEE/archivelog/2023_05_25/thread_1_seq_456789.396.985083487' 

ORA-00283: recovery session canceled due to errors 

ORA-28374: typed master key not found in wallet 

Solution:

ORA-28374 raised during the restore process suggests that your backup is encrypted and the master key needed for the decryption process is not present in the wallet that is currently in use on the database server where the restore is performed.

On the Source database check the encryption wallet path

Run 

Select * from v$encryption_wallet;

Copy the wallet files from source database to the target database and restart the database in mount stage.

Then start the recovery process on target database.

If you like please follow and comment