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