V$BACKUP_DATAFILE: Data File Backup Information



Share this article :

V$BACKUP_DATAFILE displays information about control files and datafiles in backup sets from the control file.

RECID

Backup datafile record ID

STAMP

Backup datafile record stamp

SET_STAMP

Backup set stamp

SET_COUNT

Backup set count

FILE#

Datafile number; set to 0 for control file

CREATION_CHANGE#

Creation system change number (SCN) of the datafile

CREATION_TIME

Creation timestamp of the datafile

RESETLOGS_CHANGE#

Resetlogs system change number (SCN) of the datafile when it was backed up

RESETLOGS_TIME

Resetlogs timestamp of the datafile when it was backed up

INCREMENTAL_LEVEL

(0-4) incremental backup level

INCREMENTAL_CHANGE#

All blocks changed after incremental change# is included in this backup; set to 0 for a full backup

CHECKPOINT_CHANGE#

All changes up to checkpoint change# are included in this backup

CHECKPOINT_TIME

Timestamp of the checkpoint

ABSOLUTE_FUZZY_CHANGE#

Highest change# in this backup

MARKED_CORRUPT

Number of blocks marked corrupt

MEDIA_CORRUPT

Number of blocks media corrupt

LOGICALLY_CORRUPT

Number of blocks logically corrupt

DATAFILE_BLOCKS

Size of the datafile in blocks at backup time. This value is also the number of blocks taken by the datafile restarted from this backup.

BLOCKS

Size of the backup datafile (in blocks). Unused blocks are not copied to the backup.

BLOCK_SIZE

Block size

OLDEST_OFFLINE_RANGE

RECID of the oldest offline range record in this backup control file. 0 for datafile backups.

COMPLETION_TIME

Time completed

CONTROLFILE_TYPE

• B – Normal copies
• S – Standby copies

USED_CHANGE_TRACKING

Indicates whether change tracking data was used to accelerate this incremental backup (YES) or whether change tracking data was not used (NO)

BLOCKS_READ

Number of blocks that were scanned while taking this backup. If this was an incremental backup, and change tracking was used to optimize the backup, then the value of this column will be smaller than DATAFILE_BLOCKS. Otherwise, the value of this column will be the same as DATAFILE_BLOCKS. Even when change tracking data is used, the value of this column may be larger than BLOCKS, because the data read by change tracking is further refined during the process of creating an incremental backup.

Related posts

ORA-00257: archiver stuck
V$ACCESS: View Oracle Locked Objects & Session Accessing
Oracle TNSPING
TNS-00534: Failed to grant connection ownership to child
© 2017 ITsiti. All Rights Reserved
Powered by KEEM