V$BACKUP_CONTROLFILE_SUMMARY provides control file summary information, based on either a backup set of files, image copies, or proxy copies.
| Column | Datatype | Description |
|---|---|---|
NUM_FILES_BACKED |
NUMBER |
Number of files backed up for specific criteria |
NUM_DISTINCT_FILES_BACKED |
NUMBER |
Number of distinct files backed up |
MIN_CHECKPOINT_CHANGE# |
NUMBER |
Minimum checkpoint change number of the datafile for specified criteria |
MAX_CHECKPOINT_CHANGE# |
NUMBER |
Maximum checkpoint change number of the datafile for specified criteria |
MIN_CHECKPOINT_TIME |
DATE |
Minimum checkpoint time of the datafile for specified criteria |
MAX_CHECKPOINT_TIME |
DATE |
Maximum checkpoint time of the datafile for specified criteria |
INPUT_BYTES |
NUMBER |
Total input bytes of files read |
OUTPUT_BYTES |
NUMBER |
Total output bytes written |
COMPRESSION_RATIO |
NUMBER |
The ratio between the total blocks in the datafile and the blocks that RMAN backed up. This is not the the ratio from the AS COMPRESSED BACKUPSET clause of the BACKUP command. |
INPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Displayable format for input bytes |
OUTPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Displayable format for output bytes |