V$BACKUP_PIECE

V$BACKUP_PIECE displays information about backup pieces from the control file. Each backup set consists of one or more backup pieces.

Column Datatype Description
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. 1 if the backup piece is not duplexed.
DEVICE_TYPE VARCHAR2(17) Type of the device on which the backup piece resides. Set to DISK for backup sets on disk.

See Also: V$BACKUP_DEVICE

HANDLE VARCHAR2(513) Backup piece handle identifies the backup piece on restore
COMMENTS VARCHAR2(64) Comment returned by the operating system or storage subsystem. Set to NULL for backup pieces on disk. This value is informational only; not needed for restore.
MEDIA VARCHAR2(65) Name of the media on which the backup piece resides. This value is informational only; 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 the piece 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) (YES/NO) NO indicates that the file still exists. YES indicates 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 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.