SESSION_KEY |
NUMBER |
Session identifier. Use in joins with RC_RMAN_OUTPUT and RC_RMAN_BACKUP_JOB_DETAILS. |
SESSION_RECID |
NUMBER |
Together with SESSION_STAMP, uniquely identifies output for this backup job from RC_RMAN_OUTPUT. |
SESSION_STAMP |
NUMBER |
Together with SESSION_RECID, uniquely identifies output for this backup job from RC_RMAN_OUTPUT. |
DB_KEY |
NUMBER |
The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view. |
DB_NAME |
VARCHAR2(8) |
The DB_NAME of the database incarnation to which this record belongs. |
COPY_KEY |
NUMBER |
Unique identifier for this proxy copy. |
THREAD# |
NUMBER |
Redo thread number for the archived redo log file that was backed up. |
SEQUENCE# |
NUMBER |
Log sequence number for the archived redo log file that was backed up. |
RESETLOGS_CHANGE# |
NUMBER |
Checkpoint SCN of OPEN RESETLOGS for incarnation of the database of the archived redo log file that was backed up. |
RESETLOGS_TIME |
DATE |
Time corresponding to RESETLOGS_CHANGE#. |
HANDLE |
VARCHAR2(1024) |
A filename for the proxy copy. |
MEDIA |
VARCHAR2(80) |
A comment that contains further information about the media manager that created this backup. |
MEDIA_POOL |
NUMBER |
The number of the media pool in which the backup is stored. |
TAG |
VARCHAR2(32) |
Tag specified for this backup. |
FIRST_CHANGE# |
NUMBER |
First change SCN included in the archived redo log file. |
NEXT_CHANGE# |
NUMBER |
Next change SCN after this archived redo log file. |
FIRST_TIME |
DATE |
Time corresponding to FIRST_CHANGE#. |
NEXT_TIME |
DATE |
Time corresponding to NEXT_CHANGE#. |
OUTPUT_BYTES |
NUMBER |
Sum of sizes of all output pieces generated by this job. |
COMPLETION_TIME |
DATE |
The time at which the job was completed. |
OUTPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example, 798.01M or 5.25G. |
