RC_BACKUP_ARCHIVELOG_SUMMARY contains summary information about backups of archived redo log files.
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 |
The number of archived redo log files backed up. |
NUM_DISTINCT_FILES_BACKED |
NUMBER |
The number of distinct archived redo log files backed up, where redo logs are distinguished by unique log sequence number, thread number, and resetlogs branch. |
MIN_FIRST_CHANGE# |
NUMBER |
The lowest SCN in the range of archived redo log files that have been backed up. |
MAX_NEXT_CHANGE# |
NUMBER |
The highest SCN in the range of archived redo log files that have been backed up. |
MIN_FIRST_TIME |
DATE |
The earliest point in time covered by the archived redo log files that have been backed up. |
MAX_NEXT_TIME |
DATE |
The latest point in time covered by the archived redo log files that have been backed up. |
INPUT_BYTES |
NUMBER |
The total size in bytes of all archived redo log files that have been backed up. |
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 |