RC_PROXY_ARCHIVELOG_SUMMARY

RC_PROXY_ARCHIVELOG_SUMMARY contains a summary of proxy copy backups of archived redo log files.

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 Total number of archived redo log files backed up.
NUM_DISTINCT_FILES_BACKED NUMBER Number of distinct archived redo log files backed up.
MIN_FIRST_CHANGE# NUMBER Minimum value for the first SCN of any redo log file in this summary.
MAX_NEXT_CHANGE# NUMBER Maximum value for the NEXT_CHANGE# SCN of any redo log file in this summary.
MIN_FIRST_TIME DATE Minimum value for the time of the first change in any redo log. Along with MAX_NEXT_TIME, forms the redo range.
MAX_NEXT_TIME DATE Maximum value for the time of the next change after any redo logs in this session.
OUTPUT_BYTES NUMBER Sum of sizes of all output pieces generated by this job.
OUTPUT_BYTES_DISPLAY VARCHAR2(4000) Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example, 798.01M or 5.25G.