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