Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$BACKUP_DATAFILE_DETAILS

V$BACKUP_DATAFILE_DETAILS contains information about restorable data files. It will include all data files 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 Normal full backups have a NULL value, level 0 incremental backups have a value of 0, and level 1 incremental backups have a value of 1
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 The ratio between the total blocks in the datafile and the blocks that RMAN backed up. This is not the the ratio from the AS COMPRESSED BACKUPSET clause of the BACKUP command.
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
CON_ID NUMBER The ID of the container to which the data pertains. Possible values include:
  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data