BTYPE

CHAR(9)

The backup type container, which can be BACKUPSET, IMAGECOPY, or PROXYCOPY.

BTYPE_KEY

NUMBER

A unique identifier for the backup type. For backup sets, it is VS_KEY; for image copies, it is COPY_KEY; for proxy copies it is XAL_KEY.

SESSION_KEY

NUMBER

Unique identifier for this session. Use for joins with RC_RMAN_BACKUP_JOB_DETAILS.

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 in the recovery catalog. Use this column to join with almost any other catalog view.

DB_NAME

VARCHAR2(8)

The DB_NAME of the database incarnation to which this record belongs.

ID1

NUMBER

For archived logs in 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 archived logs in backup sets, this column contains SET_COUNT. For image copy or proxy copy backups, this column contains STAMP.

THREAD#

NUMBER

Thread number of this archived redo log file.

SEQUENCE#

NUMBER

Sequence number of this archived redo log file.

RESETLOGS_CHANGE#

NUMBER

SCN of OPEN RESETLOGS branch for this archived log.

RESETLOGS_TIME

DATE

Time of OPEN RESETLOGS branch for this archived log.

FIRST_CHANGE#

NUMBER

Starting SCN for this archived log file.

FIRST_TIME

DATE

Time corresponding to starting SCN for this archived redo log file.

NEXT_CHANGE#

NUMBER

Ending SCN for this archived redo log file.

NEXT_TIME

DATE

Time corresponding to the ending SCN for this archived redo log file.

FILESIZE

NUMBER

Size of backed up redo log file, in bytes.

COMPRESSION_RATIO

NUMBER

Compression ratio for this backup.

FILESIZE_DISPLAY

VARCHAR2(32K)

Same value as FILESIZE, but converted to a user-displayable format, for example, 798.01M or 5.25G.