V$BACKUP_ARCHIVELOG_DETAILS

红太狼 2023-10-18 21:35 37阅读 0赞

## V$BACKUP\_ARCHIVELOG\_DETAILS ##

`V$BACKUP_ARCHIVELOG_DETAILS` contains information about all restorable archive logs. It will include all archived logs backed up in a backup set or proxy copies.

<table> 
 <thead> 
  <tr> 
   <th>Column</th> 
   <th>Datatype</th> 
   <th>Description</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td><code>BTYPE</code></td> 
   <td><code>CHAR(9)</code></td> 
   <td>Backup type container, either&nbsp;<code>BACKUPSET</code>&nbsp;or&nbsp;<code>PROXYCOPY</code></td> 
  </tr> 
  <tr> 
   <td><code>BTYPE_KEY</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Unique identifier for the backup type. For&nbsp;<code>BACKUPSET</code>, it is&nbsp;<code>BS_KEY</code>.</td> 
  </tr> 
  <tr> 
   <td><code>SESSION_KEY</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Session identifier</td> 
  </tr> 
  <tr> 
   <td><code>SESSION_RECID</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Session recid</td> 
  </tr> 
  <tr> 
   <td><code>SESSION_STAMP</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Session stamp</td> 
  </tr> 
  <tr> 
   <td><code>ID1</code></td> 
   <td><code>NUMBER</code></td> 
   <td>If&nbsp;<code>BACKUPSET</code>, it contains&nbsp;<code>SET_STAMP</code> <p>If&nbsp;<code>PROXYCOPY</code>, it is&nbsp;<code>RECID</code>&nbsp;from the control file</p> </td> 
  </tr> 
  <tr> 
   <td><code>ID2</code></td> 
   <td><code>NUMBER</code></td> 
   <td>If&nbsp;<code>BACKUPSET</code>, it contains&nbsp;<code>SET_COUNT</code> <p>If&nbsp;<code>PROXYCOPY</code>, it is&nbsp;<code>STAMP</code></p> </td> 
  </tr> 
  <tr> 
   <td><code>THREAD#</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Thread number</td> 
  </tr> 
  <tr> 
   <td><code>SEQUENCE#</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Sequence number</td> 
  </tr> 
  <tr> 
   <td><code>RESETLOGS_CHANGE#</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Resetlogs change SCN</td> 
  </tr> 
  <tr> 
   <td><code>RESETLOGS_TIME</code></td> 
   <td><code>DATE</code></td> 
   <td>Resetlogs change time</td> 
  </tr> 
  <tr> 
   <td><code>FIRST_CHANGE#</code></td> 
   <td><code>NUMBER</code></td> 
   <td>First change SCN</td> 
  </tr> 
  <tr> 
   <td><code>FIRST_TIME</code></td> 
   <td><code>DATE</code></td> 
   <td>First change time</td> 
  </tr> 
  <tr> 
   <td><code>NEXT_CHANGE#</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Next change SCN</td> 
  </tr> 
  <tr> 
   <td><code>NEXT_TIME</code></td> 
   <td><code>DATE</code></td> 
   <td>Next change time</td> 
  </tr> 
  <tr> 
   <td><code>FILESIZE</code></td> 
   <td><code>NUMBER</code></td> 
   <td>File size</td> 
  </tr> 
  <tr> 
   <td><code>COMPRESSION_RATIO</code></td> 
   <td><code>NUMBER</code></td> 
   <td>Compression ratio</td> 
  </tr> 
  <tr> 
   <td><code>FILESIZE_DISPLAY</code></td> 
   <td><code>VARCHAR2(4000)</code></td> 
   <td>Same value as the&nbsp;<code>FILESIZE</code>&nbsp;column, but converted to a user-displayable format, for example&nbsp;<code>n</code>M,&nbsp;<code>n</code>G,&nbsp;<code>n</code>T,&nbsp;<code>n</code>P, and so on</td> 
  </tr> 
 </tbody> 
</table>

V$BACKUP_ARCHIVELOG_DETAILS

发表评论取消回复

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

相关阅读