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