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 |