Oracle: RMAN TIPS : What tapes you need to recall ?

You are doing your rman backup to tape. And lets say that you are trying to restore the database that was backed up to tape. So, what tapes do we need to recall ? Here’s the query to find the tapes that you need to recall.

set heading off  
column TAPE format a15 trunc  
column LEVEL format 99999  
column TYPE format a4 trunc  
select SET_COUNT, MEDIA as "TAPE",  
to_char(START_TIME, ‘MM/DD/YYYY HH24:MI:SS’) as "BACKUP TIME",  
INCREMENTAL_LEVEL as "LEVEL", BACKUP_TYPE as "TYPE"  
from RC_BACKUP_PIECE  
where DB_KEY=  
(select DB_KEY from RC_DATABASE_INCARNATION where CURRENT_INCARNATION=’YES’  
AND NAME=’<DB_NAME’)  
and START_TIME > to_date(’07/15/2007 20:00:00′, ‘MM/DD/YYYY HH24:MI:SS’);