PITR of Pluggable database failing with RMAN-6556 or RMAN-05556

(Doc ID 2154844.1)

Last updated on JULY 05, 2016

Applies to:

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


The Point in Time recovery of Pluggable Database  is failing with the following error :


RMAN> run
set until sequence=1000 thread=2;
restore pluggable database PDBTEST1;
recover pluggable database PDBTEST2;



RMAN-06162: sql statement: alter database mount clone database
Removing automatic instance
RMAN-06225: shutting down automatic instance
RMAN-06402: Oracle instance shut down
RMAN-06226: Automatic instance removed
RMAN-06407: auxiliary instance file +RECO/PDBTEST1/DATAFILE/current.1307.903364165 deleted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/09/2016 14:30:02
RMAN-06556: datafile +DATA_DBM1/PDBTEST1/1232131D9194319E053A8C914ACB5E7/DATAFILE/datafilex.407.898093815 must be restored from backup older than SCN 4838612147


Other errors that might be encountered


RMAN-03002: failure of Duplicate Db command at 02/09/2016 14:11:52
RMAN-05501: aborting duplication of target database
RMAN-05556: not all datafiles have backups that can be recovered to SCN 15721911
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 67 found to restore



The PITR  error is being reported for a database that was created as a  clone   via SQL*Plus :

source = PDB1
target = PDB2
open PDB1 read only;

SQL> create pluggable database PDB2 from PDB1;

 This issue appears when source database (PDB1)  has transportable datafiles and then the new clone PDB2 is bringing the information.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms