DB_NAME |
VARCHAR2(8) |
The DB_NAME of the database incarnation to which this record belongs. |
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. |
NUM_FILES_BACKED |
NUMBER |
The number of archived redo log files backed up. If an archived log is included in more than on backup job, then RMAN counts each backup separately.
For example, if the view summarizes two RMAN backup jobs, each of which backs up only archived log 1000, then the value of this column is 2 and the value of NUM_DISTINCT_FILES_BACKED is 1.
|
NUM_DISTINCT_FILES_BACKED |
NUMBER |
The number of distinct archived redo logs backed up, where files are distinguished by unique log sequence number, thread number, and RESETLOGS branch.
For example, if the view summarizes two RMAN backup jobs, each of which backs up only archived log 1000, then the value of this column is 1 and the value of NUM_FILES_BACKED is 2.
|
MIN_FIRST_CHANGE# |
NUMBER |
The lowest SCN in the range of archived redo log files that have been backed up. |
MAX_NEXT_CHANGE# |
NUMBER |
The highest SCN in the range of archived redo log files that have been backed up. |
MIN_FIRST_TIME |
DATE |
The earliest point in time covered by the archived redo log files that have been backed up. |
MAX_NEXT_TIME |
DATE |
The latest point in time covered by the archived redo log files that have been backed up. |
INPUT_BYTES |
NUMBER |
The total size in bytes of all archived redo log files that have been backed up. |
OUTPUT_BYTES |
NUMBER |
Sum of sizes of all output pieces generated by this job. |
COMPRESSION_RATIO |
NUMBER |
Compression ratio for this backup. |
INPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Same value as INPUT_BYTES, but converted to a user-displayable format, for example nM, nG, nT, nP. |
OUTPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example, 798.01M or 5.25G. |
