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