GV$BACKUP_PIECE

select
inst_id,                 -- INST_ID NUMBER
bprid,                   -- RECID NUMBER
bpstm,                   -- STAMP NUMBER
bpbss,                   -- SET_STAMP NUMBER
bpbsc,                   -- SET_COUNT NUMBER
bpnum,                   -- PIECE# NUMBER
bitand                   -- COPY# NUMBER
  (bpflg, 12) /4 + (bitand (bpext, 64-1) * 4) + 1,
bpdev,                   -- DEVICE_TYPE VARCHAR2(17)
bphdl,                   -- HANDLE VARCHAR2(513)
bpcmt,                   -- COMMENTS VARCHAR2(64)
bpmdh,                   -- MEDIA VARCHAR2(65)
bitand                   -- MEDIA_POOL NUMBER
  (bpflg, 4080) / 16,
decode                   -- CONCUR VARCHAR2(3)
  (bitand (bpflg, 2), 1, 'YES', 'NO'),
bptag,                   -- TAG VARCHAR2(32)
decode                   -- STATUS VARCHAR2(1)
  (bitand (bpflg, 1+4096+8192), 0, 'A', 1, 'D', 4096, 'X', 8192, 'U', '?'),
decode                   -- DELETED VARCHAR2(3)
  (bitand (bpflg, 1), 1, 'YES', 'NO'),
to_date                  -- START_TIME DATE
  (bptsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_date                  -- COMPLETION_TIME DATE
  (bptim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
abs                      -- ELAPSED_SECONDS NUMBER
  ((to_date (bptim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') - to_date (bptsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')) *86400),
((floor                  -- BYTES NUMBER
  (bpext/512) * 4294967296) + bpsz1) * 512,
decode                   -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
  (bitand (bpflg, 16384), 0, 'NO', 'YES'),
bprsi,                   -- RMAN_STATUS_RECID NUMBER
bprst,                   -- RMAN_STATUS_STAMP NUMBER
decode                   -- COMPRESSED VARCHAR2(3)
  (bitand (bpext, 64), 64, 'YES', 'NO') 
from
x$kccbp
home |  up  |  mailbox