BTYPE |
CHAR(9) |
The type of this control file backup. Possible values are BACKUPSET, IMAGECOPY or PROXYCOPY. |
BTYPE_KEY |
NUMBER |
Unique identifier for the backup type. If BTYPE is BACKUPSET, this value is the BS_KEY value for the backup set. If BTYPE is IMAGECOPY, this value is the value of COPY_KEY for the copy. If BTYPE is PROXYCOPY, this is the value of XCF_KEY for the proxy copy. |
SESSION_KEY |
NUMBER |
Session identifier. Use in joins with RC_RMAN_OUTPUT. |
SESSION_RECID |
NUMBER |
The RECID from the control file for the target database which corresponds to this RMAN session. |
SESSION_STAMP |
NUMBER |
The STAMP from the control file for the target database which corresponds to this RMAN session. |
DB_KEY |
NUMBER |
The primary key for this database. |
DB_NAME |
VARCHAR2(8) |
The DB_NAME of the database incarnation to which this record belongs. |
ID1 |
NUMBER |
For backups taken as backup sets, this column contains SET_STAMP. For proxy copy or image copy backups, this column contains the RECID from the control file. |
ID2 |
NUMBER |
For backups taken as backup sets, this column contains SET_COUNT. For proxy copy or image copy backups, this column contains the value of STAMP. |
CREATION_TIME |
DATE |
File creation time for the control file that was backed up. |
RESETLOGS_CHANGE# |
NUMBER |
SCN of the resetlogs branch where this control file was backed up. |
RESETLOGS_TIME |
DATE |
Time of the resetlogs branch where this control file was backed up. |
CHECKPOINT_CHANGE# |
NUMBER |
Most recent checkpoint change SCN for the control file that was backed up. |
CHECKPOINT_TIME |
DATE |
Most recent checkpoint time for the control file that was backed up. |
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 nM, nG, nT, nP |
