|
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(81)
|
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
|
The starting time
|
|
COMPLETION_TIME
|
DATE
|
The completion time
|
|
ELAPSED_SECONDS
|
NUMBER
|
The 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.
|
