RMAN: specification does not match any datafile copy in the repository

We copied one file from production Exadata to standby Exadata:

$ rman target / auxiliary sys@DWH_STB

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 21 14:26:52 2017

connected to target database: SPUR (DBID=496990843)
auxiliary database Password:
connected to auxiliary database: SPUR (DBID=496990843)

RMAN> run
2> {
3> allocate           channel prmy01 type disk PARMS="BLKSIZE=10485760";
4> allocate           channel prmy02 type disk PARMS="BLKSIZE=10485760";
5> allocate auxiliary channel stby01 type disk PARMS="BLKSIZE=10485760";
6> allocate auxiliary channel stby02 type disk PARMS="BLKSIZE=10485760";
7> backup as copy
8> datafile 790 auxiliary format '+RECOC1'
9> datafile 824 auxiliary format '+RECOC1'
10> ;
11> }

using target database control file instead of recovery catalog
allocated channel: prmy01
channel prmy01: SID=3035 device type=DISK

allocated channel: prmy02
channel prmy02: SID=53 device type=DISK

allocated channel: stby01
channel stby01: SID=509 device type=DISK

allocated channel: stby02
channel stby02: SID=762 device type=DISK

Starting backup at 21-09-2017 14:28:07
channel prmy01: starting datafile copy
input datafile file number=00790 name=+DATAC1/SPUR/DATAFILE/p2_proxy_log_2017.1088.937456961
channel prmy02: starting datafile copy
input datafile file number=00824 name=+DATAC1/SPUR/DATAFILE/p2_proxy_log_2017.517.937459103
output file name=+RECOC1/SPURSTB/DATAFILE/p2_proxy_log_2017.980.955290489 tag=TAG20170921T142807
channel prmy02: datafile copy complete, elapsed time: 00:02:45
output file name=+RECOC1/SPURSTB/DATAFILE/p2_proxy_log_2017.701.955290489 tag=TAG20170921T142807
channel prmy01: datafile copy complete, elapsed time: 00:03:15
Finished backup at 21-09-2017 14:31:23
released channel: prmy01
released channel: prmy02
released channel: stby01
released channel: stby02

RMAN> list copy of datafile 790;

specification does not match any datafile copy in the repository

RMAN> list copy of datafile 824;

specification does not match any datafile copy in the repository


Where are these two files ? Why such files are absent ?
Solution: Oracle don't register datafiles copied via auxiliary channels.
So you cannot find these files nether in prod or standby controlfiles.

And therefore you should remove these files manually.

Backup DB from Exadata to ZFS Backup Appliance

If you think about RMAN performance and your hardware is of high level or
if you will backup database from Exadata to the ZFS Storage Appliance 
                                  then look here :

• For backup to backupset and restore from backupset:
• _backup_disk_bufcnt=64
• _backup_disk_bufsz=4194304
• For image copy backup and restore:
• _backup_file_bufcnt=64
• _backup_file_bufsz=4194304

And references:

Configuring Oracle RMAN and the Oracle Database Instance: http://docs.oracle.com/cd/E28223_01/html/E27586/configappl.html  

MOS Note:  1072545.1: RMAN Performance Tuning Using Buffer Memory Parameters. 

And the nice presentation how to marriage the ZFSSA and Exadata: http://www.dbaexpert.com/DOUG%20Exadata%20with%20ZFS%20Storage%20Appliance.pdf