Wednesday, December 16, 2009

V$BACKUP_DATAFILE_DETAILS


V$BACKUP_DATAFILE_DETAILS contains information about restorable datafiles. It will include all datafiles backed in the backup set, image copies, and proxy copies.
Column
Datatype
Description
BTYPE
CHAR(9)
Backup type container. Possible values are: BACKUPSET, IMAGECOPY, PROXYCOPY.
BTYPE_KEY
NUMBER
Unique identifier for the backup type. For BACKUPSET, it is BS_KEY.
SESSION_KEY
NUMBER
Session identifier
SESSION_RECID
NUMBER
Session record ID
SESSION_STAMP
NUMBER
Session stamp
ID1
NUMBER
If BACKUPSET, it contains SET_STAMP.
If IMAGECOPY or PROXYCOPY, it is RECID from the control file.
ID2
NUMBER
If BACKUPSET, it contains SET_COUNT.
If IMAGECOPY or PROXYCOPY, it is STAMP.
FILE#
NUMBER
File number
CREATION_CHANGE#
NUMBER
File creation change SCN
CREATION_TIME
DATE
File creation time
RESETLOGS_CHANGE#
NUMBER
Resetlogs change SCN
RESETLOGS_TIME
DATE
Resetlogs change time
INCREMENTAL_LEVEL
NUMBER
Incremental level
INCREMENTAL_CHANGE#
NUMBER
Incremental change SCN
CHECKPOINT_CHANGE#
NUMBER
Checkpoint change SCN
CHECKPOINT_TIME
DATE
Checkpoint change time
MARKED_CORRUPT
NUMBER
Number of blocks marked corrupt
FILESIZE
NUMBER
File size, in bytes
COMPRESSION_RATIO
NUMBER
Compression ratio
TS#
NUMBER
Tablespace number
TSNAME
VARCHAR2(30)
Tablespace name
FILESIZE_DISPLAY
VARCHAR2(4000)
Same value as the FILESIZE column, but converted to a user-displayable format, for example nM, nG, nT, nP, and so on

Note:

1.       The corresponding RMAN catalog view is RC_BACKUP_DATAFILE_DETAILS.


Oracle data dictionary views

Last updated: 2009-12-15 Tuesday

No comments:

Post a Comment