Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

RC_BACKUP_ARCHIVELOG_SUMMARY

RC_BACKUP_ARCHIVELOG_SUMMARY contains summary information about backups of archived redo log files.

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

Column Datatype 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 form a join with almost any other catalog view.
NUM_FILES_BACKED NUMBER The number of archived redo log files backed up.
NUM_DISTINCT_FILES_BACKED NUMBER The number of distinct archived redo log files backed up, where redo logs are distinguished by unique log sequence number, thread number, and resetlogs branch.
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 nM, nG, nT, nP