Oracle® Database Reference 11g Release 2 (11.2) E40402-08 |
|
|
PDF · Mobi · ePub |
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 |
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 |