Duplicate fails with no copy of datafile nnn found to restore

oraclerman

I've duplicated our production to our UAT environment several times in the past but due to various reason, this time has been a serious PITA.
Oracle 11.2.0.3.
We have a recovery catalog setup. This is the script thats run on the UAT box:

connect catalog rman/cat@rc  
connect auxiliary /  
run {  
ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;  
ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;  
ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;  
ALLOCATE AUXILIARY CHANNEL aux4 DEVICE TYPE DISK;  


duplicate database RACDB01 to GVPUAT skip tablespace  
TS_ADMIN2,TS_ERROR_ERRORLOG,...
<big list of tablespaces I don't care about>...,RADSS_WG_INDEX_LARGE   
NOFILENAMECHECK until time "to_date('2016-03-02 00:00:00','YYYY-MM-DD HH24:MI:SS')";

The problem is it errors with RMAN-06023: no backup or copy of datafile 352 found to restore. This is because on 03/01/2016 I added a datafile to production. A backup was started on production at 12pm, I added a datafile at 6 pm, and the backup finished at roughly 11pm. How can I use that backup?

Best Answer

Try just backing up the tablespace for the new datafile. Then as long as you have all of the archive logs that were generated since the last backup, your clone should work.

Related Question