RC_BACKUP_ARCHIVELOG_SUMMARY

RC_BACKUP_ARCHIVELOG_SUMMARY summarizes the backup of archived redo log files for a single or for multiple RMAN jobs.

This view is primarily intended to be used internally by Enterprise Manager.

Column Data Type Description
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 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 log files 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(32K) Same value as INPUT_BYTES, but converted to a user-displayable format, for example nM, nG, nT, nP.
OUTPUT_BYTES_DISPLAY VARCHAR2(32K) Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example, 798.01M or 5.25G.