GV$DELETED_OBJECT

select
inst_id,                 -- INST_ID NUMBER
dlrid,                   -- RECID NUMBER
dlstm,                   -- STAMP NUMBER
decode                   -- TYPE VARCHAR2(22)
  (dltyp, 11, 'ARCHIVED LOG', 13, 'BACKUP PIECE', 16, 'DATAFILE COPY', 20, 'PROXY COPY', 255, 'BACKUP PIECE AVAILABLE', 254, 'BACKUP PIECE EXPIRED', 253, 'PROXY COPY AVAILABLE', 252, 'PROXY COPY EXPIRED', 'UNKNOWN'),
dlobp,                   -- OBJECT_RECID NUMBER
dlosm                    -- OBJECT_STAMP NUMBER
from
x$kccdl
home |  up  |  mailbox