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. |