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 | Datatype | 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(4000) |
Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example, 798.01M or 5.25G. |