C.1.3 Using V$BACKUP_DATAFILE with Oracle Exadata Storage Server
The V$BACKUP_DATAFILE view contains columns relevant to Oracle Exadata Storage Server during Oracle Recovery Manager (RMAN) incremental backups.
Table C-2 V$BACKUP_DATAFILE Columns and Descriptions
| Column | Description |
|---|---|
|
|
Size of the backup data file in blocks. |
|
|
The number of blocks that were scanned while taking this backup. If this is an incremental backup, and block change tracking was used to optimize the backup, then the value of this column is smaller than |
|
|
The number of blocks that were read and filtered at the Oracle Exadata Storage Server to optimize the RMAN incremental backup. |
|
|
Size of the data file in blocks at backup time. This value is also the number of blocks taken by the data file restarted from this backup. |
The percentage of blocks skipped by Oracle Exadata System Software is calculated as follows:
(BLOCKS_SKIPPED_IN_CELL / BLOCKS_READ) * 100
This number changes significantly based on block change tracking.
If block change tracking for fast incremental backups is used, then most of the filtering is done at the database using the change tracking file, and the blocks are skipped before making an I/O request to the cell. If block change tracking is not used, then all of the blocks are filtered at the cell.
Parent topic: Oracle Database Dictionary Views