| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
V$BACKUP_SPFILE displays information about server parameter files in backup sets from the control file.
| Column | Datatype | Description | 
|---|---|---|
| RECID | NUMBER | Backup SPFILE record ID | 
| STAMP | NUMBER | Backup SPFILE record stamp | 
| SET_STAMP | NUMBER | Backup set stamp (of the set which contains this SPFILE backup) | 
| SET_COUNT | NUMBER | Backup set count (of the set which contains this SPFILE backup) | 
| MODIFICATION_TIME | DATE | Time when the SPFILE was last modified (this also includes creation time) | 
| BYTES | NUMBER | Size of the SPFILE (in bytes) | 
| COMPLETION_TIME | DATE | Time when the backup of the SPFILE completed | 
| DB_UNIQUE_NAME | VARCHAR2(30) | Unique database name |