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