RC_BACKUP_SET_SUMMARY
provides aggregate information about available backup sets for each database registered in the recovery catalog.
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_BACKUPSETS |
NUMBER |
Total number of available backup sets recorded in the recovery catalog for this database. |
OLDEST_BACKUP_TIME |
DATE |
Creation time of the oldest available backup set recorded in the recovery catalog for this database. |
NEWEST_BACKUP_TIME |
DATE |
Creation time of the newest available backup set recorded in the recovery catalog for this database. |
OUTPUT_BYTES |
NUMBER |
Sum of sizes of all backup pieces for all available backup sets recorded in the recovery catalog for this database. |
ORIGINAL_INPUT_BYTES |
NUMBER |
Sum of sizes of all input files for all available backup sets recorded in the recovery catalog forthis database. |
ORIGINAL_INPRATE_BYTES |
NUMBER |
Average input rate in bytes forthe creation of all available backup sets recorded in the recovery catalog for this database. |
OUTPUT_RATE_BYTES |
NUMBER |
Average output rate in bytes forthe creation of all available backup sets recorded in the recovery catalog for this database. |
COMPRESSION_RATIO |
NUMBER |
Aggregate compression ratio for all available backup sets recorded in the recovery catalog for this database. |
ORIGINAL_INPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Total size of all input files stored in all available backup sets recorded in the recovery catalog for this database. |
OUTPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Same value as OUTPUT_BYTES , but converted to a user-displayable format, for example nM, nG, nT, nP. |
ORIGINAL_INPRATE_BYTES_DISPLAY |
VARCHAR2(4000) |
Same value as ORIGINAL_INPRATE_BYTES , but converted to a user-displayable format, for example nM, nG, nT, nP.. |
OUTPUT_RATE_BYTES_DISPLAY |
VARCHAR2(4000) |
Same value as OUTPUT_RATE_BYTES , but converted to a user-displayable format, for example nM, nG, nT, nP.. |