RC_BACKUP_DATAFILE_SUMMARY

RC_BACKUP_DATAFILE_SUMMARY provides summary information about available backups of data files.

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 in the recovery catalog. Use this column to join with almost any other catalog view.
DB_NAME VARCHAR2(8) The DB_NAME of the database incarnation to which this record belongs.
NUM_FILES_BACKED NUMBER Number of data files backed up for this value of DB_KEY and DB_NAME.
NUM_DISTINCT_FILES_BACKED NUMBER Number of distinct files backed up for this value of DB_KEY and DB_NAME.
NUM_DISTINCT_TS_BACKED NUMBER Number of distinct tablespaces backed up for this value of DB_KEY and DB_NAME.
MIN_CHECKPOINT_CHANGE# NUMBER Minimum checkpoint of any data file backed up for this value of DB_KEY and DB_NAME.
MAX_CHECKPOINT_CHANGE# NUMBER Maximum checkpoint change number of any data file backed up for this value of DB_KEY and DB_NAME.
MIN_CHECKPOINT_TIME DATE Minimum checkpoint time for any data file backed up for this value of DB_KEY and DB_NAME.
MAX_CHECKPOINT_TIME DATE Maximum checkpoint time for any data file backed up for this value of DB_KEY and DB_NAME.
INPUT_BYTES NUMBER Total input bytes read for all files backed up for this value of DB_KEY and DB_NAME.
OUTPUT_BYTES NUMBER Sum of sizes of all output pieces generated by backups for this value of DB_KEY and DB_NAME.
COMPRESSION_RATIO NUMBER Compression ratio across all backups.
INPUT_BYTES_DISPLAY VARCHAR2(4000) Same value as INPUT_BYTES, but converted to a user-displayable format, for example, 798.01M or 5.25G.
OUTPUT_BYTES_DISPLAY VARCHAR2(4000) Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example, 798.01M or 5.25G.