Tuesday, December 15, 2009

V$BACKUP_ARCHIVELOG_DETAILS

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