V$RECOVER_FILE

红太狼 2023-10-08 08:31 2阅读 0赞

## V$RECOVER\_FILE ##

This view displays the status of files needing media recovery.

<table> 
 <thead> 
  <tr> 
   <th>Column</th> 
   <th>Datatype</th> 
   <th>Description</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td><code>FILE#</code></td> 
   <td><code>NUMBER</code></td> 
   <td>File identifier number</td> 
  </tr> 
  <tr> 
   <td><code>ONLINE</code></td> 
   <td><code>VARCHAR2(7)</code></td> 
   <td>This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in&nbsp;<code>ONLINE_STATUS</code>.</td> 
  </tr> 
  <tr> 
   <td><code>ONLINE_STATUS</code></td> 
   <td><code>VARCHAR2(7)</code></td> 
   <td>Online status (<code>ONLINE</code>,&nbsp;<code>OFFLINE</code>)</td> 
  </tr> 
  <tr> 
   <td><code>ERROR</code></td> 
   <td><code>VARCHAR2(18)</code></td> 
   <td>Why the file needs to be recovered: NULL if reason unknown, or&nbsp;<code>OFFLINE NORMAL</code>&nbsp;if recovery not needed</td> 
  </tr> 
  <tr> 
   <td><code>CHANGE#</code></td> 
   <td><code>NUMBER</code></td> 
   <td>SCN where recovery must start</td> 
  </tr> 
  <tr> 
   <td><code>TIME</code></td> 
   <td><code>DATE</code></td> 
   <td>Time of SCN when recovery must start</td> 
  </tr> 
 </tbody> 
</table>

V$RECOVER_FILE

发表评论取消回复

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

相关阅读