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 |
Note:
1. V$BACKUP_SPFILE can be cleared using the following command on target database. After that there should be no rows in V$BACKUP_SPFILE. (Oracle support 283357.1)
| sqlplus> execute dbms_backup_restore.resetCfileSection(21); |
2. The corresponding RMAN catalog view is RC_BACKUP_SPFILE.
Oracle data dictionary views
| Last updated: 2009-12-09 Wednesday |