Skip Headers
Oracle® Database Backup and Recovery Reference
11g Release 1 (11.1)

Part Number B28273-01
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_COPY_SUMMARY

RC_BACKUP_COPY_SUMMARY contains summary information about all AVAILABLE control file and datafile copies for each database.

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, 798.01M or 5.25G.