RECID |
NUMBER |
Backup set record ID |
STAMP |
NUMBER |
Backup set record timestamp |
SET_STAMP |
NUMBER |
Backup set stamp. The backup set stamp and count uniquely identify the backup set
Primary key for the V$BACKUP_SET table, and the foreign key for the following tables: V$BACKUP_PIECE ; V$BACKUP_DATAFILE , V$BACKUP_REDOLOG ; V$BACKUP_CORRUPTION |
SET_COUNT |
NUMBER |
Backup set count. The backup set count is incremented by one every time a new backup set is started (if the backup set is never completed the number is "lost"). If the control file is recreated then the count is reset to 1. Therefore the count must be used with the stamp to uniquely identify a backup set
Primary key for the V$BACKUP_SET table, and the foreign key for the following tables: V$BACKUP_PIECE ; V$BACKUP_DATAFILE ; V$BACKUP_REDOLOG ; V$BACKUP_CORRUPTION |
BACKUP_TYPE |
VARCHAR2(1) |
Type of files that are in this backup. If the backup contains archived redo logs, the value is `L'. If this is a datafile full backup, the value is `D'. If this is an incremental backup, the value is `I' |
CONTROLFILE_INCLUDED |
VARCHAR2(3) |
Set to YES if there is a control file included in this backup set, otherwise set to NO |
INCREMENTAL_LEVEL |
NUMBER |
Location where this backup set fits into the database's backup strategy. Set to zero for full datafile backups, non-zero for incremental datafile backups, and NULL for archivelog backups |
PIECES |
NUMBER |
Number of distinct backup pieces in the backup set |
START_TIME |
DATE |
The starting time |
COMPLETION_TIME |
DATE |
The time that this backup set completed |
ELAPSED_SECONDS |
NUMBER |
The number of elapsed seconds |
BLOCK_SIZE |
NUMBER |
Block size of the backup set |