V$BACKUP_SPFILE
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 |
CON_ID |
NUMBER |
The ID of the container to which the data pertains. Possible values include:
|
GUID |
RAW(16) |
The GUID of the PDB to which the backup belongs. This is useful after the PDB is dropped to identify which PDB the backup belongs to. |