V$BACKUP 深碍√TFBOYSˉ_ 2023-10-08 08:32 34阅读 0赞 ## V$BACKUP ## `V$BACKUP` displays the backup status of all online datafiles. <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</td> </tr> <tr> <td><code>STATUS</code></td> <td><code>VARCHAR2(18)</code></td> <td>File status: <code>NOT ACTIVE</code>, <code>ACTIVE</code> (backup in progress), <code>OFFLINE NORMAL</code>, or description of an error. <p><code>NOT ACTIVE</code> indicates that the file is not currently in backup mode (that is, an <code>ALTER TABLESPACE ... BEGIN BACKUP</code> or <code>ALTER DATABASE BEGIN BACKUP</code> statement has not been issued), whereas <code>ACTIVE</code> indicates that the file is currently in backup mode.</p> </td> </tr> <tr> <td><code>CHANGE#</code></td> <td><code>NUMBER</code></td> <td>System change number when backup started</td> </tr> <tr> <td><code>TIME</code></td> <td><code>DATE</code></td> <td>Time the backup started</td> </tr> </tbody> </table>
还没有评论，来说两句吧...