Thursday, December 10, 2009

V$BACKUP_SPFILE_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_SPFILE_DETAILS displays information about all restorable SP files backed up in the backup set.
Column
Datatype
Description
SESSION_KEY
NUMBER
Session identifier
SESSION_RECID
NUMBER
Session recid
SESSION_STAMP
NUMBER
Session stamp
BS_KEY
NUMBER
Unique backup set identifier
SET_STAMP
NUMBER
Backup set stamp
SET_COUNT
NUMBER
Backup set count
MODIFICATION_TIME
DATE
Time the backup set was modified
FILESIZE
NUMBER
Size, in bytes, of the SPFILE that was backed up
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_SPFILE_DETAILS.


Oracle data dictionary views

Last updated: 2009-12-09 Wednesday


No comments:

Post a Comment