V$BACKUP_SPFILE

叁歲伎倆 2023-10-18 21:35 19阅读 0赞

## V$BACKUP\_SPFILE ##

`V$BACKUP_SPFILE` displays information about server parameter files in backup sets from the control file.

<table> 
 <thead> 
  <tr> 
   <th>Column</th> 
   <th>Datatype</th> 
   <th>Description</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td><code>RECID</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Backup SPFILE record ID</td> 
  </tr> 
  <tr> 
   <td><code>STAMP</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Backup SPFILE record stamp</td> 
  </tr> 
  <tr> 
   <td><code>SET_STAMP</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Backup set stamp (of the set which contains this SPFILE backup)</td> 
  </tr> 
  <tr> 
   <td><code>SET_COUNT</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Backup set count (of the set which contains this SPFILE backup)</td> 
  </tr> 
  <tr> 
   <td><code>MODIFICATION_TIME</code></td> 
   <td><code>DATE</code></td> 
   <td>Time when the SPFILE was last modified (this also includes creation time)</td> 
  </tr> 
  <tr> 
   <td><code>BYTES</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Size of the SPFILE (in bytes)</td> 
  </tr> 
  <tr> 
   <td><code>COMPLETION_TIME</code></td> 
   <td><code>DATE</code></td> 
   <td>Time when the backup of the SPFILE completed</td> 
  </tr> 
  <tr> 
   <td><code>DB_UNIQUE_NAME</code></td> 
   <td><code>VARCHAR2(30)</code></td> 
   <td>Unique database name</td> 
  </tr> 
 </tbody> 
</table>

V$BACKUP_SPFILE

发表评论取消回复

还没有评论，来说两句吧...

相关阅读