Thank you for visiting Spatial DBA - Oracle and ArcSDE.
I have stopped updating the blog.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
===============================================================
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 |
No comments:
Post a Comment