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
PDF · Mobi · ePub

RC_BACKUP_CONTROLFILE_SUMMARY

RC_BACKUP_CONTROLFILE_SUMMARY provides summary information about control file backups that can be restored, including backups in control file image copies, backup sets, and proxy copies.

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_FILES_BACKED NUMBER Total number of control file backups.
NUM_DISTINCT_FILES_BACKED NUMBER Number of distinct control files backed up.
MIN_CHECKPOINT_CHANGE# NUMBER Lowest checkpoint SCN among all backed up control file s.
MAX_CHECKPOINT_CHANGE# NUMBER Highest checkpoint SCN among all backed up control files.
MIN_CHECKPOINT_TIME DATE Earliest checkpoint time of any control file in the summary.
MAX_CHECKPOINT_TIME DATE Latest checkpoint time of any control file in the summary.
INPUT_BYTES NUMBER Total size of input files, in bytes.
OUTPUT_BYTES NUMBER Sum of sizes of all output pieces generated by this job.
COMPRESSION_RATIO NUMBER Compression ratio for this backup.
INPUT_BYTES_DISPLAY VARCHAR2(4000) Same value as INPUT_BYTES, but converted to a user-displayable format, for example nM, nG, nT, nP.
OUTPUT_BYTES_DISPLAY VARCHAR2(4000) Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example nM, nG, nT, nP.