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