V$BACKUP_PIECE

8.97 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.
`FOR_XTTS`	`VARCHAR2(3)`	Indicates whether this is a cross platform backup piece: `YES`: This is a cross platform backup piece. `NO`: This is not a cross platform backup piece.
`SAME_ENDIAN`	`VARCHAR2(3)`	If the value of `FOR_XTTS` is `YES`, then this column indicates whether the backup piece has the same endianess as the current database (`YES`) or not (`NO`); otherwise `NULL`.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data
`GUID`	`RAW(16)`	The GUID of the PDB to which the backup belongs. This is useful after the PDB is dropped to identify which PDB the backup belongs to.