Hi, Hrishy. the output

SQL> select b.name,a.completion_time,
2 a.media,a.status,a.handle
3 from rc_backup_piece a,
4 rc_database b
5 where a.DB_KEY=b.DB_KEY
6 and handle in
7 ('/makkdb1-bk/rman/4fiq9uj1_1_1','/makkdb1-bk/rman/4giq9uko_1_1')
8 order by b.name,a.completion_time,a.status;

NAME COMPLETIO MEDIA
-------- --------- --------------------------------------------------------------------------------
S
-
HANDLE
----------------------------------------------------------------------------------------------------
RACDB 25-AUG-07
X
/makkdb1-bk/rman/4fiq9uj1_1_1

RACDB 25-AUG-07
X
/makkdb1-bk/rman/4giq9uko_1_1