Error while Duplicate

[Sayid Osman]

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

[ErmanArslansOracleBlog]

check this note:

RMAN RESTORE FAILS WITH RMAN-06023 ALTHOUGH BACKUPS ARE AVAILABLE (Doc ID 965122.1)

[Sayid Osman]

Hello,

I have deleted below entiries in my init.ora and restart all restore procedure but i got same error.

#*.db_recovery_file_dest='<directory>'
#*.db_recovery_file_dest_size=<size>

[ErmanArslansOracleBlog]

You are doing a backup based duplication.
Using "auxilary /" only, you say -> metadata comes from backups

How did you backup this database?
controlfile autobackup was on?
Tell me all the details about this duplicate process.

[Sayid Osman]

I backed up with rman script below and autobackup on


backup as compressed backupset incremental level 0 section size 2G database Tag = 'FULL_dberp';
backup as compressed backupset archivelog all not backed up since time 'sysdate-13/12';
BACKUP SPFILE format '${BACKUP_LOC}/${ORACLE_SID}_${BACKUP_TYPE}_spfile_%U';

[ErmanArslansOracleBlog]

Do your duplicate one more time.
But this time, save the output in a file and upload it here.

Also this time enable debug when connecting to rman, and upload that debug file here as well..
Example: $rman auxilary / debug=ALL log=/u01/app/oracle/rmandebug.txt