7.104 V$BACKUP_SET
V$BACKUP_SET
displays information about backup sets from the control file.
A backup set record is inserted after the backup set is successfully completed.
Column | Datatype | Description |
---|---|---|
|
|
Backup set record ID |
|
|
Backup set record stamp |
|
|
Backup set stamp. The backup set stamp and count uniquely identify the backup set. Primary key for the |
|
|
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 re-created then the count is reset to Primary key for the |
|
|
Type of files that are in this backup. If the backup contains archived redo logs, the value is |
|
|
Provides information about the control file in the backup set:
|
|
|
Location where this backup set fits into the database's backup strategy. Set to NULL for full datafile, archivelog, controlfile, and spfile backups, set to 0 for incremental level 0 datafile backups, and set to 1 for incremental level 1 datafile backups. |
|
|
Number of distinct backup pieces in the backup set |
|
|
Starting time |
|
|
Time that this backup set completed |
|
|
The number of elapsed seconds |
|
|
Block size of the backup set |
|
|
|
|
|
( |
|
|
If |
|
|
Lists additional retention options for this backup set. Possible values are:
|
|
|
Indicates whether or not this backup set is a multi-section backup. Valid values are |
|
|
Indicates whether this is a cross platform backup set:
|
|
|
If the value of |
|
|
If the value of |
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
The GUID of the PDB to which the backup belongs. This is useful after the PDB is dropped to identify which PDB the backup belongs to. |