GV$DELETED_OBJECT

select
inst_id,                 -- INST_ID NUMBER
dlrid,                   -- RECID NUMBER
dlstm,                   -- STAMP NUMBER
decode                   -- TYPE VARCHAR2(26)
  (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', 251, 'BACKUP PIECE UNAVAILABLE', 250, 'PROXY COPY UNAVAILABLE', 249, 'DATAFILE COPY AVAILABLE', 248, 'DATAFILE COPY EXPIRED', 247, 'DATAFILE COPY UNAVAILABLE', 246, 'ARCHIVED LOG AVAILABLE', 245, 'ARCHIVED LOG EXPIRED', 244, 'ARCHIVED LOG UNAVAILABLE', 243, 'BACKUP SET KEEP OPTIONS', 242, 'BACKUP SET KEEP UNTIL', 241, 'PROXY COPY KEEP OPTIONS', 240, 'PROXY COPY KEEP UNTIL', 239, 'DATAFILE COPY KEEP OPTIONS', 238, 'DATAFILE COPY KEEP UNTIL', 237, 'DATAFILE RENAME ON RESTORE', 236, 'TEMPFILE RENAME', 'UNKNOWN'),
dlobp,                   -- OBJECT_RECID NUMBER
dlosm,                   -- OBJECT_STAMP NUMBER
dltsd                    -- OBJECT_DATA NUMBER
from
x$kccdl
home |  up  |  mailbox