Error while Duplicate

Posted by Sayid Osman on Aug 21, 2017; 1:52pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Error-while-Duplicate-tp3274.html

Hello Erman,

I got error when i try to duplicate from backup. I am trying to clone my live database to PREPROD. I have executed following command and after 2 hours i got following error. Could you please help me ?


  rman auxiliary /

                    RMAN> duplicate target database to "PREPROD" BACKUP LOCATION  '/u01/yedek/dberp' NOFILENAMECHECK;


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/16/2017 10:54:52
RMAN-05501: aborting duplication of target database
RMAN-05556: not all datafiles have backups that can be recovered to SCN 6025953137863
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 407 found to restore
RMAN-06023: no backup or copy of datafile 403 found to restore
RMAN-06023: no backup or copy of datafile 399 found to restore
RMAN-06023: no backup or copy of datafile 354 found to restore
RMAN-06023: no backup or copy of datafile 314 found to restore
RMAN-06023: no backup or copy of datafile 288 found to restore
RMAN-06023: no backup or copy of datafile 34 found to restore
RMAN-06023: no backup or copy of datafile 32 found to restore
RMAN-06023: no backup or copy of datafile 31 found to restore
RMAN-06023: no backup or copy of datafile 29 found to restore
RMAN-06023: no backup or copy of datafile 26 found to restore
RMAN-06023: no backup or copy of datafile 24 found to restore
RMAN-06023: no backup or copy of datafile 22 found to restore
RMAN-06023: no backup or copy of datafile 20 found to restore
RMAN-06023: no backup or copy of datafile 19 found to restore
RMAN-06023: no backup or copy of datafile 17 found to restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 13 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore



When i check backup from live database. It seems backup files are correct

RMAN> list backup of datafile 407;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18216   Incr 0  2.13G      DISK        00:04:33     15-AUG-17      
        BP Key: 101415   Status: AVAILABLE  Compressed: YES  Tag: FULL_DBERP
        Piece Name: /yedek/backup/full/dberp/dberp_FULL_5tsc0fqr_1_1_rman
  List of Datafiles in backup set 18216
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  407  0  Incr 6026021529966 15-AUG-17 +DATAERP/dberpsby2/datafile/apps_ts_seed.286.914421991