7.96 V$BACKUP_DATAFILE_DETAILS
V$BACKUP_DATAFILE_DETAILS
contains information about restorable data files.
It will include all data files backed in the backup set, image copies, and proxy copies.
Column | Datatype | Description |
---|---|---|
|
|
Backup type container. Possible values are: |
|
|
Unique identifier for the backup type. For |
|
|
Session identifier |
|
|
Session record ID |
|
|
Session stamp |
|
|
If If |
|
|
If If |
|
|
File number |
|
|
File creation change SCN |
|
|
File creation time |
|
|
Resetlogs change SCN |
|
|
Resetlogs change time |
|
|
Normal full backups have a NULL value, level 0 incremental backups have a value of 0, and level 1 incremental backups have a value of 1 |
|
|
Incremental change SCN |
|
|
Checkpoint change SCN |
|
|
Checkpoint change time |
|
|
Number of blocks marked corrupt |
|
|
File size, in bytes |
|
|
The ratio between the total blocks in the datafile and the blocks that RMAN backed up. This is not the the ratio from the |
|
|
Indicates whether the file is sparse ( |
|
|
Tablespace number |
|
|
Tablespace name |
|
|
Same value as the |
|
|
The ID of the container to which the data pertains. Possible values include:
|