Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

RC_BACKUP_SET_SUMMARY

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