Thursday, December 10, 2009

V$BACKUP_SPFILE_SUMMARY

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_SUMMARY provides summary information for input SP file, based on either a backup job or time range applicable to jobs.
Column
Datatype
Description
NUM_FILES_BACKED
NUMBER
Number of files backed up
NUM_DISTINCT_FILES_BACKED
NUMBER
Number of distinct SP files backed up (with modification timestamp)
MIN_MODIFICATION_TIME
DATE
Minimum modification time
MAX_MODIFICATION_TIME
DATE
Maximum modification time
INPUT_BYTES
NUMBER
Total input bytes for all SP files backed up
INPUT_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for all input bytes

Note:

1.       The corresponding RMAN catalog view is RC_BACKUP_SPFILE_SUMMARY.


Oracle data dictionary views

Last updated: 2009-12-09 Wednesday

No comments:

Post a Comment