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')