RC_PROXY_COPY_SUMMARY

RC_PROXY_COPY_SUMMARY contains aggregate information about all available proxy copy backups for databases registered in the recovery catalog.

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

Column Data Type Description
DB_KEY NUMBER The primary key for this database.
DB_NAME VARCHAR2(8) The DB_NAME of the database incarnation to which this record belongs.
NUM_COPIES NUMBER Number of copies created by all proxy copy operations for this database.
NUM_DISTINCT_COPIES NUMBER Number of distinct copies created by all proxy copy operations for this database.
MIN_CHECKPOINT_CHANGE# NUMBER Minimum checkpoint SCN among any proxy copies for this database.
MAX_CHECKPOINT_CHANGE# NUMBER Maximum checkpoint SCN among any proxy copies for this database.
MIN_CHECKPOINT_TIME DATE The oldest checkpoint time among any proxy copies for this database.
MAX_CHECKPOINT_TIME DATE The most recent checkpoint time among any proxy copies for this database.
OUTPUT_BYTES NUMBER Sum of sizes of all output files generated by proxy copies.
OUTPUT_BYTES_DISPLAY VARCHAR2(32K) Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example, 798.01M or 5.25G.