Like clause should be used only for copy
RMAN> delete copy of database like
2> '+DATA/cvrman/datafile/us%'
3> device type disk;
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
released channel: ORA_DISK_5
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=24 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=25 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=58 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=60 device type=DISK
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
78 4 A 18-MAY-14 1246607 17-MAY-14
Name: +DATA/cvrman/datafile/users.dbf
Tag: CPY_DB
75 4 A 17-MAY-14 1246607 17-MAY-14
Name: +DATA/cvrman/datafile/users.340.847803041
Tag: CPY_DB
Do you really want to delete the above objects (enter YES or NO)?
