V$BACKUP_ARCHIVELOG_DETAILS
contains information about all restorable archive logs. It will include all archived logs backed up in a backup set or proxy copies.
Column | Datatype | Description |
---|---|---|
BTYPE |
CHAR(9) |
Backup type container, either BACKUPSET or PROXYCOPY |
BTYPE_KEY |
NUMBER |
Unique identifier for the backup type. For BACKUPSET , it is BS_KEY . |
SESSION_KEY |
NUMBER |
Session identifier |
SESSION_RECID |
NUMBER |
Session recid |
SESSION_STAMP |
NUMBER |
Session stamp |
ID1 |
NUMBER |
If BACKUPSET , it contains SET_STAMP
If |
ID2 |
NUMBER |
If BACKUPSET , it contains SET_COUNT
If |
THREAD# |
NUMBER |
Thread number |
SEQUENCE# |
NUMBER |
Sequence number |
RESETLOGS_CHANGE# |
NUMBER |
Resetlogs change SCN |
RESETLOGS_TIME |
DATE |
Resetlogs change time |
FIRST_CHANGE# |
NUMBER |
First change SCN |
FIRST_TIME |
DATE |
First change time |
NEXT_CHANGE# |
NUMBER |
Next change SCN |
NEXT_TIME |
DATE |
Next change time |
FILESIZE |
NUMBER |
File size |
COMPRESSION_RATIO |
NUMBER |
Compression ratio |
FILESIZE_DISPLAY |
VARCHAR2(4000) |
Same value as the FILESIZE column, but converted to a user-displayable format, for example n M, n G, n T, n P, and so on |