Error When Relocate PDB In 12.2 (Doc ID 2634778.1)

Last updated on JUNE 15, 2021

Applies to:

Symptoms

CREATE PLUGGABLE DATABASE XXXXX FROM XXXXXX@clone_link RELOCATE keystore identified by "xxxxxxx";

Pluggable database created.

SQL> alter pluggable database XXXXXXXXX open instances=all;
alter pluggable database XXXXXXXXX open instances=all
*
ERROR at line 1:
ORA-65107: Error encountered when processing the current task on instance:1
ORA-00283: recovery session canceled due to errors
ORA-28374: typed master key not found in wallet


> alter pluggable database XXXXXXXXX open;
alter pluggable database XXXXXXXXX open
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-28374: typed master key not found in wallet


Alert information:

alter pluggable database XXXXXXXXX open
2019-12-10T12:08:11.536788-03:00
Applying media recovery for pdb-4099 from SCN 73792887 to SCN 73793118
Remote log information: count-2
thr-2, seq-484, logfile-+FRA/C12DWVN/partial_archivelog/2019_12_10/thread_2_seq_484.795.1026648489, los-73594342, nxs-184467440737095
thr-1, seq-487, logfile-+FRA/C12DWVN/partial_archivelog/2019_12_10/thread_1_seq_487.744.1026648491, los-73733256, nxs-184467440737095
XXXXXXXXX(7):Media Recovery Start
2019-12-10T12:08:11.566172-03:00
XXXXXXXXX(7):Serial Media Recovery started
2019-12-10T12:08:11.887687-03:00
(7):WARNING: the following master key for pluggable database 7 tablespace 7 (file # 168) does not exist in the current keystore
(7):Please check if the master key is successfully imported from the source keystore.
(7):kcbtse_populate_tbskey: ena 2 flag f mkloc 1
(7): encrypted key XXXXXXXXXXXXXXXXXXXXXXXXXX00000000000000000000000000000000
(7): mkid XXXXXXXXXXXXXXXXXXXXXXXXXXX

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.