Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 13 of 211


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 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback