|
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, nonzero 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 |
|
INPUT_FILE_SCAN_ONLY |
VARCHAR2(3) |
YES indicates no actual backup is performed, but the datafiles are read. NO indicates a normal backup is performed. |
|
KEEP |
VARCHAR2(3) |
(YES/NO) Indicates whether or not this backup set has a retention policy that is different than the value for the configure retention policy |
|
KEEP_UNTIL |
DATE |
If KEEP_UNTIL_TIME is specified, this is the date after which the backup becomes obsolete. If this column is null, then the backup never expires. |
|
KEEP_OPTIONS |
VARCHAR2(10) |
Lists additional retention options for this backup set. Possible values are:
LOGS - The logs need to recover this backup are kept
NOLOGS - The logs needed to recover this backup will not be kept |
