Know the file # Of datafile and find out which backuppiece the datafile belongs,

Know the file # Of datafile and find out which backuppiece the datafile belongs,

F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 23 09:41:48 2015Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options09:41:49 sys@FS> col handle format a4009:41:59 sys@FS> set line 20009:42:13 sys@FS> select d.file#, p.handle09:42:16   2    from v$backup_piece p, v$backup_datafile d09:42:16   3    where d.set_stamp = p.set_stamp09:42:17   4      and d.set_count = p.set_count09:42:17   5      and d.file# = 2;     FILE# HANDLE---------- ----------------------------------------         2         2         2         2         2         2         2         2         2         2         2         2         2         2         2         2         2         2         2         2 H:\FSARCH\FULL_HOPVUMAD_1_120 rows selected.Elapsed: 00:00:00.0509:42:18 sys@FS>

Reference:
How To Locate What Files Are Backed Up In What RMAN Backup Set (Document ID 246189.1)