F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 23 09:41:48 2015
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
09:41:49 sys@FS> col handle format a40
09:41:59 sys@FS> set line 200
09:42:13 sys@FS> select d.file#, p.handle
09:42:16 2 from v$backup_piece p, v$backup_datafile d
09:42:16 3 where d.set_stamp = p.set_stamp
09:42:17 4 and d.set_count = p.set_count
09: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_1
20 rows selected.
Elapsed: 00:00:00.05
09:42:18 sys@FS>知道datafile的file#,查询出该datafile在哪个backuppiece中
原文：http://blog.csdn.net/msdnchina/article/details/43915527