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