Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


RC_BACKUP_SPFILE_SUMMARY provides summary information about SPFILE backups for databases registered in the recovery catalog.

This view is primarily intended to be used internally by Enterprise Manager.

Column Datatype Description
DB_NAME VARCHAR2(8) The DB_NAME of the database incarnation to which this record belongs.
DB_KEY NUMBER The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view.
NUM_FILES_BACKED NUMBER Number of files backed up.
NUM_DISTINCT_FILES_BACKED NUMBER Number of distinct files backed up (based on differing modification timestamps).
MIN_MODIFICATION_TIME DATE Earliest modification time of any SPFILE backed up for this database.
MAX_MODIFICATION_TIME DATE Latest modification time of any SPFILE backed up for this database.
INPUT_BYTES NUMBER Total number of bytes in the input files backed up.
INPUT_BYTES_DISPLAY VARCHAR2(4000) Same value as INPUT_BYTES, but converted to a user-displayable format, for example nM, nG, nT, nP.