V$BACKUP_ARCHIVELOG_SUMMARY provides archive log summary information based on archive logs in the backup set or on proxy copies.
| Column | Datatype | Description |
|---|---|---|
NUM_FILES_BACKED |
NUMBER |
Number of files backed up |
NUM_DISTINCT_FILES_BACKED |
NUMBER |
Number of distinct archive log files backed up |
MIN_FIRST_CHANGE# |
NUMBER |
Lowest SCN range value |
MAX_NEXT_CHANGE# |
NUMBER |
Highest SCN range value |
MIN_FIRST_TIME |
DATE |
Lowest SCN range time |
MAX_NEXT_TIME |
DATE |
Highest SCH range time |
INPUT_BYTES |
NUMBER |
Total input bytes read |
OUTPUT_BYTES |
NUMBER |
Output size of backups |
COMPRESSION_RATIO |
NUMBER |
Compression ratio |
INPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Displayable format for input bytes |
OUTPUT_BYTES_DISPLAY |
VARCHAR2(4000) |
Displayable format for output bytes |