Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$BACKUP_DATAFILE

This view displays backup datafile and backup control file information from the control file.

Column Datatype Description

RECID

NUMBER

Backup datafile record ID

STAMP

NUMBER

Backup datafile record stamp

SET_STAMP

NUMBER

Backup set stamp

SET_COUNT

NUMBER

Backup set count

FILE#

NUMBER

Datafile number; set to 0 for control file

CREATION_CHANGE#

NUMBER

Creation change of the datafile

CREATION_TIME

DATE

Creation timestamp of the datafile

RESETLOGS_CHANGE#

NUMBER

Resetlogs change# of the datafile when it was backed up

RESETLOGS_TIME

DATE

Resetlogs timestamp of the datafile when it was backed up

INCREMENTAL_LEVEL

NUMBER

(0-4) incremental backup level

INCREMENTAL_CHANGE#

NUMBER

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

CHECKPOINT_CHANGE#

NUMBER

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

CHECKPOINT_TIME

DATE

Timestamp of the checkpoint

ABSOLUTE_FUZZY_CHANGE#

NUMBER

Highest change# in this backup

MARKED_CORRUPT

NUMBER

Number of blocks marked corrupt

MEDIA_CORRUPT

NUMBER

Number of blocks media corrupt

LOGICALLY_CORRUPT

NUMBER

Number of blocks logically corrupt

DATAFILE_BLOCKS

NUMBER

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

NUMBER

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

BLOCK_SIZE

NUMBER

Block size

OLDEST_OFFLINE_RANGE

NUMBER

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

COMPLETION_TIME

DATE

The time completed

CONTROLFILE_TYPE

VARCHAR2(1)

B indicates normal copies

S indicates standby copies