5.4 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.