RC_BACKUP_COPY_SUMMARY contains summary information all AVAILABLE control file and datafile copies.
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_COPIES |
NUMBER |
Total number of image copy backups. |
NUM_DISTINCT_COPIES |
NUMBER |
Number of distinct image copy backups. |
MIN_CHECKPOINT_CHANGE# |
NUMBER |
Minimum checkpoint SCN among all image copy backups described in this view. |
MAX_CHECKPOINT_CHANGE# |
NUMBER |
Maximum checkpoint SCN among all image copy backups described in this view. |
MIN_CHECKPOINT_TIME |
DATE |
Earliest checkpoint time among all copies described in this view. |
MAX_CHECKPOINT_TIME |
DATE |
Latest checkpoint time among all copies described in this view. |
OUTPUT_BYTES |
NUMBER |
Sum of sizes of all datafile and control file copies. |
OUTPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example nM, nG, nT, nP. |