Jared, Are you thinking the RMAN PREVIEW command? http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov003 .htm#CFADHADH <http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov00 3.htm#CFADHADH> David -----Original Message----- From: Jared Still [mailto:jkstill@xxxxxxxxx] Sent: Thursday, April 12, 2007 12:26 PM To: Oracle-L Freelists Subject: RMAN report I *know* there is an RMAN report or a SQL query that can be run to show exactly which files will be needed to do a database restore. Problem is, I can't remember how to do it, and can't seem to find it either via google or (gasp) reading the docs. Does someone here recall how to do this? Thanks, -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist