V$BACKUP_PIECE_DETAILS

V$BACKUP_PIECE_DETAILS displays information about all available backup pieces.

Column Datatype Description
SESSION_KEY NUMBER Session identifier
SESSION_RECID NUMBER Session recid
SESSION_STAMP NUMBER Session stamp
BS_KEY NUMBER Backup set identifier
BP_KEY NUMBER Backup piece key
RECID NUMBER Backup piece record ID
STAMP NUMBER Backup piece record stamp
SET_STAMP NUMBER Backup set stamp
SET_COUNT NUMBER Backup set count
PIECE# NUMBER Backup piece number (1-N)
COPY# NUMBER Indicates the copy number for backup pieces created with duplex enabled. The value is 1 if the backup piece is not duplexed.
DEVICE_TYPE VARCHAR2(17) Type of device on which the backup piece resides. Set to DISK for backup sets on disk.
HANDLE VARCHAR2(513) Backup piece handle identifies the backup piece on restore
COMMENTS VARCHAR2(64) Comments returned by the operating system or storage subsystem. Set to NULL for backup pieces on disk. This value is informational only. It is not needed for restore.
MEDIA VARCHAR2(65) Name of the media on which the backup piece resides. This value is informational only. It is not needed for restore.
MEDIA_POOL NUMBER The media pool in which the copy resides. This is the same value that was entered in the POOL operand of the Recovery Manager BACKUP command.
CONCUR VARCHAR2(3) (YES|NO) indicates whether or not the piece is on a media that can be accessed concurrently
TAG VARCHAR2(32) Backup piece tag. The tag is specified at backup set level, but stored at piece level.
STATUS VARCHAR2(1) Indicates the status of the piece: A (available), D (deleted), or X (expired)
START_TIME DATE Starting time
COMPLETION_TIME DATE Completion time
ELAPSED_SECONDS NUMBER Number of elapsed seconds
DELETED VARCHAR2(3) NO indicates that the file still exists. YES indicates that the file no longer exists because it has been deleted.
BYTES NUMBER Size of the backup piece, in bytes
IS_RECOVERY_DEST_FILE VARCHAR2(3) Indicates whether or not the file was created in the fast recovery area (YES) or not (NO)
RMAN_STATUS_RECID NUMBER Owning V$RMAN_STATUS record ID
RMAN_STATUS_STAMP NUMBER Owning V$RMAN_STATUS record stamp
COMPRESSED VARCHAR2(3) Indicates whether the backup piece is compressed (YES) or not (NO)
BACKED_BY_VSS VARCHAR2(3) Whether or not the file has been backed up by Volume Shadow Copy Service (VSS). This column is reserved for internal use.
ENCRYPTED VARCHAR2(3) A value of YES means an encrypted backup, otherwise not an encrypted backup.
BACKED_BY_OSB VARCHAR2(3) A value of YES means the backup was done to Oracle Secure Backup. Otherwise, backed up by other third party tape library.
PIECES_PER_SET NUMBER Number of backup pieces per set
SIZE_BYTES_DISPLAY VARCHAR2(4000) Size (in bytes) of the backup piece to display