Dynamic Performance (V$) Views, 16 of 179

V$BACKUP_SET

This view displays backup set information from the control file. A backup set record is inserted after the backup set is successfully completed.

Column Datatype Description

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

Column	Datatype	Description
`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