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 | Data Type | 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 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(32K) |
Same value as INPUT_BYTES , but converted to a user-displayable format, for example, 798.01M or 5.25G. |
OUTPUT_BYTES_DISPLAY |
VARCHAR2(32K) |
Same value as OUTPUT_BYTES , but converted to a user-displayable format, for example, 798.01M or 5.25G. |