Thank you for visiting Spatial DBA - Oracle and ArcSDE.
I have stopped updating the blog.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
===============================================================
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 PROXYCOPY, it is RECID from the control file |
ID2 | NUMBER | If BACKUPSET, it contains SET_COUNT If PROXYCOPY, it is STAMP |
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 nM, nG, nT, nP, and so on |
Note:
1. The corresponding RMAN catalog view is RC_BACKUP_ARCHIVELOG_DETAILS.
Oracle data dictionary views
Last updated: 2009-12-15 Tuesday |
No comments:
Post a Comment