My Oracle Support Banner

PDB PITR of encrypted dropped PDB fail with ORA-46680: master keys of the container database must be exported (Doc ID 2507786.1)

Last updated on JUNE 17, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

PDB PITR of dropped encrypted PDb fails

rman target / | tee /home/<PATH>/rman_PDB_restore_1.log
run {
set until scn <>SCN#;
recover pluggable database <PDB NAME>;
}

###############################################################################
Failure Log
################################################################################

media recovery complete, elapsed time: 00:00:02
Finished recover at 27-SEP-18  >>>>>>>>>>>>>>>>>>>>>>>recovery finish successfully

sql statement: alter database open resetlogs  >>>>>>>Open resetlogs finish successfully

sql statement: alter pluggable database <PDB NAME>unplug into ''<$ORACLE_HOME>/dbs/_rm_pdb_pitr_1_xnDE.xml''

Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
auxiliary instance file /<PATH>/dbs/<FILE_NAME>.xml deleted
waiting for ASM instance to release file state object
waiting for ASM instance to release file state object
waiting for ASM instance to release file state object
waiting for ASM instance to release file state object
auxiliary instance file +<DISKGROUP>/<FILE_NAME> deleted
auxiliary instance file +<DISKGROUP>/<FILE_NAME> deleted
auxiliary instance file +<DISKGROUP>/<FILE_NAME> deleted
auxiliary instance file +<DISKGROUP>/<FILE_NAME> deleted
auxiliary instance file +<DISKGROUP>/<FILE_NAME> deleted
auxiliary instance file +<DISKGROUP>/<FILE_NAME> deleted
auxiliary instance file +<DISKGROUP>/<FILE_NAME> deleted
auxiliary instance file +<DISKGROUP>/<FILE_NAME> deleted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/27/2018 18:47:14
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 09/27/2018 18:42:09
RMAN-11003: failure during parse/execution of SQL statement: alter pluggable database <DB_NAME> unplug into '/<PATH>/dbs/<FILE_NAME>.xml'   >>>>>It fails while unplugging the PDB from the automatic auxiliary
ORA-46680: master keys of the container database must be exported

 

Changes

 N/A

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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