V$BACKUP_PIECE definition in Oracle Database 11.2
V$BACKUP_PIECE

select
  RECID,                                   -- RECID NUMBER
  STAMP,                                   -- STAMP NUMBER
  SET_STAMP,                               -- SET_STAMP NUMBER
  SET_COUNT,                               -- SET_COUNT NUMBER
  PIECE#,                                  -- PIECE# NUMBER
  COPY#,                                   -- COPY# NUMBER
  DEVICE_TYPE,                             -- DEVICE_TYPE VARCHAR2(17)
  HANDLE,                                  -- HANDLE VARCHAR2(513)
  COMMENTS,                                -- COMMENTS VARCHAR2(64)
  MEDIA,                                   -- MEDIA VARCHAR2(65)
  MEDIA_POOL,                              -- MEDIA_POOL NUMBER
  CONCUR,                                  -- CONCUR VARCHAR2(3)
  TAG,                                     -- TAG VARCHAR2(32)
  STATUS,                                  -- STATUS VARCHAR2(1)
  START_TIME,                              -- START_TIME DATE
  COMPLETION_TIME,                         -- COMPLETION_TIME DATE
  ELAPSED_SECONDS,                         -- ELAPSED_SECONDS NUMBER
  DELETED,                                 -- DELETED VARCHAR2(3)
  BYTES,                                   -- BYTES NUMBER
  IS_RECOVERY_DEST_FILE,                   -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
  RMAN_STATUS_RECID,                       -- RMAN_STATUS_RECID NUMBER
  RMAN_STATUS_STAMP,                       -- RMAN_STATUS_STAMP NUMBER
  COMPRESSED,                              -- COMPRESSED VARCHAR2(3)
  BACKED_BY_VSS,                           -- BACKED_BY_VSS VARCHAR2(3)
  ENCRYPTED,                               -- ENCRYPTED VARCHAR2(3)
  BACKED_BY_OSB                            -- BACKED_BY_OSB VARCHAR2(3)
from
  GV$BACKUP_PIECE
where
  inst_id = USERENV('Instance')

home |  up