Identify RMAN Backupsets Needed

[lesstjm]

I have a question about RMAN backupsets. I have Oracle 10.2.0.3 and Solaris.

I am doing restores of prod databases on my UAT server for testing. I do not have access to the prod RMAN files they are scp'd to my server by another DBA in another country. I restore from these all the time with no issue.

My question is , Is there a report that I can run against the prod catalog that will list every file I will need to restore? Sometimes a file is missing and it will kill my restore so I want some type of double check to ensure what was sent to my server is everything I need.

[BeefStu]

Will this work for you? Than check the Piece Name:

RMAN> list backupset tag 'TAG20110725T010017';


List of Backup Sets
===================

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
389 165.34M DISK 00:00:06 07-25-2011 01:00:24
BP Key: 391 Status: AVAILABLE Compressed: NO Tag: TAG20110725T010017
Piece Name: /backup/dmartdev/arch/arch_DMARTDEV_t757386018_s2_p1

List of Archived Logs in backup set 389
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 2 11838750316070 07-24-2011 17:36:31 11838750410407 07-25-2011 01:00:11

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
390 488.35M DISK 00:00:10 07-25-2011 01:00:28
BP Key: 392 Status: AVAILABLE Compressed: NO Tag: TAG20110725T010017
Piece Name: /backup/dmartdev/arch/arch_DMARTDEV_t757386018_s1_p1

List of Archived Logs in backup set 390
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 1 11838750249389 07-24-2011 16:21:16 11838750316070 07-24-2011 17:36:31