RMAN Catalog Query

RMAN Catalog Query
===================
alter session set nls_date_format='DD-MON-YY HH24:MI:SS';

col handle format a50
select HANDLE,START_TIME,COMPLETION_TIME,status,concur
from RC_BACKUP_PIECE
where DB_ID=(select dbid from v$database)
and COMPLETION_TIME >= sysdate-3
order by COMPLETION_TIME