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 |
