Skip Headers
Oracle® Database Backup and Recovery Reference
11g Release 2 (11.2)

Part Number E10643-05
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
PDF · Mobi · ePub

RC_BACKUP_DATAFILE_SUMMARY

RC_BACKUP_DATAFILE_SUMMARY provides summary information about available backups of datafiles.

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 datafiles 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 datafile backed up for this value of DB_KEY and DB_NAME.
MAX_CHECKPOINT_CHANGE# NUMBER Maximum checkpoint change number of any datafile backed up for this value of DB_KEY and DB_NAME.
MIN_CHECKPOINT_TIME DATE Minimum checkpoint time for any datafile backed up for this value of DB_KEY and DB_NAME.
MAX_CHECKPOINT_TIME DATE Maximum checkpoint time for any datafile 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.