V$BACKUP_CONTROLFILE_DETAILS
contains information about restorable control files. It will include all the control files backed up 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, either BS_KEY or COPY_KEY . |
SESSION_KEY |
NUMBER |
Session identifier |
SESSION_RECID |
NUMBER |
Session recid |
SESSION_STAMP |
NUMBER |
Session stamp |
ID1 |
NUMBER |
If BACKUPSET , it contains SET_STAMP
If |
ID2 |
NUMBER |
If BACKUPSET , it contains SET_COUNT
If |
CREATION_TIME |
DATE |
File creation time |
RESETLOGS_CHANGE# |
NUMBER |
Resetlogs change SCN |
RESETLOGS_TIME |
DATE |
Resetlogs change time |
CHECKPOINT_CHANGE# |
NUMBER |
Checkpoint change SCN |
CHECKPOINT_TIME |
DATE |
Checkpoint change time |
FILESIZE |
NUMBER |
File size, in bytes, for the output of backing up this control file |
COMPRESSION_RATIO |
NUMBER |
Compression ratio for this backup |
FILESIZE_DISPLAY |
VARCHAR2(4000) |
Same value as the FILESIZE column, but converted to a user-displayable format, for example n M, n G, n T, n P, and so on |