SELECT bs.recid bs_key , bp.piece# piece# , bp.copy# copy# , bp.recid bp_key , DECODE( bs.controlfile_included , 'NO', '-' , bs.controlfile_included) controlfile_included , TO_CHAR(bs.completion_time, 'DD-MON-YYYY HH24:MI:SS') completion_time , DECODE( status , 'A', 'Available' , 'D', 'Deleted' , 'X', 'Expired') status , handle handle FROM v$backup_set bs , v$backup_piece bp WHERE bs.set_stamp = bp.set_stamp AND bs.set_count = bp.set_count AND bp.status IN ('A', 'X') AND bs.controlfile_included != 'NO' ORDER BY bs.recid , piece#;